我把txt文件数据输入Word表格中出现这种情况,还会出现名称可以写入表格,但是数据写入不了,请问该怎么改?
这是部分数据
205c -4248.7840194
127n 11.095004310167
23a 11.2456067097867
import numpy as np
import docx
from docx import Document
file = 's.energy.txt'
f = open(file)
lines = f.readlines()
list1 = []
list2 = []
line_data = []
for line in lines:
a = line.split()
line_data.append(a)
data = np.array(line_data)
need_data = data[0:14,1]
need_name = data[0:14,0]
f.close()
for j in need_name:
list1.append(j)
for i in need_data:
list2.append(i)
file_name = 'ca.docx'
doc = docx.Document(file_name)
table = doc.add_table(rows=len(need_name)*3, cols=4)
cells = table.rows[0].cells
for col in range(4):
for row in range(len(need_name) * 3):
for x in list1:
for y in list2:
if (row+1)%3==0:
a=row+1
table.cell(row,col).text = np.round(float(y),2)#这行出现问题,其他正常运行,有时候不报错但是文件里没有数据
if row==a-1:
table.cell(row,col).text = x
doc.save('1'+file_name)
```