jmcnamara/XlsxWriter (XlsxWriter)
### [`v3.2.0`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-320---February-17-2024)
This is the 10th anniversary release of XlsxWriter. Version 0.0.1 was released
on February 17 2013. Since then there have been 167 releases, 25,000 lines of
code, 1600 test cases, 700 pages of documentation, 71,000 users on GitHub, 50
contributors, 1000 closed issues and 150 million yearly downloads. Thanks to
everyone who has contributed code, given feedback or just used the library.
- Add :func:`embed_image()` worksheet method to embed images in cells. This is
equivalent to Excel's menu item to insert an image using the option to "Place
in Cell". It scales images automatically to the dimensions of the cell.
This has been a frequently requested feature for people creating spreadsheets
with images for product items. See also :ref:`ex_embedded_images`.
- Fix issue where a horizontal alignment format was ignored if indentation was
also set.
:issue:`1041`.
### [`v3.1.9`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-319---October-19-2023)
- Add fix for errant XML tag in chart leader lines for non-Pie charts.
:issue:`1019` and :feature:`1012`.
### [`v3.1.8`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-318---October-15-2023)
- Add support for formatting the data label in chart trendlines.
:feature:`750`.
### [`v3.1.7`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-317---October-9-2023)
- Add the :func:`very_hidden()` method to hide a worksheet. This is similar to
the :func:`hide()` method except that the worksheet cannot be unhidden in the
the Excel user interface. The Excel worksheet "xlSheetVeryHidden" option can
only be unset programmatically via VBA.
:feature:`947`.
- Added fixes for column formulas in tables that were overridden by table data
and which also didn't take future functions into account.
:issue:`1015`.
### [`v3.1.6`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-316---October-1-2023)
- Added support for chart leader lines for chart types other than Pie and Doughnut.
:feature:`1012`.
### [`v3.1.5`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-315---September-24-2023)
- Added support for adding signed VBA macros to workbooks via the
:func:`add_signed_vba_project` method. See `Working with VBA Macros`\_.
:feature:`1009`.
.. \_Working with VBA Macros: https://xlsxwriter.readthedocs.io/working_with_macros.html
### [`v3.1.4`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-314---September-18-2023)
- Added support for enabling the Excel "Show #N/A as an empty cell" chart option
via the :func:`show_na_as_empty_cell` method.
:feature:`1008`.
### [`v3.1.3`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-313---September-8-2023)
- Added support for custom total formulas to worksheet tables.
:feature:`982`.
### [`v3.1.2`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-312---May-28-2023)
- Added worksheet page break preview mode via :func:`set_pagebreak_view()`.
### [`v3.1.1`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-311---May-21-2023)
- Add support for new Excel dynamic functions added in 2023.
:issue:`984`.
- Added support for adding a color to the `invert_if_negative` chart option.
:feature:`854`.
### [`v3.1.0`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-310---April-13-2023)
- Minor fix for cell color issue.
### [`v3.0.9`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-309---March-10-2023)
- Add documentation and examples on :ref:`ewx_polars` to demonstrate new `Polars `\_ integration of XlsxWriter in `write_excel()`\_.
.. \_write_excel(): https://docs.pola.rs/py-polars/html/reference/api/polars.DataFrame.write_excel.html
- Add fix for rare issue with duplicate number formats.
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
â™» Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, check this box
This PR contains the following updates:
==3.0.8->==3.2.0Release Notes
jmcnamara/XlsxWriter (XlsxWriter)
### [`v3.2.0`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-320---February-17-2024) This is the 10th anniversary release of XlsxWriter. Version 0.0.1 was released on February 17 2013. Since then there have been 167 releases, 25,000 lines of code, 1600 test cases, 700 pages of documentation, 71,000 users on GitHub, 50 contributors, 1000 closed issues and 150 million yearly downloads. Thanks to everyone who has contributed code, given feedback or just used the library. - Add :func:`embed_image()` worksheet method to embed images in cells. This is equivalent to Excel's menu item to insert an image using the option to "Place in Cell". It scales images automatically to the dimensions of the cell. This has been a frequently requested feature for people creating spreadsheets with images for product items. See also :ref:`ex_embedded_images`. - Fix issue where a horizontal alignment format was ignored if indentation was also set. :issue:`1041`. ### [`v3.1.9`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-319---October-19-2023) - Add fix for errant XML tag in chart leader lines for non-Pie charts. :issue:`1019` and :feature:`1012`. ### [`v3.1.8`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-318---October-15-2023) - Add support for formatting the data label in chart trendlines. :feature:`750`. ### [`v3.1.7`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-317---October-9-2023) - Add the :func:`very_hidden()` method to hide a worksheet. This is similar to the :func:`hide()` method except that the worksheet cannot be unhidden in the the Excel user interface. The Excel worksheet "xlSheetVeryHidden" option can only be unset programmatically via VBA. :feature:`947`. - Added fixes for column formulas in tables that were overridden by table data and which also didn't take future functions into account. :issue:`1015`. ### [`v3.1.6`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-316---October-1-2023) - Added support for chart leader lines for chart types other than Pie and Doughnut. :feature:`1012`. ### [`v3.1.5`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-315---September-24-2023) - Added support for adding signed VBA macros to workbooks via the :func:`add_signed_vba_project` method. See `Working with VBA Macros`\_. :feature:`1009`. .. \_Working with VBA Macros: https://xlsxwriter.readthedocs.io/working_with_macros.html ### [`v3.1.4`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-314---September-18-2023) - Added support for enabling the Excel "Show #N/A as an empty cell" chart option via the :func:`show_na_as_empty_cell` method. :feature:`1008`. ### [`v3.1.3`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-313---September-8-2023) - Added support for custom total formulas to worksheet tables. :feature:`982`. ### [`v3.1.2`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-312---May-28-2023) - Added worksheet page break preview mode via :func:`set_pagebreak_view()`. ### [`v3.1.1`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-311---May-21-2023) - Add support for new Excel dynamic functions added in 2023. :issue:`984`. - Added support for adding a color to the `invert_if_negative` chart option. :feature:`854`. ### [`v3.1.0`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-310---April-13-2023) - Minor fix for cell color issue. ### [`v3.0.9`](https://redirect.github.com/jmcnamara/XlsxWriter/blob/HEAD/Changes#Release-309---March-10-2023) - Add documentation and examples on :ref:`ewx_polars` to demonstrate new `PolarsConfiguration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
â™» Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR was generated by Mend Renovate. View the repository job log.