This Class allows reading and writing from/to XLSX format files without any automation. Support for cell import/export with cell formatting and formulas. Cell formatting includes borders, font (size, name, bold, italic, underline, etc), foreground color, and background color, number formatting, and in-line text formatting. Multiple sheet support.
A PDF file is included for the documentation on the methods and properties. See the Demo() method for example of method calls - this creates a sample XLSX spreadsheet which shows most of the features. A PRG is included that calls the Demo() method. Other PRGs are included to show other features.
Release 18 adds a new way to define cell formatting; please read the Release Notes and Documentation for more information.
Release 19 fixes a bug in raising the event name for two methods.
Release 20 fixes a typo bug.
Release 21 corrects a bug I found this afternoon in my own work -- see the release notes for more info.
Release 22 corrects the handling of double-byte characters for international character sets when reading existing xlsx files