![]() ![]() New methods mychart.to_png(), myrange.to_png() and py_picture() ( GH1707 and GH582). Fixed a regression introduced with 0.24.8 that was causing an error with pandas DataFrames that have repeated column headers ( GH1711). caused xlwings to hang instead of raising an Exception ( GH1725). Writing to a protected sheet or using an invalid sheet name etc. Running UDFs from other Office apps has been fixed ( GH1729). PRO: Breaking Change: Reports: create_report() is now deprecated in favor of render_template() that is available via app, book (new), and sheet objects, see: xlwings Reports ( GH1738). You can now easily update an existing table in Excel with the data from a new pandas DataFrame without messing up any formulas that reference that table: mytable.update(df), see: Table.update() ( GH1751). The update() method of Excel tables has been moved from PRO to open source. Sometimes, this requires editing the configuration, see: OneDrive and SharePoint for the details ( GH1630). It also makes mybook.fullname return the local file path instead of a URL. This means that the quickstart setup (Excel file and Python file in the same folder with the same name) works even if the files are stored on OneDrive/SharePoint-as long as they are being synced locally. Finally, xlwings adds proper support for OneDrive, OneDrive for Business, and SharePoint. PRO xlwings now warns about expiring developer license keys 30 days before they expire ( GH1758). PRO xlwings Reports would sometimes cause a Could not activate App instance error ( GH1764). mybook.save() now supports the password parameter ( GH1568). PRO The aggsmall filter in xlwings Reports now accepts a new parameter min_rows ( GH1780). ![]() PRO xlwings Reports now ignores sheets whose name start with # for both rendering and printing to PDF ( GH1779). ![]() PRO The xlwings Reports filters aggsmall and maxrows don’t fail with empty DataFrames anymore ( GH1788). Xlwings PRO is now free for noncommercial usage under the PolyForm Noncommercial License 1.0.0, see xlwings PRO for the details. PRO 0.26.1 fixes an issue with the xlwings copy gs command. For all the details, see Remote Interpreter. PRO Added experimental support for Google Sheets and Excel on the web via a remote Python interpreter. Toggle table of contents sidebar What’s New ¶ v0.26.0 and v0.26.1 (Feb 1, 2022) ¶ ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |