xlsxwriter

XlsxWriter是一个用于创建Excel XLSX文件的Python模块。

直接生成一个文件，并写入

import xlsxwriter

workbook = xlsxwriter.Workbook('hello_world.xlsx')
worksheet = workbook.add_worksheet()

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

workbook.close()

 

修改字体颜色及加粗等格式处理

import xlsxwriter

workbook = xlsxwriter.Workbook('hello_world.xlsx')
worksheet = workbook.add_worksheet()

cell_format = workbook.add_format()
cell_format.set_bold()
cell_format.set_font_color('red')

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

workbook.close()

下表显示了Excel的格式类别、可以应用的格式属性和等效对象方法:

Category	Description	Property	Method Name
Font	Font type	'font_name'	set_font_name()
	Font size	'font_size'	set_font_size()
	Font color	'font_color'	set_font_color()
	Bold	'bold'	set_bold()
	Italic	'italic'	set_italic()
	Underline	'underline'	set_underline()
	Strikeout	'font_strikeout'	set_font_strikeout()
	Super/Subscript	'font_script'	set_font_script()
Number	Numeric format	'num_format'	set_num_format()
Protection	Lock cells	'locked'	set_locked()
	Hide formulas	'hidden'	set_hidden()
Alignment	Horizontal align	'align'	set_align()
	Vertical align	'valign'	set_align()
	Rotation	'rotation'	set_rotation()
	Text wrap	'text_wrap'	set_text_wrap()
	Reading order	'reading_order'	set_reading_order()
	Justify last	'text_justlast'	set_text_justlast()
	Center across	'center_across'	set_center_across()
	Indentation	'indent'	set_indent()
	Shrink to fit	'shrink'	set_shrink()
Pattern	Cell pattern	'pattern'	set_pattern()
	Background color	'bg_color'	set_bg_color()
	Foreground color	'fg_color'	set_fg_color()
Border	Cell border	'border'	set_border()
	Bottom border	'bottom'	set_bottom()
	Top border	'top'	set_top()
	Left border	'left'	set_left()
	Right border	'right'	set_right()
	Border color	'border_color'	set_border_color()
	Bottom color	'bottom_color'	set_bottom_color()
	Top color	'top_color'	set_top_color()
	Left color	'left_color'	set_left_color()
	Right color	'right_color'	set_right_color()

 

官方网站：

https://xlsxwriter.readthedocs.io/format.html

https://xlsxwriter.readthedocs.io