import xlwt
book = xlwt.Workbook(encoding='utf-8',style_compression=0)
sheet = book.add_sheet('会计一班',cell_overwrite_ok=True) #新建sheet
col = ('姓名','成绩')
for i in range(len(col)):
sheet.write(0,i,col[i]) #在0行i列写入表头
with open('1.txt','r',encoding='utf-8') as file:
lines = file.readlines()
for i in range(len(lines)):
word = lines[i].split() #split()以空格分割成列表
for j in range(len(col)):
sheet.write(i+1,j,word[j]) #在i+1行j列写入数据
#sheet.write(i+1,j,word[j]+'\n'+'111') 单元格内换行写111,但要双击单元格才能看到效果
book.save('C:\\Users\\Jenkin_Zhu\\Desktop\\output.xls')
输入:
输出:
str.split( char,n )的用法:对str用char分割n次返回数组。如www.baidu.com的split('.',1)[0]的结果为www。
补充:CSV是逗号分隔文件,在excel中打开效果同表格
# 写csv,从列表转换要用','.join;把csv读成列表要用split(',')
str1 = "姓名,武力,智力"
list2 = ["曹仁",'90','70']
with open('new.csv','w',encoding='UTF-8') as f:
f.write(str1 + '\n')
f.write(','.join(list2))