Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fill Excel range with XML?
Message
From
14/11/2003 08:07:43
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
13/11/2003 16:35:04
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00849641
Message ID:
00849831
Views:
36
I guess I have to be more specific. I know I can CursorToXML to create a file and import it into Excel. I was hoping to avoid programmatically formatting the sheet, so the user could have some control. I was asking for an example of populating a range with the XML, so I could avoid file i/o.

What did you think I meant?

>Look into Pivot table and Data/Import external data
>
>Mark
>
>>Hi all
>>
>>I've got about 10,000 records to dump into Excel. There are about 10 client with that many records each. As Tamar Granor puts it in her (and Della Martin's) book, "This method of populating the data ... performs well on small data sets".
>>
>>I'm wondering if there is a way to get Excel to fill a range with a chunk of XML. If so, please share some example code.
>>
>>Thanks!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform