Python的Excel处理模块:XlsxWriter

jopen 11年前

XlsxWriter是一个Python模块,用于创建Excel XLSX文件。
intro01.png
它支持以下功能:

XlsxWriter supports the following features:    * 100% compatible Excel XLSX files.  * Write text, numbers, formulas, dates to cells.  * Write hyperlinks to cells.  * Full cell formatting.  * Multiple worksheets.  * Charts.  * Page setup methods for printing.  * Merged cells.  * Defined names.  * Autofilters.  * Data validation and drop down lists.  * Conditional formatting.  * Worksheet PNG/JPEG images.  * Rich multi-format strings.  * Cell comments.  * Document properties.  * Worksheet cell protection.  * Freeze and split worksheet panes.  * Worksheet Tables.  * Sparklines.  * Outlines and Grouping.  * Memory optimisation mode for writing large files.  * Standard libraries only.  * Python 2.6, 2.7, 3.1, 3.2 and 3.3 support.

示例代码:

    from xlsxwriter.workbook import Workbook                # 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()

项目主页:http://www.open-open.com/lib/view/home/1374562003574