How to Convert data from excel to XML

vsanghvi · Post by **vsanghvi** » Thu Jun 30, 2005 12:32 pm

How can i convert data from Excel sheet (.csv file) to XML output? Has anybody done this before? If so can you share details on what stages you used and how you specified your XML tags etc. I appreciate your help.

Thanks

lshort · Post by **lshort** » Thu Jun 30, 2005 2:52 pm

This is very well documented in the "XML Pack Designer Guide" - Chapter 4 - XML Output. Check your Datastage documents directory.

tonystark622 · Post by **tonystark622** » Thu Jun 30, 2005 3:51 pm

The problem that you're going to have is reading the Excel Spreadsheet in UNIX. DataStage does not ship with an ODBC driver to read Excel in Unix. There are some other ways to do that, but not within DataStage.

You might check out this thread:
viewtopic.php?t=85601&highlight=read+ex ... sheet+unix

for more information.

Good luck,
Tony

Sreenivasulu · Post by **Sreenivasulu** » Fri Jul 01, 2005 12:37 am

I assume a ".so" file would be needed to read an excel in UNIX.

Regards
Sreeni

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 01, 2005 2:48 am

You can gather the csv file and prepare the xml using xml writer.

vsanghvi · Post by **vsanghvi** » Fri Jul 01, 2005 9:57 am

Thanks Guys for the replies. I have .csv file only so i can put it out on Unix and can read it in my source file as an sequential file. However it is going to be a problem if that has comma or semi colen as a data. I am just going to seperate by tab. I will check the document chapter 4 for the details on XML. Let's see how far i can go.

Thanks again and share if you have other thoughts.