XLSX Workbook

Rating:        Based on 7 ratings
Reviewed:  3 reviews
Downloads: 656
Released: Mar 14, 2017
Updated: Mar 14, 2017 by gagreen1214
Dev status: Stable Help Icon

Downloads

Application WorkbookXLSX R22.zip
application, 304K, uploaded Mar 14 - 656 downloads

Release Notes

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.

Notes:
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

Reviews for this release

     
Excelent project!!! Please, correct Method "SaveTableToWorkbook", line 61: "if seek(bintoc(tnWB),...." --> "if seek(bintoc(txWB),..." This line generate error because te correct name of variable is "txWB", not "tnWB"- This error occurs when the method is called with your 2nd parameter in numeric format
by hgbsoft on Sep 20, 2016 at 7:22 PM
Thank you for pointing out this bug. I have fixed this in Release 17 which is posted today.
Reply by gagreen1214 (Developer) on Sep 28, 2016 at 6:40 PM
     
This is a great project. It is easy to implement, and very flexible. Recommend adding two additional procedures - SetCellNumberDecimalsRange and SetColumnAutofitRange.
by jwalker126 on Dec 2, 2015 at 6:17 PM
     
justo lo que estaba buscando.
by Lordpro on Oct 12, 2015 at 2:37 AM