XLSX-Workbook-Class
XLSX-Workbook-Class copied to clipboard
ggreen86
VFP Class to Create an XLSX Workbook without Excel Automation or Installed
Hi, Greg and friends. I am creating an XLSX based in a cursor. The numbers are saved using the point as decimal separador and no thousand separator. But when I...
SaveTablesToWorkBook and SaveTablesToWorkBookEx do a great job. Except I can not adress the location. It will create a new sheet and start on A1. What I like would the possibility...
GetGridColumnFormat doesn't handle "Z" (display zero as blank) in the format for a numeric column. I would change this myself but I'm not sure how NumFmtsIndex works.
The maximum length of a sheet name is 31, not 30, characters, so in my copy, I changed the value of the LIMITS_MAX_SH_NAME constant in VFPXWorkbookXLSX.h
Hi, Greg. I was trying to know how was the performance of .GetCellNumberFormat(), and **.GetCellNumberFormatText()**, but the second drives to an error, that I am going to show you. I...
Hi Green. I noticed that the library has the method GetColumnHidden. Is it possible to implement the following methods in the future? - GetSheetHidden - GetRowHidden Thank you for all....
Hello Greg, I try to fill cells in a predefined workbook. But when trying to open the workbook the debugger comes up in line 186 of OpenxlsxWorkbook. lcRelType has the...
Hi, Greg. I have tried to "update" my script for copying a DBF to a XLSx-template. I "developed" a script based in r31, and I made several modifications. Now I...
How to create a new workbook from template? Load the template and save ander different name or si there a different way? TIA
Is there any benefit in using an ARRAY _LIST_ to an empty object instead of simple using a collection? If there is EMPTY then there is COLLECTION - and it...