设置边框实线
cell_format = workbook.add_format({'border':1})worksheet.conditional_format('A1:XFD1048576', {'type': 'no_blanks', 'format': cell_format})
设置连续内存模式，适合大数据输出
import xlsxwriterbook = xlsxwriter.Workbook(filename='./test.xlsx',options={# 全局设置'strings_to_numbers': True, # str 类型数字转换为 int 数字'strings_to_urls': False, # 自动识别超链接'constant_memory': False, # 连续内存模式 (True 适用于大数据量输出)'default_format_properties': {'font_name': '微软雅黑', # 字体. 默认值 "Arial"'font_size': 10, # 字号. 默认值 11# 'bold': False, # 字体加粗# 'border': 1, # 单元格边框宽度. 默认值 0# 'align': 'left', # 对齐方式# 'valign': 'vcenter', # 垂直对齐方式# 'text_wrap': False, # 单元格内是否自动换行# ...},})sheet = book.add_worksheet('sheet 1')# 在全局设置的基础上创建样式my_format = book.add_format({'fg_color': 'yellow', # 单元格填充颜色. 常用的颜色可以用单词描述. 自定义的颜色可以用 '#FFFFFF' 这样描述})sheet.write(0, 0, 'hello', my_format)book.close()
workbook = xlsxwriter.Workbook(download_directory + f'LUK_CMH_{today}.xlsx')worksheet = workbook.add_worksheet('data-export')for index, value in enumerate(col):worksheet.write(0, index, value.get('Title'))for index, value in enumerate(rows):for col_index, col_value in enumerate(value):worksheet.write(index + 1, col_index, col_value)# print('col_value', col_value)workbook.close()
xlwt只能写入到xls，需要用xlsxwriter写入xlsx文件
import xlsxwriter# Create an new Excel file and add a worksheet.workbook = xlsxwriter.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 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)# Insert an image.worksheet.insert_image('B5', 'logo.png')workbook.close()
参考
/jmcnamara/XlsxWriter
大内存
/tags/OtDakg3sNTgwMzEtYmxvZwO0O0OO0O0O.html
设置表格边框
/weixin_43054437/article/details/123021279
