Open Esox61 opened 1 year ago
What are you doing to get this message? Please provide me a sample of your code that produces this problem.
Greg
From: Esox61 @.> Sent: Friday, August 25, 2023 11:27 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)
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. Can you tell me what the solution is?
Thx: Esox
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KHH2Q2WUI74G5MPULXXC757ANCNFSM6AAAAAA36VJL6Y. You are receiving this because you are subscribed to this thread.Message ID: @.**@.>>
I tried the XLSX-Workbook-Class\Program Demos\openappendsheet.prg in Vfp8
.
I tried the same program and it successfully opens the selected workbook with no errors and resaves it; note that I made a change to the relative path of the vcx (see below). Can you please re-run on your PC and select ‘Suspend’. Then open the Debugger and show me the program step that it has stopped at and the local variable values via a screen shot.
@.***
Greg
From: Esox61 @.> Sent: Friday, August 25, 2023 12:01 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)
I tried the XLSX-Workbook [Clipboard01]https://user-images.githubusercontent.com/58699655/263326922-b999ae35-e9f5-4d31-bf5d-3d0817534748.png -Class\Program Demos\openappendsheet.prg.
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1693583423, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33OU24ATGMIU4ZTRQ3DXXDD3JANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.**@.>>
I made a change to the relative path of the vcx (see below). Sorry, but see what?
Is that what you thought?
I think you need to change the line:
goExcel = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx")
To
goExcel = NEWOBJECT("VFPxWorkbookXLSX", "..\VFPxWorkbookXLSX.vcx")
Greg
From: Esox61 @.> Sent: Friday, August 25, 2023 3:03 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)
I made a change to the relative path of the vcx (see below). Sorry, but see what?
[Clipboard01]https://user-images.githubusercontent.com/58699655/263366754-a1473a97-0cb1-448f-bff2-059587fefc87.png Is that what you thought?
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1693807555, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IUAL57JWOTKQ3GAVLXXDZFXANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.**@.>>
I did it, but the same error message came up :(
Not sure what your problem exactly is. I still think you are having a problem with the paths. Try this at the command line:
SET PATH TO
From your screen shot below, I think “
This should create an object goExcel that can be viewed in the Debugger. Also, you should have many cursors created that start with ‘xl_’. If this works, then at the command line try:
lnWb = goExcel.OpenXlsxWorkbook(“c:\fox\program demos\proba.xlsx”)
This will then open the workbook and fill the “xl_” cursors with the workbook information (note that the workbook must exist).
If this works, then try at the command line:
goExcel.SaveWorkbookAs(lnWb, "c:\fox\program demos\probaCopy.xlsx")
This will then save the opened workbook as a copy.
Greg
From: Esox61 @.> Sent: Friday, August 25, 2023 3:57 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)
I did it, but the same error message came up :( [Clipboard01]https://user-images.githubusercontent.com/58699655/263376839-6d344b2a-a1de-4c46-bd39-7493c843b10f.png
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1693864883, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33MH7YNQ7LB3SAZKT6TXXD7QJANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.**@.>>
I did what you described. I typed in the command "set path to "c:\fox". Here is the VFPxWorkbookXLSX.vcx, which the program finds. However, it cannot create the goExcelt object, instead it gives the usual error message: Property valueis out of bounds. :(
I tried it on other PC, the result is same :( Which version did you try it? I use Vfp 8.
I tried to open the TestForm form:
Does this help you identify the error?
Hello—
I am able to open the form without an error. When I first opened it, it prompted me for the location of the workbook class – I selected the location and then the form opened as shown:
@.***
Greg
From: Esox61 @.> Sent: Monday, August 28, 2023 1:37 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)
I tried to open the TestForm form: [Clipboard02]https://user-images.githubusercontent.com/58699655/263602394-7e9ef68e-1b05-48a0-8d9c-c8a476b00969.png Does this help you identify the error?
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1695040295, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33JZFNHQQGXYCCCMFQTXXQU6JANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.**@.>>
I think the version of VFP is your problem. I am using VFP9 SP2. I believe there are features in version 9 that are being used that are not available in version 8.
From: Esox61 @.> Sent: Sunday, August 27, 2023 12:24 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)
I tried it on other PC, the result is same :( Which version did you try it? I use Vfp 8.
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1694707389, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IUOYXSEIHJO3JZEWLXXNYB7ANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.**@.>>
Thank you for your answers! I'm very sad! :(
Hi Esox61,
VFP9 is now already 19 years old. Nineteen! Seems to me that there would have been really enuf time to recompile your stuff. Come on, give it a try! 😊
(If you really don't have a VFP9 at the office, there are several downloads floating around the Internet, and MS doesn't care about VFP)
With kind regards from Bavaria
Jürgen Wondzinski Visual FoxProhttp://www.msdn.com/vfoxpro Evangelist Microsoft "Most Valuable Professionalhttp://mvp.microsoft.com/de-de/overview.aspx" from 1996 to 2009, "Servoy Valued Professionalhttp://www.servoy.com/“ 2011 My XING Profilehttps://www.xing.com/profile/Juergen_Wondzinski, and LinkedInhttp://www.linkedin.com/in/wondzinski and Facebookhttp://www.facebook.com/juergen.wondzinski and Twitterhttp://www.twitter.com/wondzinski and….. GCS d+ s:+ a+++ C++ !U P--- L E? W++ N++ o-- K--? w+++ O? !M--? V-- PS PE !Y? !PGP t 5 X R tv- b DI+ D? G e++ h-- r+++ y+++
Von: Esox61 @.> Gesendet: Montag, 28. August 2023 15:24 An: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Betreff: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)
Thanks for your answers! I'm very sad! :(
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1695695271, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABROXQ3ATVCM7WE5CJJ6I5LXXSLXFANCNFSM6AAAAAA36VJL6Y. You are receiving this because you are subscribed to this thread.Message ID: @.**@.>>
Hi Jürgen!
Yes, you are right, Vfp9 has been around for a long time. I heard at the time that there were compatibility problems between Vfp8 and Vfp9, so I didn't dare to switch. (Anyway, yesterday I installed Vfp9 as a trial, tried VFPxWorkbookXLSX.vcx and it runs under Vfp9 on my machine.)
I wish you all the best: Esox61
@Esox61 And have not been solved? Please tell me what are them for me to try'em. Thanks....
@jhernancanom Greg tried to help a lot and finally the solution is to run this vcx only under Vfp9.
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. Can you tell me what the solution is?
Thx: Esox