XLSX-Workbook-Class
XLSX-Workbook-Class copied to clipboard
ggreen86
VFP Class to Create an XLSX Workbook without Excel Automation or Installed
There is a bunch of workbook properties listed on page 8 of the doc. Is it right - [ ] in difference to anything else they are not related to...
 Dear Gregory Green, How to remove the display process as shown in the red circle Thanks, Maskur
Is it possible to embed charts into the workbooks being created with this routine? Just a thought.
hey Im trying to get luck with this and dont works could you gime some advices, thank you in advance. loExcel = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx") lnWb = loExcel.CreateWorkbook("ArabicTest.xlsx") always I have...
Not sure what's happening, but SaveWorkBookAs doesn't want to save. It returns .t. but no file appears. I'm sending it the full path name. ``` oXLSX = CREATEOBJECT("VFPWorkBookXSLX.VFPWorkBookXSLX") iWorkbook =...
loSheetProtection =goExcel.GetSheetProtection(lnWb, lnSh) loSheetProtection.Locked = .T. loSheetProtection.PASSWORD = "abc123" goExcel.SetSheetProtection(lnWb, lnSh, loSheetProtection) Sets the sheet protection but does not apply a password. Can you explain to me how to set...
I commented out this code in CheckSheetName to allow a sheet to be named "History": ``` *** DH 2023-07-14: allow History as a sheet name *IF UPPER(lcSheetName) == "HISTORY" *...
There are a few places that assume the Header object of a column is named Header1 but it may not be. Here's the fix: * SaveGridToWorkbook: ``` IF toGrid.HeaderHeight >...
Hi Greg! I wanted to try your program, but at the Newobject line it says: "Property value is out of bound". I tried several versions, all with the same result....
Hi Greg, I love using this class as it is a powerful tool. Congratulation on a great piece of coding. I have made some amendments to your copy (Release 39)...
