python处理xlsx方式

import xlsxwriter

import datetime

import time

workbook = xlsxwriter.Workbook('F://test_voice//test.xlsx')

worksheet = workbook.add_worksheet()

with open('F://test_voice//demo.txt','r',encoding='utf-8') as f:

cnt = 0

tmp = []

for line in f.readlines():

if cnt %3 == 0:

tmp.append(line.split(' ')[0]+'.wav')

cnt += 1

worksheet.write_column('A1', tmp)

workbook.close()