python xlsx转xls_使用python将tsv文件转换为xls / xlsx - IT屋-程序员软件开发技术分享社区...

I want to convert a file in tsv format to xls/xlsx..

I tried using

os.rename("sample.tsv","sample.xlsx")

But the file getting converted is corrupted. Is there any other method of doing it?

解决方案

Here is a simple example of converting TSV to XLSX using XlsxWriter and the core csv module:

import csv

from xlsxwriter.workbook import Workbook

# Add some command-line logic to read the file names.

tsv_file = 'sample.tsv'

xlsx_file = 'sample.xlsx'

# Create an XlsxWriter workbook object and add a worksheet.

workbook = Workbook(xlsx_file)

worksheet = workbook.add_worksheet()

# Create a TSV file reader.

tsv_reader = csv.reader(open(tsv_file, 'rb'), delimiter='\t')

# Read the row data from the TSV file and write it to the XLSX file.

for row, data in enumerate(tsv_reader):

worksheet.write_row(row, 0, data)

# Close the XLSX file.

workbook.close()