Rustpy-xlsxwriter

Added

- Updated the default `zip.rs` requirement to v2+ to pick up a fix for
[zip-rs/zip2100] when dealing with 64k+ internal files in an xlsx
container. As a result of this, `rust_xlsxwriter` now has a matching `msrv`
(Minimum Supported Rust Version) of v1.73.0.

- Replaced the dependency on `lazy_static` with `std::cell::OnceLock`. The
only non-optional requirements are now `zip` and `regex`. This was made
possible by the above `msrv` update. See [Feature Request 24].

- Added an optional dependency on the [ryu] crate to speed up writing large
amounts of worksheet numeric data. The feature flag is `ryu`.

This feature has a benefit when writing more than 300,000 numeric data
cells. When writing 5,000,000 numeric cells it can be 30% faster than the
standard feature set. See the following [performance analysis] but also
please test it for your own scenario when enabling it since a performance
improvement is not guaranteed in all cases.

- Added Excel [Sensitivity Label] cookbook example and explanation.

Sensitivity Labels are a property that can be added to an Office 365
document to indicate that it is compliant with a company’s information
protection policies. Sensitivity Labels have designations like
“Confidential”, “Internal use only”, or “Public” depending on the policies
implemented by the company. They are generally only enabled for enterprise
versions of Office.

- Updated all dependency versions to the latest current values.

[ryu]: https://docs.rs/ryu/latest/ryu/index.html
[zip-rs/zip2100]: https://github.com/zip-rs/zip2/issues/100
[Sensitivity Label]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/cookbook/index.html#document-properties-setting-the-sensitivity-label
[Feature Request 24]: https://github.com/jmcnamara/rust_xlsxwriter/issues/24
[performance analysis]: https://github.com/jmcnamara/rust_xlsxwriter/issues/93

Added

- Added example of using a secondary X axis. See [Chart Secondary Axes].

Changed

- Changed `ChartSeries::set_y2_axis()` to `ChartSeries::set_secondary_axis()` for API consistency.

[`ChartSeries::set_secondary_axis()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.ChartSeries.html#method.set_secondary_axis

Added

- Added support for [Chart Secondary Axes] and [Combined Charts].

<img src="https://rustxlsxwriter.github.io/images/chart_series_set_secondary_axis.png">

[Chart Secondary Axes]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/index.html#secondary-axes
[Combined Charts]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/index.html#combined-charts

Fixed

- Fixed internal links in table of contents.

Added

- Added the [`worksheet::set_screen_gridlines()`] method to turn on/offscreen gridlines.

[`worksheet::set_screen_gridlines()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_screen_gridlines

- Added updated docs on [Working with Workbooks] and [Working with Worksheets].

[Working with Workbooks]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/workbook/index.html
[Working with Worksheets]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/index.html

Added

- Add support for worksheet sparklines. Sparklines are a feature of Excel 2010+
which allows you to add small charts to worksheet cells. These are useful for
showing data trends in a compact visual format.

See [Working with Sparklines].

<img src="https://rustxlsxwriter.github.io/images/sparklines1.png">

[Working with Sparklines]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/sparkline/index.html