Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Import XML produced by MS-Excel?
Message
From
13/05/2004 20:46:45
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00903822
Message ID:
00903930
Views:
22
It's an XML generated by MS-Excel 2003, I didn't have that version in my PCs (to be true, I don't have any version of MS-Excel)...
I've try this code:
lcXMLFile = GETFILE("XML")
IF NOT EMPTY(lcXMLFile)
  oXMLAdapter = CREATEOBJECT("XMLAdapter")
  oXMLAdapter.LoadXML(lcXMLFile,.T.)
  ?oXMLAdapter.Tables.Count && 0!! Non Tables...
ENDIF
Can anybody confirm if I can´t process this kind of XML? The company who provide this file is not responding :S...


>It depends on your XML. The XMLAdapter() is also limited in what kind of XML it can process.

>>Thanks sergey, it works, but now I have another issue, as you should expect, now a have a beauty cursor with 7 rows, in this cursor I have a field called Table with all the information in the Worsheet I want to use. It's not necesary to say I'd like the information in that field, obviously as a cursor.
>>So?, do I need XMLAdapter? Or what else I can do?
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform