以下所有内容翻译至: https://xlsxwriter.readthedocs.io/
#-------------------------------------------------------------------------------------------------------------------------------
XlsxWriter 是一个用来创建Excel XLSX 文件的Python 模块。
demo:
demo 代码:
###################################################################################
##############################################################################
#
# A simple example of some of the features of the XlsxWriter Python module.
#
# Copyright 2013-2018, John McNamara, jmcnamara@cpan.org # import xlsxwriter #导入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. #用‘A1’等表达方式在单元格中写入简单的文本 worksheet.write('A1', 'Hello') # Text with formatting. #在单元格中写入文本的同时设置格式 worksheet.write('A2', 'World', bold) # Write some numbers, with row/column notation. #用行列号的表达方式(从00开始)在单元格写入数值 worksheet.write(2, 0, 123) worksheet.write(3, 0, 123.456) # Insert an image. #在单元格中插入图片 worksheet.insert_image('B5', 'logo.png') workbook.close() #关闭工作簿,只有关闭工作簿,文档才会最终显示;
#################################################################################################################
XlsxWriter
XlsxWriter 是一个Python模块,用这个模块可以实现在2007以上版本的exel格式为xlsx的文件中添加多个工作表并且可以插入文本,数字,公式,超链接等。它支持例如格式等很多功能,包含如下:
100% 和excel xlsx 文件兼容;
支持所有格式;
支持合并单元格;
定义名字;
图表;
筛选;
数据验证和下拉列表;
条件格式;
工作表插入PNG/JPEG/GMP/WMF/WMF 图片;
富文本格式字符串;
单元格注释;
文本框组件;
联合Pndas模块;
写入大文件时支持记忆优化模式;
它支持Python 2.5,2.6,2.7,3.1,3.2,3.3,3.4,3.5,3.6等版本,Jython和PyPy 只使用标准库。
这个文件解释了怎么使用xlsxwrite 模块,阅读下面的章节来了解更多内容,或者直接跳到 Introduction。
- Content
- Introduction
- Getting Started with XlsxWriter
- ---------------------------------------------------------------------------------
- Tutorial 1: Create a simple XLSX file
- Tutorial 2: Adding formatting to the XLSX file
- Tutorial 3:Writting different types of data to the XLSX file
- --------------------------------------------------------------------------------
- The Workbook Class
- The Worksheet Class
- The Worbook Class(Page Setup)
- The Format Class
- The Chart Class
- The Chartsheet Class
- The Exceptions Class
- ------------------------------------------------------------------------------
- Working with Cell Notation
- Working with Formulas
- Working with Dates and Times
- Working with Colors
- Working with Charts
- Working with Autofilters
- Working with Data Validation
- Working with Conditional Formatting
- Working with Worksheet Tables
- Working with Textboxes
- Working with Sparklines
- Working with Cell Comments
- Working with Outlines and Grouping
- Working with Memory and Performance
- Working with VBA Macros
- Working with Python Pandas and XlsxWriter
- ----------------------------------------------------------------------------------
- Examples
- ----------------------------------------------------------------------------------
- Chart Examples
- ----------------------------------------------------------------------------------
- Pandas with XlsxWriter Examples
- ----------------------------------------------------------------------------------
- Alternative modules for handing Excel files
- Libraries that use or enhance XlsxWriter
- Known Issues and Bugs
- Reporting Bugs
- Frequently Asked Questions
- Changes in XlsxWriter
- Author
- License