Does VFPxWorkbookXLSX work with old .XLS files? 1

[Rajesh Karunakaran]

Hi friends,

A simple query. I have been using VFPxWorkbookXLSX to work with .XLSX file... pretty good...!
However, when I try to open a .XLS file, both 'OpenXlsxWorkbook' and 'OpenXlsxWorkbookSheet' returns 0, i.e., it failed!

E.g:

oSource = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx")
oSourceBook = oSource.OpenXlsxWorkbook('d:\temp\rajesh.xls')

Here, oSourceBook is 0.

Rajesh



Rajesh

 

[mJindrova]

VFPxWorkbookXLSX read XLSX files only. XLSX is a ZIP archive - then is simply extract files from zip archive and read data.
XLS is binary file.



mJindrova

 

[Rajesh Karunakaran]

Hi mJindrova

Yes, I saw that!
I have already converted the XLS into XLSX. Now, I will process it for my purpose.
Thanks.



Rajesh