Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AppendFromXlsx code and text format in Excel
Message
From
26/01/2020 12:25:14
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01672618
Message ID:
01672758
Views:
57
>>>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform