Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AppendFromXlsx code and text format in Excel
Message
From
29/01/2020 08:02:00
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01672618
Message ID:
01672832
Views:
59
>>I made a change in appendfromxlsx to cope with this situation.
>>Please try the attached version (appendfromxlsx 3.2) and give me a reply.
>>
>>
>
>I tried your new code in this test program and it worked.
>
>
>use in select('csrOnHand_Quantities')
>create cursor csrOnHand_Quantities (Department C(10), Category C(10), item C(10), ;
>	MatrixRowValue varchar(100), MatrixColumnValue varchar(100), LocationDescription varchar(100), ;
>	Quantity I, UnitCost n(12,4))
>	
>LOCAL lcFile 
>
>lcFile = GETFILE('xlsx')
>
>
>=MESSAGEBOX(AppendFromXlsx(m.lcFile, "csrOnHand_Quantities",,2, "On-Hand Quantities", .t.))
>browse
>
>Can I please email you the program I was currently using to see what needs to be adjusted in it?
>
>Thanks in advance.
>
>In my form I first used some code to extract the data and then processed all the worksheets in the file.

With for instance BeyondCompare you can easily see the difference between the old version and the new. If any of the files involved are SCX or VCX, Frank Perez has made an extension for them, http://pfsolutions-mi.com/blog/category/VFP2Text.aspx
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform