Rustpy-xlsxwriter

Fixed

- Fixed "multiply with overflow" issue when image locations in the worksheet
were greater than the maximum `u32` value.

Related to [GitHub Issue 51].

[GitHub Issue 51]: https://github.com/jmcnamara/rust_xlsxwriter/issues/51

Added

- Added threading into the backend worksheet writing for increased performance
with large multi-worksheet files.

Added

- Added support for worksheet [`Table`] header and cell formatting via the
[`TableColumn::set_format()`] and [`TableColumn::set_header_format()`] methods.

[`TableColumn::set_format()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.TableColumn.html#method.set_format
[`TableColumn::set_header_format()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.TableColumn.html#method.set_header_format

Changed

- Made the `chrono` feature optionally off instead of optionally on. The
`chrono` feature must now be explicitly enabled to allow support for
[`Chrono`] types.

- Renamed the worksheet `write_datetime()` method to the API consistent
[`write_datetime_with_format()`] and introduced a new
[`write_datetime()`] method that doesn't take a format. This is
required to fix a error in the APIs that prevented an unformatted datetime
from taking the row or column format.

**Note**: This is a backwards incompatible change.

See [GitHub Issue 47].


Added

- Added a [Tutorial] and [Cookbook] section to the `doc.rs` documentation.

- Added a check, and and error result, for case-insensitive duplicate sheet
names. Also added sheet name validation to chart series.

See [GitHub Issue 45].

- Added cell range name handling utility functions:

- [`column_number_to_name()`] - Convert a zero indexed column cell reference
to a string like `"A"`.
- [`column_name_to_number()`] - Convert a column string such as `"A"` to a
zero indexed column reference.
- [`row_col_to_cell()`] - Convert zero indexed row and column cell numbers to
a `A1` style string.
- [`row_col_to_cell_absolute()`] - Convert zero indexed row and column cell
numbers to an absolute `$A$1` style range string.
- [`cell_range()`] - Convert zero indexed row and col cell numbers to a
`A1:B1` style range string.
- [`cell_range_absolute()`] - Convert zero indexed row and col cell numbers to
an absolute `$A$1:$B$1`

[`cell_range()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.cell_range.html
[`row_col_to_cell()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.row_col_to_cell.html
[`cell_range_absolute()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.cell_range_absolute.html
[`column_number_to_name()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.column_number_to_name.html
[`column_name_to_number()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.column_name_to_number.html
[`row_col_to_cell_absolute()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.row_col_to_cell_absolute.html

[GitHub Issue 45]: https://github.com/jmcnamara/rust_xlsxwriter/issues/45
[GitHub Issue 47]: https://github.com/jmcnamara/rust_xlsxwriter/issues/47

[Tutorial]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/tutorial/index.html
[Cookbook]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/cookbook/index.html
[`write_datetime()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.write_datetime
[`write_datetime_with_format()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.write_datetime_with_format

- Added the native [`ExcelDateTime`] struct to allow handling of dates and times
without a dependency on the [`Chrono`] library. The Chrono library is now an
optional feature/dependency. It is included by default in this release for
compatibility with previous versions but it will be optionally off in the next
and subsequent versions.

All date/time APIs support both the native `ExcelDateTime` and `Chrono` types
via the [`IntoExcelDateTime`] trait.

The `worksheet.write_date()` and `worksheet.write_time()` methods have been
moved to "undocumented" since the same functionality is available via
[`Worksheet::write_datetime()`]. This is a soft deprecation.

[`Chrono`]: https://docs.rs/chrono/latest/chrono
[`ExcelDateTime`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.ExcelDateTime.html
[`IntoExcelDateTime`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/trait.IntoExcelDateTime.html
[`Worksheet::write_datetime()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.write_datetime

- Added support for worksheet tables. See [`Table`] and the
[`Worksheet::add_table()`] method.

- Added support for the `bool` type in the generic [`Worksheet::write()`] method.

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