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