Dave Crozier wrote on 2016-08-15:
I have been forced to bite the bullet on a small project and use embedded
OLE Excel objects as general fields in a VFP table.
Although totally against my principles where I would normally save the
link to a physical Excel sheet and then open it up as a com object, is there anyone who knows how I can drive the embedded Excel object in the same way that you can when using Automation?
Ideally I want to query the embedded Excel and pull back a named range of
cells. Into VFP.
Any ideas?
Dave
Dave,
So using automation to pull the information into a cursor then using CursorToXml to store the data from the spreadsheet is out of the question?
The only other thing I can suggest is to STRCONV the actual XLS file to a string that you can store in a MEMO field.
Tracy Pearson PowerChurch Software