search

ggreen86 / XLSX-Workbook-Class

VFP Class to Create an XLSX Workbook without Excel Automation or Installed
46 stars 16 forks source link

Need repair after saving same file with SaveWorkbook function #120

Closed Abh7791 closed 1 month ago

Abh7791 commented 2 months ago

Hi, I am testing this with my code but Demo() also having same issue. Kindly check attached photo. image

From what I can gather problem come from SaveWorkbook function only . Thanks

ggreen86 commented 2 months ago

Hello—

I just created the ExcelTest.xlsx file from the Demo() method (I am using Release 44) via excelxlsxtest.prg. I also successfully opened it in Excel 2016 with no errors. Please send me the ExcelTest.xlsx file that you created and send me the corrected file from Excel as ExcelTest_Fixed.xlsx so that I can see if I can find a problem.

Greg

From: Abh7791 @.> Sent: Wednesday, August 7, 2024 11:07 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Need repair after saving same file with SaveWorkbook function (Issue #120)

Hi, I am testing this with my code but Demo() also having same issue. Kindly check attached photo. image.png (view on web)https://github.com/user-attachments/assets/31aea569-7775-47d0-baf4-7b64643dd951

From what I can gather problem come from SaveWorkbook function only . Thanks

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/120, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33LUF3MTEA2VHGXL6G3ZQIZYTAVCNFSM6AAAAABMETXBJKVHI2DSMVQWIX3LMV43ASLTON2WKOZSGQ2TGNZSGUZDQMI. You are receiving this because you are subscribed to this thread.Message ID: @.**@.>>

Abh7791 commented 2 months ago

Thanks for quick reply . I have checked again with release 44 and using office 2019 professional plus. I am attaching both excel files. ExcelTest_originaal.xlsx ExcelTest-Fixed.xlsx

ggreen86 commented 2 months ago

In looking at your original file that was created, you are missing the Image Example sheet being written correctly. I suspect that you may be missing the file “vfpxbanner.gif” which should be in the same directory as the default directory. The program “excelxlsxtest.prg” if executed will set the current directory to its execution path; on my system this is:

SET DEFAULT TO "e:\my work\foxpro\projects\workbookxlsx\program demos" DO excelxlsxtest.prg

You might try the above in VFP by navigating to the directory containing the program “excelxlsxtest.prg” and then executing it.

Greg

From: Abh7791 @.> Sent: Sunday, August 11, 2024 1:01 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Need repair after saving same file with SaveWorkbook function (Issue #120)

Thanks for quick reply . I have checked again with release 44 and using office 2019 professional plus. I am attaching both excel files. ExcelTest_originaal.xlsxhttps://github.com/user-attachments/files/16571625/ExcelTest_originaal.xlsx ExcelTest-Fixed.xlsxhttps://github.com/user-attachments/files/16571626/ExcelTest-Fixed.xlsx

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/120#issuecomment-2282533207, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33NMYAMQ3N3335S35N3ZQ3VZDAVCNFSM6AAAAABMETXBJKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBSGUZTGMRQG4. You are receiving this because you commented.Message ID: @.**@.>>

Abh7791 commented 2 months ago

I just did another test. I created simple xlsx file just one column . and saved it again by function SaveWorkbook . It giving me same error.

Abh7791 commented 2 months ago

I just did another test. I created simple xlsx file just one column . and saved it again by function SaveWorkbook . It giving me same error.

ggreen86 commented 2 months ago

I would have to have your code in order to be able to understand what you did. The class does not have a method to create a column; it has a method to assign a value to a cell. The class does have a method to define a column width.

Right now I am not able to reproduce any error that you are describing. I have attached the xlsx file that the demo method creates. Please try to open this file with your version of Excel and if it gives an error, please send me the corrected file that Excel produces.

Thank you.

Greg

From: Abh7791 @.> Sent: Saturday, August 17, 2024 7:12 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Need repair after saving same file with SaveWorkbook function (Issue #120)

I just did another test. I created simple xlsx file just one column . and saved it again by function SaveWorkbook . It giving me same error.

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/120#issuecomment-2294829085, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33LUFX4ARLLSMJVNDXTZR4VYVAVCNFSM6AAAAABMETXBJKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOJUHAZDSMBYGU. You are receiving this because you commented.Message ID: @.**@.>>

ggreen86 commented 1 month ago

Closing issue. No reply from Originator from my last request for more testing. The problem may be in how Excel 2019 is expecting the file layout. I have no way to test with Excel 2019 and I cannot reproduce any errors with Excel 2016 that I have installed.