xlsxwriter.lua
Contents
Contents
Introduction
Getting Started with xlsxwriter
Tutorial 1: Create a simple XLSX file
Tutorial 2: Adding formatting to the XLSX File
Tutorial 3: Writing different types of data to the XLSX File
The Workbook Class
The Worksheet Class
The Worksheet Class (Page Setup)
The Format Class
Working with Formats
Working with Cell Notation
Cell Utility Functions
Working with Dates and Time
Working with Colors
Working with Memory and Performance
Examples
Known Issues and Bugs
Reporting Bugs
Frequently Asked Questions
Changes in XlsxWriter
Author
License
Page
Contents
« Creating Exce...
Introduction »
Contents
Introduction
Getting Started with xlsxwriter
Installing xlsxwriter
Running a sample program
Documentation
Tutorial 1: Create a simple XLSX file
Tutorial 2: Adding formatting to the XLSX File
Tutorial 3: Writing different types of data to the XLSX File
The Workbook Class
Constructor
workbook:add_worksheet()
workbook:add_format()
workbook:close()
workbook:set_properties()
workbook:define_name()
workbook:worksheets()
The Worksheet Class
worksheet:write()
worksheet:write_string()
worksheet:write_number()
worksheet:write_formula()
worksheet:write_array_formula()
worksheet:write_blank()
worksheet:write_boolean()
worksheet:write_date_time()
worksheet:write_date_string()
worksheet:write_url()
worksheet:set_row()
worksheet:set_column()
worksheet:get_name()
worksheet:activate()
worksheet:select()
worksheet:hide()
worksheet:set_first_sheet()
worksheet:merge_range()
worksheet:set_zoom()
worksheet:right_to_left()
worksheet:hide_zero()
worksheet:set_tab_color()
worksheet:protect()
The Worksheet Class (Page Setup)
worksheet:set_landscape()
worksheet:set_portrait()
worksheet:set_page_view()
worksheet:set_paper()
worksheet:center_horizontally()
worksheet:center_vertically()
worksheet:set_margins()
worksheet:set_header()
worksheet:set_footer()
worksheet:repeat_rows()
worksheet:repeat_columns()
worksheet:hide_gridlines()
worksheet:print_row_col_headers()
worksheet:print_area()
worksheet:print_across()
worksheet:fit_to_pages()
worksheet:set_start_page()
worksheet:set_print_scale()
worksheet:set_h_pagebreaks()
worksheet:set_v_pagebreaks()
The Format Class
format:set_font_name()
format:set_font_size()
format:set_font_color()
format:set_bold()
format:set_italic()
format:set_underline()
format:set_font_strikeout()
format:set_font_script()
format:set_num_format()
format:set_locked()
format:set_hidden()
format:set_align()
format:set_center_across()
format:set_text_wrap()
format:set_rotation()
format:set_indent()
format:set_shrink()
format:set_text_justlast()
format:set_pattern()
format:set_bg_color()
format:set_fg_color()
format:set_border()
format:set_bottom()
format:set_top()
format:set_left()
format:set_right()
format:set_border_color()
format:set_bottom_color()
format:set_top_color()
format:set_left_color()
format:set_right_color()
Working with Formats
Creating and using a Format object
Format methods and Format properties
Format Colors
Format Defaults
Modifying Formats
Working with Cell Notation
Relative and Absolute cell references
Cell Utility Functions
rowcol_to_cell()
rowcol_to_cell_abs()
cell_to_rowcol()
col_to_name()
range()
range_abs()
Working with Dates and Time
Working with Colors
Working with Memory and Performance
Performance Figures
Examples
Example: Hello World
Example: Simple Feature Demonstration
Example: Adding hyperlinks
Example: Array formulas
Example: Merging Cells
Example: Adding Defined Names
Example: Write UTF-8 Strings
Example: Convert a UTF-8 file to a Worksheet
Example: Setting Document Properties
Example: Setting Worksheet Tab Colours
Example: Hiding Worksheets
Example: Adding Headers and Footers to Worksheets
Example: Indenting Text in a Cell
Example: Enabling Cell protection in Worksheets
Known Issues and Bugs
Content is Unreadable. Open and Repair
Formulas displayed as
#NAME?
until edited
Formula results displaying as zero in non-Excel applications
Strings aren’t displayed in Apple Numbers in ‘constant_memory’ mode
Images not displayed correctly in Excel 2001 for Mac and non-Excel applications
Reporting Bugs
Upgrade to the latest version of the module
Read the documentation
Look at the example programs
Use the xlsxwriter Issue tracker on GitHub
Pointers for submitting a bug report
Frequently Asked Questions
Changes in XlsxWriter
Author
Donations
License