Rustpy-xlsxwriter

Added

- Added support for chart gradient fill formatting via the [`ChartGradientFill`] struct and methods.

- Added support for formatting the chart trendlines data labels via the
[`ChartTrendline::set_label_font`] and [`ChartTrendline::set_label_format`].


[`ChartGradientFill`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.ChartGradientFill.html
[`ChartTrendline::set_label_font`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.ChartTrendline.html#method.set_label_font
[`ChartTrendline::set_label_format`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.ChartTrendline.html#method.set_label_format

Added

- Added support for chart trendlines (Linear, Polynomial, Moving Average, etc.)
via the [`ChartTrendline`] struct and methods.

- Added the [`Worksheet::set_very_hidden()`] method to hide a worksheet similar
to the [`Worksheet::set_hidden()`] method. The difference is that the worksheet
can only be unhidden by VBA and cannot be unhidden in the the Excel user
interface.

- Added support for leader lines to non-Pie charts.

Fixed

- Fixed handling of [future functions] in table formulas.


[`ChartTrendline`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.ChartTrendline.html
[`Worksheet::set_very_hidden()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_very_hidden
[future functions]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.Formula.html#formulas-added-in-excel-2010-and-later

Added

- Added chart options to control how non-data cells are displayed.

- [`Chart::show_empty_cells_as()`]
- [`Chart::show_na_as_empty_cell()`]
- [`Chart::show_hidden_data()`]

[`Chart::show_hidden_data()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.Chart.html#method.show_hidden_data
[`Chart::show_empty_cells_as()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.Chart.html#method.show_empty_cells_as
[`Chart::show_na_as_empty_cell()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.Chart.html#method.show_na_as_empty_cell


- Updated Polar's dependency and `PolarError` import to reflect changes in Polars v 0.33.2.

Added

- Added support for custom total formulas to [`TableFunction`].

[`TableFunction`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/enum.TableFunction.html

Added

- Added `wasm` feature flag to help compilation on Wasm/Javascript targets. Also
added mapping from a `XlsxError` to a `JsValue` error.

See the [rust_xlsx_wasm_example] sample application that demonstrates
accessing `rust_xlsxwriter` code from JavaScript, Node.js, Deno and Wasmtime.

- Added [`Workbook::save_to_writer()`] method to make it easier to interact with
interfaces that implement the `<W: Write>` trait.

[rust_xlsx_wasm_example]: https://github.com/Clipi-12/rust_xlsx_wasm_example
[`Workbook::save_to_writer()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/workbook/struct.Workbook.html#method.save_to_writer

Added

- Added `polars` feature flag to help interoperability with Polars. Currently
it only implements `PolarsError` and `XlsxError` mapping but other
functionality may be added in the future. These changes are added to support
the [`polars_excel_writer`] crate.

[`polars_excel_writer`]: https://crates.io/crates/polars_excel_writer