XLSX Workbook

Rating:        Based on 7 ratings
Reviewed:  3 reviews
Downloads: 657
Released: Sep 28, 2016
Updated: Sep 28, 2016 by gagreen1214
Dev status: Stable Help Icon

Downloads

Source Code WorkbookXLSX R17.zip
source code, 225K, uploaded Sep 28 - 657 downloads

Release Notes

Current release 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.

Note: Release 17 changes a number of the method parameters and return values; so please see the Release Notes and Documentation.

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 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 (Developer) on Sep 28 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