Rustpy-xlsxwriter

Added

- Added support for files larger than 4GB.

The `rust_xlsxwriter` library uses the [zip.rs] crate to provide the zip
container for the xlsx file that it generates. The size limit for a standard
zip file is 4GB for the overall container or for any of the uncompressed files
within it. Anything greater than that requires [ZIP64] support. In practice
this would apply to worksheets with approximately 150 million cells, or more.

See [`Workbook::use_zip_large_file()`].

[`Workbook::use_zip_large_file()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/workbook/struct.Workbook.html#method.use_zip_large_file

[zip.rs]: https://crates.io/crates/zip/2.2.0
[ZIP64]: https://en.wikipedia.org/wiki/ZIP_(file_format)#ZIP64

Added

- Added support for [constant memory] mode to reduce memory usage when writing
large worksheets.

The `constant_memory` mode works by flushing the current row of data to disk
when the user writes to a new row of data. This limits the overhead to one row
of data stored in memory. Once this happens it is no longer possible to write
to a previous row since the data in the Excel file must be in row order. As
such this imposes the limitation of having to structure your code to write in
row by row order. The benefit is that the required memory usage is very low,
and effectively constant, regardless of the amount of data written.

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

[constant memory]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/performance/index.html#constant-memory-mode

Added

- Added support for [Chartsheets].

A Chartsheet in Excel is a specialized type of worksheet that doesn't have
cells but instead is used to display a single chart. It supports worksheet
display options such as headers and footers, margins, tab selection and
print properties.

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

[Chartsheets]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/index.html#chartsheets


- Updated `polars` dependency to 0.43 to pick up latest Polars additions for
[`polars_excel_writer`].

Added

- Added support for adding Textbox shapes to worksheets. See the documentation
for [`Shape`].

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


[`Shape`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.Shape.html

Removed

- Removed dependency on the `regex.rs` crate for smaller binary sizes. The only
non-optional dependency is now `zip.rs`.

An example of the size difference is shown below for one of the sample apps:

| `app_hello_world` | v0.74.0 |v0.75.0 |
|-------------------|---------|--------|
| Debug | 9.2M | 4.2M |
| Release | 3.4M | 1.6M |


- Removed the `Formula::use_future_functions()` and
`Formula::use_table_functions()` methods since there functionality is now
handled automatically as a result of the `regex` change.

Added

- Add methods to format cells separately from the data writing functions.

In Excel the data in a worksheet cell is comprised of a type, a value and a
format. When using `rust_xlsxwriter` the type is inferred and the value and
format are generally written at the same time using methods like
[`Worksheet::write_with_format()`].

However, if required you can write the data separately and then add the format
using the new methods like [`Worksheet::set_cell_format()`],
[`Worksheet::set_range_format()`] and
[`Worksheet::set_range_format_with_border()`].

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

[`Worksheet::set_cell_format()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_cell_format
[`Worksheet::set_range_format()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_range_format
[`Worksheet::write_with_format()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.write_with_format
[`Worksheet::set_range_format_with_border()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_range_format_with_border

- Replaced the `IntoColor` trait with `Into<Color>` in all APIs. This doesn't
require a change by the end user (unless they implemented `IntoColor` for
their own type).

- Updated `polars` dependency to 0.42.0 to pick up latest Polars additions for
[`polars_excel_writer`].