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 pivot tables
    9. 9.9. Adding conditional formatting
    10. 9.10. Using data validation
    11. 9.11. Adding cell notes
    12. 9.12. Extending generic write()
    13. 9.13. Rich strings
    14. 9.14. Format colors
    15. 9.15. Theme: use a custom theme
    16. 9.16. Theme: use the Excel 2023 theme
    17. 9.17. Hyperlinks
    18. 9.18. Chart: Simple
    19. 9.19. Chart: Styles
    20. 9.20. Chart: Area
    21. 9.21. Chart: Bar
    22. 9.22. Chart: Column
    23. 9.23. Chart: Line
    24. 9.24. Chart: Scatter
    25. 9.25. Chart: Radar
    26. 9.26. Chart: Pie
    27. 9.27. Chart: Stock
    28. 9.28. Chart: Doughnut
    29. 9.29. Chart: Using a secondary axis
    30. 9.30. Chart: Create a combined chart
    31. 9.31. Chart: Create a combined pareto chart
    32. 9.32. Chart: Create a clustered/2D category chart
    33. 9.33. Chart: Pattern Fill
    34. 9.34. Chart: Gradient Fill
    35. 9.35. Chart: Data table
    36. 9.36. Chart: Data tools
    37. 9.37. Chart: Gauge Chart
    38. 9.38. Chart: Chartsheet
    39. 9.39. Macros: Adding macros to a workbook
    40. 9.40. Sparklines: Simple example
    41. 9.41. Sparklines: Example with optional properties
    42. 9.42. Inserting images
    43. 9.43. Embedding images in cells
    44. 9.44. Inserting images to fit
    45. 9.45. Inserting Checkboxes in worksheets
    46. 9.46. Inserting Textboxes in worksheets
    47. 9.47. Ignoring Excel cell errors
    48. 9.48. Create row outline groups
    49. 9.49. Create column outline groups
    50. 9.50. Right to left display
    51. 9.51. Using defined names
    52. 9.52. Dynamic array formulas
    53. 9.53. Excel LAMBDA() function
    54. 9.54. Headers and Footers
    55. 9.55. Setting document properties
    56. 9.56. Setting the Sensitivity Label
    57. 9.57. Creating a Table of Contents
    58. 9.58. Adding a watermark as a header image
    59. 9.59. Adding a watermark as a background image
    60. 9.60. Freeze Panes
    61. 9.61. 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