python 写入excel

XlsxWriter是基于Python的，用来操作Excel的库。100%支持xlsx文件的写入操作。

示例代码：

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

fromxlsxwriter.workbook importWorkbook

     

# Create an new Excel file and add a worksheet.

workbook =Workbook('demo.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 highlight cell text.

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

 

# 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()