Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing XML file into Excel
Message
From
28/02/2003 01:05:16
Ken Knorr
Logos Management Software
Ventura, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Importing XML file into Excel
Miscellaneous
Thread ID:
00759266
Message ID:
00759266
Views:
47
After spending many hours trying to figure out why Excel (Office XP) would not import XML files created with VFP, discovered problem.

If the flag Preserve white space is used then Excel will always reject the xml file. It appears to take every row and duplicate it N + 2 times where N is the number of fields in XML file.

I used: cursortoxml(alias(), "d:\test.xml", 1, 2+4+8+512, "1")

Had to remove the flag option 4.
Reply
Map
View

Click here to load this message in the networking platform