>>>Please view the whole thread. I replied yesterday or 2 days ago. You will need to see the message by itself to see the attachment to it. Message #
01672692>>Naomi,
>>Found your import.xlsx - data is on sheet 9 (On-Hand Suppliers) only.
>>Confirmed Vilhelm's class does not import this.
>>Trust Vilhelm will read this message, maybe he can show a light on this?
>>Regards,
>>Koen
>
>So, you confirmed the problem with numeric data when they saved as text, right? If we save them as numbers, they are read correctly.
Naomi,
No, No, I donot confirm. I can only confirm that I recve an error, when issuing following code on version 4.0:
lcFileName = "d:\foxexamples\excel\vilhem-importxlsx\importxlsx 4.0\naomi\import.xlsx"
*Set Point To ','
SET POINT TO '.'
? Set('Point')
cCur = importfromxlsx(lcFileName,1,9,.T.,.T.,0,'')
"error opening workbook xml"
Either your sample is not correct or Vihelm has to correct something. However I can confirm that usualy I can open/import an Excel sheet with all kinds of data, numbers, dates a.s.o.
Have meanwhile mailed Vilhelm, and advise you to wait for him.
Regards,
Koen
Select (cCur)