将txt中的数据按行读取出来(我的txt数据每行都是字符串),进行数据分割和转换后即可将多张txt数据对应写入excel的工作表中。
import openpyxl
emg = {'channel1': [], 'channel2': [], 'channel3': [], 'channel4': []}
# 更改此处地址,需要添加到工作簿中的txt文件数据
with open("EMGdata/es6.txt", "r", encoding="utf-8") as file:
for item in file:
emg['channel1'].append(int(item.split('\n')[0][2:5]))
emg['channel2'].append(int(item.split('\n')[0][9:12]))
emg['channel3'].append(int(item.split('\n')[0][16:19]))
emg['channel4'].append(int(item.split('\n')[0][23:26]))
# 将数据写进excel文件中
wb = openpyxl.load_workbook('D:/Desktop/emg.xlsx')
# 更改创建的表格名称,并将表格放在工作簿的位置
ws = wb.create_sheet('emg6', index=6)
ws.cell(1, 1).value = '序号'
ws.cell(1, 2).value = 'channel1'
ws.cell(1, 3).value = 'channel2'
ws.cell(1, 4).value = 'channel3'
ws.cell(1, 5).value = 'channel4'
for i in range(len(emg['channel1'])):
ws.cell(i+2, 1).value = i
ws.cell(i+2, 2).value = emg['channel1'][i]
ws.cell(i+2, 3).value = emg['channel2'][i]
ws.cell(i+2, 4).value = emg['channel3'][i]
ws.cell(i+2, 5).value = emg['channel4'][i]
wb.save('D:/Desktop/emg.xlsx')