General information
Title:
Importing XML file into Excel
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only