import xml data
how can i import xml data to excel
[34 byte] By [
arturo] at [2007-11-9 15:25:56]

# 1 Re: import xml data
Hi,
There are many ways to accomplish this task.
a) Write a Visual Basic macro in MS Excel to parse the XML and populate the
cells as appropriate.
b) Write a Stylesheet to generate a CSV file from the XML and then read in
the CSV into Excel.
c) If you are using MS Excel 2002, the software has native support for XML.
Visit http://msdn.microsoft.com/msdnnews/2001/may/Excel/Excel.asp for more
information.
Vijay
"arturo" <pepe@terra.es> wrote:
>
>how can i import xml data to excel