XLSX-Workbook-Class
XLSX-Workbook-Class copied to clipboard
ggreen86
VFP Class to Create an XLSX Workbook without Excel Automation or Installed
I found a couple of bugs when the Windows currency symbol is set to something other than $, such as €. First bug, in SaveVFPSettings: ``` *** DH 2022-08-29: fixed...
Print_Area and Print_Titles can be integrated into this awesome library by adding 2 methods: METHOD setPrintArea ``` *-- tnEndRow (optional): will default to the last row in the sheet *--...
I just started using this awesome class. I had a need for bestfit/auto fit for column. For some reason when this attribute is set, it never works. We need to...
Another need I came across was center horizontally and vertically. I made the following changes in my code to accommodate this. ``` *-- createWorkingCursors method *- added 2 columns/fields to...
The program below highlights a couple of issues with Datetime formatting. 1. Custom datetime format don't seem to work. 2. Several of the CELL_FORMAT_DATE... entries in VFPxWorkbookXLSX.h don't seem to...
... loXL.SetCellValue(lnWb, lnSheet, 1, 1, 'Header') loXL.SetCellValue(lnWb, lnSheet, 2, 1, 2) ... works fine to create a 2-cell spreadsheet. ... loXL.SetCellValue(lnWb, lnSheet, 1, 1, 1) loXL.SetCellValue(lnWb, lnSheet, 2, 1, 2)...
Hi I have a very simple requirement read some cell values from file **"packing-list.xlsx"** & write same info into file **"performa-invoice,xlsx"** I have created a blank form added VFPxWorkbookXLSX class...
Hi I am using version 33 1. If I create a document using SaveTabletoWorkbookEx I can open it in excel and edit reformat at will. 2. If I re-open the...
Good evening. I'm testing the latest release (R33 beta 10). I open the template - see attached file (template.xlsx), fill the cell values ans use saveworkbookas method to save the...
Hi, Greg and friends. I'm having trouble getting the value of the cell when it contains a formula. Is it possible to get the value? I am not interested in...
