Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

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
Vijay Gummadi at 2007-11-11 23:29:55 >