>>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