Examples#
The following are some of the examples included in the examples directory of the XlsxWriter distribution.
- Example: Hello World
- Example: Simple Feature Demonstration
- Example: Catch exception on closing
- Example: Dates and Times in Excel
- Example: Adding hyperlinks
- Example: Array formulas
- Example: Dynamic array formulas
- Example: Applying Autofilters
- Example: Data Validation and Drop Down Lists
- Example: Conditional Formatting
- Example: Defined names/Named ranges
- Example: Merging Cells
- Example: Autofitting columns
- Example: Writing “Rich” strings with multiple formats
- Example: Merging Cells with a Rich String
- Example: Inserting images into a worksheet
- Example: Inserting images from a URL or byte stream into a worksheet
- Example: Embedding images into a worksheet
- Example: Left to Right worksheets and text
- Example: Simple Django class
- Example: Simple HTTP Server
- Example: Adding Headers and Footers to Worksheets
- Example: Freeze Panes and Split Panes
- Example: Worksheet Tables
- Example: Writing User Defined Types (1)
- Example: Writing User Defined Types (2)
- Example: Writing User Defined types (3)
- Example: Ignoring Worksheet errors and warnings
- Example: Sparklines (Simple)
- Example: Sparklines (Advanced)
- Example: Adding Cell Comments to Worksheets (Simple)
- Example: Adding Cell Comments to Worksheets (Advanced)
- Example: Insert Textboxes into a Worksheet
- Example: Outline and Grouping
- Example: Collapsed Outline and Grouping
- Example: Setting Document Properties
- Example: Setting the Sensitivity Label for a Document
- Example: Simple Unicode with Python 3
- Example: Unicode - Polish in UTF-8
- Example: Unicode - Shift JIS
- Example: Setting a Worksheet Watermark
- Example: Setting the Worksheet Background
- Example: Setting Worksheet Tab Colors
- Example: Diagonal borders in cells
- Example: Enabling Cell protection in Worksheets
- Example: Hiding Worksheets
- Example: Hiding Rows and Columns
- Example: Example of subclassing the Workbook and Worksheet classes
- Example: Advanced example of subclassing
- Example: Adding a VBA macro to a Workbook
- Example: Excel 365 LAMBDA() function