Read from and write to XLSX format files without any automation or export with support for full cell formatting in Excel
Minor update to allow the GetCellValue() method to retrieve the cell value for a cell that has a formula. The formula must be first calculated by another spreadsheet program such as MS Excel; the method for adding a formula to a cell does not calculate the cell value.
Release 41 is released to correct defects reported by users in the issues log. No new functionality has been introduced. However, some existing methods have been enhanced to either correct behavior, add additional capability, or faster performance. See the Release Notes for detailed changes. Now released as production as no issues have been received and I have not experienced any problems.
Release 42 is released to add a new method for direct output a table to xlxs file with columns/rows transposed. Also, a bug is fixed that caused a loss of formatting for rotated text, vertical & horizontal text cell alignment, cell text indent, and cell text word-wrapping. See Release Notes for more information. Released with no further beta testing to production.
I also added a new property, TemporaryPath, that defaults to =SYS(2023). You can set this another file location of your choice. All the class temporary files will then be written to that location instead of the system TEMP directory. I missed adding this to the documentation.
Release 43 is released to add methods for read-only access to a workbook (very fast access), fix some bugs, and speed improvements to opening workbooks to the method OpenXlsxWorkbook(). The documentation has been updated with the new methods added; however, the bookmarks have not yet been added for quick access. Please see the Release Notes and full documentation for more information.
Release 44 is released to correct an oversight on my part in the new method OpenXlsxWorkbookEx(). I missed the processing of cells with in-line string values and cells with formulas. Also, I missed converting text strings from the xml encoded value to the normal value. There is also change in the parameter line for the method OpenXlsxWorkbookEx(). Please see the Release Notes and full documentation for more information.
Gregory Green