Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who has used xlsgen as a replacement Excel COM?
Message
From
26/01/2015 14:33:38
 
 
To
26/01/2015 13:53:15
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01614068
Message ID:
01614339
Views:
61
Hi Dragan,

>Since every *.xlsx (or docx or an otherx) is actually a zipped set of xml files (with subfolders), you may just extract the appropriate file from that set and extract what you >need. I've done some of that with some of .od? (Ooo/LibreOffice) formats, who have done that several years before M$ did, and it wasn't too bad.

I understand you can do it. However I doubt I'll be able to extract 90,000 cells content per second on an oldish celeron from a complex data structure such as the ones of this software dinosaur from VFP without resorting to highly demanding C or C++ code via fll. Do not really want to invest that time to-day. Last time I coded a .fll was around 1992 if my memory serves me well:) A couple of lines of manipulations via COM certainly fits my agenda much better.

By the way it looks like the product does generate od* file but does not offer data import from these format sat this stage. That would make it more attractive for sure. The real problem is the price that may be difficult to justify.

Daniel

PS: fetching MS-Excel cells from VFP via EXCEL automation on my good ol' dev machine peaks at around 2,000 cells per sec... As opposed to 90,000 with this solution. That's a difference IMHO:) I understand you can peek MS-Excel data per block into VFP arrays or resort to tricks such as ADO. But this sheer speed should allow for trivial code when massaging MS-Excel from within VFP. I like that.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform