This project is read-only.

XLSX Workbook

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


Application WorkbookXLSX
application, 304K, uploaded Mar 14, 2017 - 980 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.

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 8:22 PM
Thank you for pointing out this bug. I have fixed this in Release 17 which is posted today.
Reply by gagreen1214 (N/A) on Sep 28, 2016 at 7: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 7:17 PM
justo lo que estaba buscando.
by Lordpro on Oct 12, 2015 at 3:37 AM