Version 6 released!
- Support for pivot tables. Easy to create pivot tables in the same way as in Excel.
- New component: TXLSGrid. TXLSGrid is like a simpler version of XLSSpreadSheet where you can view formatted cells, pictures and text boxes.
- Monitor file changes. Enable with the MonitorFile property. The OnMonitorFile event is fired when there are any changes to the file from another application, like Excel.
- Encrypted XLSX files can now be read and written.
- Improved support for Autofilters.
- Macros are preserved when a macro enabled files is read and written.
- New RTF importer with support for tables in RTF files.
- Support for charts in XLSX files.
- Auto height rows now works on RTF cells and multi line (word wrap) cells.
- CmdFormat: New Command method for formatting with commands and values.
- When exporting to CSV files, the CSV file can be UTF8 (unicode) encoded, Use the ecoWriteUTF8 option. Default is not UTF8 encoded.
- All exceptions thrown by the component is now of the class XLSRWException.