Cookbook Examples

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

• 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.
• Adding autofilters: Add an autofilter to a worksheet.
• Autofitting columns: Example of autofitting column widths.
• Adding worksheet tables: Add worksheet tables to a worksheet.
• Adding conditional formatting: Add conditional formats to a worksheet.
• Using data validation: Add data validation to cells in a worksheet.
• Adding cell notes: Add a Note to a cell.
• 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: Using a secondary axis: An example of a creating a chart with a secondary axis.
• Chart: Create a combined chart: An example of combining two chart types in one.
• Chart: Create a combined pareto chart: An example of a combined Pareto chart.
• Chart: Pattern Fill: Example of a chart with Pattern Fill.
• Chart: Gradient Fill: Example of a chart with Gradient Fill.
• Chart: Data table: Example of adding a data table below a chart.
• Chart: Data tools: Example of chart data analysis tools like trendlines.
• Chart: Gauge Chart: Example of composite "gauge" chart data.
• Sparklines: Simple example: A simple example of sparklines.
• Macros: Adding macros to a workbook: Adding a macro to a worksheet.
• Sparklines: Example with optional properties: An advanced example of sparklines showing available options.
• Inserting images: Add images to a worksheet.
• Embedding images in cells: An example of embedding images in a cell.
• Inserting images to fit: Inserting images to fit cell
• Inserting Textboxes in worksheets: Inserting Textboxes in worksheets
• Right to left display: Sets a worksheet into right to left format.
• Using 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.
• Setting the Sensitivity Label: Setting the Sensitivity Label for a Document.
• 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.
• Worksheet protection: Example of setting worksheet protection properties.