python如何编写excel_如何用Python编写Excel

是的，CSV和TSV文件非常容易处理，特别是与Excel相比，Excel中有各种各样的对象、格式等。请尝试使用下面的简单脚本来写入Excel文件。在import xlsxwriter

# Create an new Excel file and add a worksheet.

workbook = xlsxwriter.Workbook('C:/your_path/test.xlsx')

worksheet = workbook.add_worksheet()

# Widen the first column to make the text clearer.

worksheet.set_column('A:A', 20)

# Add a bold format to use to highlight cells.

bold = workbook.add_format({'bold': True})

# Write some simple text.

worksheet.write('A1', 'Hello')

# Text with formatting.

worksheet.write('A2', 'World', bold)

# Write some numbers, with row/column notation.

worksheet.write(2, 0, 123)

worksheet.write(3, 0, 123.456)

workbook.close()

***********************************************************************************

from openpyxl import Workbook

wb = Workbook()

# grab the active worksheet

ws = wb.active

# Data can be assigned directly to cells

ws['A1'] = 42

# Rows can also be appended

ws.append([1, 2, 3])

# Python types will automatically be converted

import datetime

ws['A2'] = datetime.datetime.now()

# Save the file

wb.save("C:\your_path\\sample.xlsx")