如何使用xlsxwriter 写入数据到xlsx excel 设置边框实线连续内存模式

设置边框实线

cell_format = workbook.add_format({'border':1})

worksheet.conditional_format('A1:XFD1048576', {'type': 'no_blanks', 'format': cell_format})

设置连续内存模式，适合大数据输出

import xlsxwriter

book = 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()

参考
https://github.com/jmcnamara/XlsxWriter

大内存
https://www.csdn.net/tags/OtDakg3sNTgwMzEtYmxvZwO0O0OO0O0O.html

设置表格边框
https://blog.csdn.net/weixin_43054437/article/details/123021279