Displaying multiple XML files

[indupriya9]

I have a number of XML files in a directory with the same format. I would like to display these files in a readable format either in html or excel.

I tried importing in Excel 2003 using the standard Data -- XML -- Import menu. But with this I am having problems with importing multiple xml documents. The error that comes up is "No data was imported".

Can anyone suggest me a soultion to display these XML files in a meaningful way?

Thanks in advance
ip

 

[chrismassey]

Hello,

I know that it is possible to use Perl to open a directory and go through each of the XML files recursively and print their contents onto into a HTML document. Do you have any experience with using Perl? If not then it is relatively easy to use. If you were to use Perl the Perl script won't be long nor complicated. So I would be happy to provide a Perl example to perform this task.

Chris

 

[indupriya9]

Hi Chris

Thanks for your reply and your offer. I donot know how to use Perl. I know ASP. What are the requirements for using Perl? What is the WebServer used? How do I view a Perl file? Lot of questions. If it is easy to use then I would love to try your script.

Thanks
ip

 

[k5tm]

While this is not too complicated, you need to put several things together.

If your goal is merely to pull together a few documents of identical structure, then write a simple XSLT to do so, using the document() function to bring in multiple input documents. You may download msxsl.exe from the Microsoft web site to provide a simple to use command line structure. You can learn most/all of what you need to know at

http://www.w3schools.com.

If your goal is really just HTML, this will probably get you there.

Then, if you are trying to create 'real' Excel XML documents, you need to download and understand the XML schema for Office 2003, also available on the Microsoft web site. This is a bit more complicated, and would benefit from using a visual tool such as Stylus Studio or Altove XMLSpy.

Tom Morrison

http://www.liant.com