Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
XML To Excel
- Thread starter nikol
- Start date
- Thread starter
- #2
one easy thing to do is to use XSL to transform the document into an HTML table...
Then right-click on the table and "Export to Microsoft Excel"
Otherwise, you could write a script or VBA macro to do this but that requires further knowlege... If you are interested in taking the VBA path, just let me know, Otherwise try the XSL method...
If you can supply a sample of your XML, we can get you started on the XSL...
Visit My Site
PROGRAMMER:
Red-eyed, mumbling mammal capable of conversing with inanimate objects.
Then right-click on the table and "Export to Microsoft Excel"
Otherwise, you could write a script or VBA macro to do this but that requires further knowlege... If you are interested in taking the VBA path, just let me know, Otherwise try the XSL method...
If you can supply a sample of your XML, we can get you started on the XSL...
Visit My Site
PROGRAMMER:
Red-eyed, mumbling mammal capable of conversing with inanimate objects.- Status