Today we are announcing the release of XL Plugin version 3.0. The latest version offers a ton of new features, making it the most advanced 4D plugin for reading and writing Microsoft Excel files.
XL Plugin 3.0 introduces over 120 new features, making it one of the most comprehensive updates to date. The release focuses on improving performance, expanding compatibility, and providing developers with greater control over Excel document manipulation.
Key new features include:
- Support for loading password-protected (encrypted) Excel documents
- Ability to get and set core document properties
- Support for conditional formatting
- Reading and writing Excel tables
- Working with form controls
- Options for getting and setting default column and row formats
- Improved support for working with merged cells
- Finding the first and last filled row and column numbers.
- Reading print settings of a sheet like print area and print repeated rows/columns
- Ability to get and set the tab color of a sheet
- Easily add borders around a range of cells
- Diagonal border styles
- Support for getting and setting the active cell or selected range
- Functionality to get and set default row height
- Improved support for 4D v20 and v21
In addition to these technical enhancements, the demo database has been extensively updated with many new examples, helping users quickly explore and implement the plugin’s capabilities.
More details can be found in the section Version history of the documentation.