1. rust_xlsxwriter
  2. Introduction
  3. 1. Getting started
  4. 2. Tutorial
    1. 2.1. Adding data to a worksheet
    2. 2.2. Adding some formatting
    3. 2.3. Adding dates and more formatting
    4. 2.4. Adding a chart
    5. 2.5. Making the code more programmatic
  5. 3. The Workbook struct
    1. 3.1. Creating and saving an xlsx file
    2. 3.2. Checksum of a saved file
  6. 4. The Worksheet struct
    1. 4.1. Creating worksheets
    2. 4.2. Page Setup
    3. 4.3. Adding Headers and Footers
    4. 4.4. Autofitting column widths
    5. 4.5. Working with worksheet tabs
    6. 4.6. Worksheet protection
  7. 5. The Format struct
    1. 5.1. Creating and using a Format object
    2. 5.2. Format defaults
    3. 5.3. Format methods
    4. 5.4. Number Format Categories
    5. 5.5. Number Formats in different Locals
  8. 6. Working with Colors
  9. 7. Working with Formulas
    1. 7.1. Formula Results
    2. 7.2. Non US Excel functions and syntax
    3. 7.3. Dynamic Array support
    4. 7.4. Formulas added in Excel 2010 and later
    5. 7.5. Dealing with formula errors
  10. 8. Working with Autofilters
  11. 9. Cookbook Examples
    1. 9.1. Hello World
    2. 9.2. Feature demo
    3. 9.3. Cell formatting
    4. 9.4. Merging cells
    5. 9.5. Adding autofilters
    6. 9.6. Autofitting columns
    7. 9.7. Adding worksheet tables
    8. 9.8. Adding conditional formatting
    9. 9.9. Using data validation
    10. 9.10. Adding cell notes
    11. 9.11. Extending generic write()
    12. 9.12. Rich strings
    13. 9.13. Format colors
    14. 9.14. Theme: use a custom theme
    15. 9.15. Theme: use the Excel 2023 theme
    16. 9.16. Hyperlinks
    17. 9.17. Chart: Simple
    18. 9.18. Chart: Styles
    19. 9.19. Chart: Area
    20. 9.20. Chart: Bar
    21. 9.21. Chart: Column
    22. 9.22. Chart: Line
    23. 9.23. Chart: Scatter
    24. 9.24. Chart: Radar
    25. 9.25. Chart: Pie
    26. 9.26. Chart: Stock
    27. 9.27. Chart: Doughnut
    28. 9.28. Chart: Using a secondary axis
    29. 9.29. Chart: Create a combined chart
    30. 9.30. Chart: Create a combined pareto chart
    31. 9.31. Chart: Create a clustered/2D category chart
    32. 9.32. Chart: Pattern Fill
    33. 9.33. Chart: Gradient Fill
    34. 9.34. Chart: Data table
    35. 9.35. Chart: Data tools
    36. 9.36. Chart: Gauge Chart
    37. 9.37. Chart: Chartsheet
    38. 9.38. Macros: Adding macros to a workbook
    39. 9.39. Sparklines: Simple example
    40. 9.40. Sparklines: Example with optional properties
    41. 9.41. Inserting images
    42. 9.42. Embedding images in cells
    43. 9.43. Inserting images to fit
    44. 9.44. Inserting Checkboxes in worksheets
    45. 9.45. Inserting Textboxes in worksheets
    46. 9.46. Ignoring Excel cell errors
    47. 9.47. Create row outline groups
    48. 9.48. Create column outline groups
    49. 9.49. Right to left display
    50. 9.50. Using defined names
    51. 9.51. Dynamic array formulas
    52. 9.52. Excel LAMBDA() function
    53. 9.53. Headers and Footers
    54. 9.54. Setting document properties
    55. 9.55. Setting the Sensitivity Label
    56. 9.56. Creating a Table of Contents
    57. 9.57. Adding a watermark as a header image
    58. 9.58. Adding a watermark as a background image
    59. 9.59. Freeze Panes
    60. 9.60. Worksheet protection
  12. 10. Performance
  13. 11. Release Notes
  14. 12. License
  15. 13. Author

Working with the rust_xlsxwriter library

Author

rust_xlsxwriter was written by John McNamara, who also wrote:

  • XlsxWriter (Python)

  • libxlsxwriter (C)

  • Excel::Writer::XLSX (Perl)

  • Spreadsheet::WriteExcel (Perl)

  • xlsxwriter.lua (Lua)

  • Other stuff