Cookbook Examples

This section contains sample applications that demonstrate different features of the rust_xlsxwriterlibrary.

• Hello World: Simple getting started example.
• Feature demo: Demonstrates more features of the library.
• Cell formatting: Demonstrates various formatting options.
• Merging cells: An example of merging cell ranges.
• Autofilters: Add an autofilter to a worksheet.
• Tables: Add worksheet tables to a worksheet.
• Conditional Formatting
• Autofitting Columns: Example of autofitting column widths.
• Extending generic write(): Example of extending the write() method to handle user data types.
• Rich strings: Add multi-font "rich" strings to a worksheet.
• Format colors: Creates a palette of the available colors.
• Hyperlinks: Add hyperlinks to a worksheet.
• Chart: Simple: Simple getting started chart example.
• Chart: Styles: Example of setting default chart styles.
• Chart: Area: Excel Area chart example.
• Chart: Bar: Excel Bar chart example.
• Chart: Column: Excel Column chart example.
• Chart: Line: Excel Line chart example.
• Chart: Scatter: Excel Scatter chart example.
• Chart: Radar: Excel Radar chart example.
• Chart: Pie: Excel Pie chart example.
• Chart: Stock: Excel Stock chart example.
• Chart: Doughnut: Excel Doughnut chart example.
• Chart: Pattern Fill: Example of a chart with Pattern Fill.
• Chart: Gradient Fill: Example of a chart with Gradient Fill.
• Chart: Data table
• Chart: Data tools
• Sparklines: Simple example
• Sparklines: Example with optional properties
• Insert images: Add images to a worksheet.
• Embedding images in cells
• Insert images to fit: Inserting images to fit cell
• Right to left display: Sets a worksheet into right to left format.
• Defined names: How to use user defined variable names in worksheets.
• Dynamic array formulas: Examples of dynamic arrays and formulas.
• Excel LAMBDA() function: Example of using the Excel 365+ LAMBDA() function.
• Headers and Footers: Shows how to set headers and footers.
• Setting document properties Set the metadata properties for a workbook.
• Adding a watermark: Adding a watermark to a worksheet by adding an image to the header.
• Freeze Panes: Example of setting freeze panes in worksheets.