ggreen86
ggreen86
Hello-- The method for adding numeric formats does not handle the date or datetime format addition. I am adding a new method to allow for adding custom date or datetime...
Can you provide sample code? Thank you. ________________________________ From: Lutz Scheffler ***@***.***> Sent: Thursday, May 13, 2021 10:40 AM To: ggreen86/XLSX-Workbook-Class ***@***.***> Cc: Subscribed ***@***.***> Subject: [ggreen86/XLSX-Workbook-Class] GetNamedRanges DataType (#46)...
Lutz-- I see the benefit of using the collection class instead of an object. However, in my style of coding I do not use the VFP collection class (I have...
I will add a new method GetNamedRangesEx that uses your code. ________________________________ From: Lutz Scheffler ***@***.***> Sent: Friday, May 14, 2021 11:09 AM To: ggreen86/XLSX-Workbook-Class ***@***.***> Cc: ggreen86 ***@***.***>; Comment...
I will have to review this more. The problem I had in trying to set the column to the best fit is how to account for long strings. This could...
Hello-- After you have opened each workbook, you do not need to reopen the workbook again. The method call lnSh1 = thisform.Vfpxworkbookxlsx1.OpenXlsxWorkbookSheet("D:\TEMP\packing-list.xlsx", "SHEET1") Opens the workbook a second time. Use...
Please attach and send the sample files. ________________________________ From: ashishbhasin29 ***@***.***> Sent: Thursday, July 7, 2022 3:11 AM To: ggreen86/XLSX-Workbook-Class ***@***.***> Cc: ggreen86 ***@***.***>; Comment ***@***.***> Subject: Re: [ggreen86/XLSX-Workbook-Class] unable...
Doug-- Can you provide a column format example of the z-format usage? Thank you. Greg ________________________________ From: Doug Hennig ***@***.***> Sent: Tuesday, July 20, 2021 10:29 AM To: ggreen86/XLSX-Workbook-Class ***@***.***>...
Hello-- I cannot reproduce the error that you are seeing. Below is my code: Test 1: lnWb = loExcel.CreateWorkbook("FirstRowTest.xlsx") lnSh = loExcel.AddSheet(lnWb, "Sheet1") loExcel.SetCellValue(lnWb, lnSh, 2, 1, 20) && Sheet1,...
John-- I just tried your code below and it successfully created a spreadsheet that I could open. lnWb = loXL.CreateWorkbook('bad.xlsx') lnSh = loXL.AddSheet(lnWb, "Sheet1") *loXL.SetCellValue(lnWb, lnSh, 1, 1, 'Data') loXL.SetCellValue(lnWb,...