第一种：xlwt

import xlwt
f = open(file_new,encoding="gbk")
xls = xlwt.Workbook()
#生成excel的方法，声明excel
sheet = xls.add_sheet('sheet1', cell_overwrite_ok=True)x = 0
while True:# 按行循环，读取文本文件line = f.readline()if not line:break  # 如果没有内容，则退出循环for i in range(len(line.split('\t'))):item = line.split('\t')[i]sheet.write(x, i, item)  # x单元格经度，i 单元格纬度x += 1  # excel另起一行f.close()

第二种：openpyxl

import openpyxl
from openpyxl.utils import get_column_letter
f = open(file_new,encoding="gbk")
wb = openpyxl.Workbook()
ws = wb.active
ws = wb.create_sheet()
ws.title = 'Sheet1'
row = 0
for line in f:row +=1line = line.strip()line = line.split('\t')col = 0
for j in range(len(line)):col += 1ws.cell(column= col,row = row,value=line[j].format(get_column_letter(col)))
wb.save("保存的文件名" )

第三种：xlsxwriter

import xlsxwriterwo = xlsxwriter.Workbook("文件名.xlsx")sheet = wo.add_worksheet()x = 0while True:# 按行循环，读取文本文件line = f.readline()if not line:break  # 如果没有内容，则退出循环for i in range(len(line.split('\t'))):item = line.split('\t')[i]sheet.write(x, i, item)  # x单元格经度，i 单元格纬度x += 1  # excel另起一行wo.close()