XLSX-Workbook-Class
XLSX-Workbook-Class copied to clipboard
ggreen86
VFP Class to Create an XLSX Workbook without Excel Automation or Installed
I am finding that SetColumnBestFit works well on text, but not so well on numbers, I have tested this on 39 beta 8. The code below is rough and ready...
I have a sheet that hits the SET STEP ON because it has a relType of customXML. Is there a fix for this yet? Not sure why this sheet has...
Hello I am trying to add an image which is a legend to a specific row and column of my spreadsheet. All aspects of creating my Excel using this class...
Hi, Greg and friends. I am testing **TableToExcel**.prg in **r42**, found a bug, and propose a fix. We know that VFP cannot work with General fields. After some asking on...
Good evening. Today, I again have to fill an Excel file with numbers from DBF. The code works somewhat in R38 but raises an error in R42. The problem in...
Hi, I am testing this with my code but Demo() also having same issue. Kindly check attached photo.  From what I can gather problem come from SaveWorkbook function only...
SaveGridToWorkbook doesn't support the Alignment setting of a column. I tried to implement it using this code but for some reason it didn't work (starting at line 212): ``` IF...
I ran into this a while ago so I forget the circumstances, but this fixed it: ``` IF EMPTY(lcAttrValue) *** DH 2024-05-26: return .F. not NULL to prevent "column does...
There are problems opening with Excel if the time is entered in the following form: 2024-10-27T19:15:30+-2:00 Fix if: 2024-10-28T07:05:48Z It would be good if method: writesupportxmls had the same as...
An error occurs if the object in the report footer is not of string type, e.g. datetime(). It would be necessary to supplement the method listeneraddworkbooksheet with lcFtrText = TRANSFORM(lcFtrText)...