Repository navigation
Release 1.31 is on CRAN. This monthly release brings a lot of hardening and support for xls files.
The biggest new feature is the support for xls files. These old spreadsheet files are still around and it is no longer required to switch to another R package to read them. They can be handled as if they were xlsx files, so wb_load("data.xls") and wb_to_df("data.xls") should work just fine.
Several hardening steps were integrated into the package, so that openxlsx2 should be vocal about the type of input an argument expects and reject inputs that could have caused broken spreadsheet files in the past. The Unicode barrier is now the C++ code, so that the package should be slightly faster in modern Unicode R sessions. Cloning has been improved and output files are now fuzzed against an OOXML validator.
A lot of time was spent on various bug fixes, cleanups, and minor improvements here and there. A number of the fixes and features were developed based on user requests and needs. If you find a bug, please let us know!
The 1.31 release is the 44th openxlsx2 release available on CRAN. Even though the package is now semi-stable, it is always a good idea to make regular backups and check the output files. A look at the issue tracker and the NEWs is highly recommended.
What's Changed
- Gh issue 1699 by @JanMarvin in #1700
- [xls] initial support for loading xls files by @JanMarvin in #1698
- [xls] first cleanups by @JanMarvin in #1701
- [xlsb] increase coverage and fix some minor issues along the way by @JanMarvin in #1702
- [xls+xlsb] increase coverage by @JanMarvin in #1703
- [xls+xlsb] increase coverage with real world examples by @JanMarvin in #1704
- [xls] silence VBA warning with data only mode by @JanMarvin in #1705
- [read] read headerr_row by @JanMarvin in #1706
- [save] fix cdigit overflow on non table ids and an unrelated cdigit() call by @JanMarvin in #1708
- [misc] wb_clean_sheet() removes tables as well by @JanMarvin in #1709
- [xls] cleanup and hardening by @JanMarvin in #1710
- [xls] speedup by @JanMarvin in #1711
- [xlsb] harden parser by @JanMarvin in #1712
- [misc] fuzzing fixes by @JanMarvin in #1713
- [pugi] release xml by @JanMarvin in #1714
- [c++] default cpp to unicode by @JanMarvin in #1715
- [misc] table names and named regions should not clash by @JanMarvin in #1716
- [misc] update OOXMLValidator by @JanMarvin in #1717
- [misc] validate inputs by @JanMarvin in #1718
- [read] add used_range for wb_data() by @JanMarvin in #1722
- [misc] minor cleanups by @JanMarvin in #1723
- [misc] MS-OI29500 quirks by @JanMarvin in #1724
- [clone] clone defined names and chartEx by @JanMarvin in #1721
- [misc] fix sheet name selection after sheet ordering by @JanMarvin in #1727
- [drawings] always use custom ids by @JanMarvin in #1726
Full Changelog: v1.30...v1.31