Convert a Excel workbook to an xml file

This post is a bit off topic for this blog but I’ll post it anyway as a reminder for myself and hopefully to help others who want to do the same. At a client someone had to convert a very simple, plain, flat text excel 2007 workbook to an xml file format.

I have made an example to let you see how to do this. Below you see the workbook that has to be converted to xml.

exc_workbook1

I thought that just saving the file with “save as” to xml format would do it but I thought wrong. I got an error that there were no XML mappings found in the workbook. For Excel 2007 you need a add-in that is called OfficeExcel2003XMLToolsAddin.exe and which can be downloaded here. On the download page you can also read how to install and open the add-in in Excel 2007.

Read more: http://www.information-worker.nl/2010/04/19/howto-convert-a-excel-workbook-to-an-xml-file

Advertisements

About alamzyah
Name : Alamsyah Nick Name : Alamzyah Place of Birth : Jakarta, 04 June 1983 sex : Male Religion : Moslem Region : Jakarta, Indonesia Specialist : IT, Computer mail : alamzyah@gmail.com

6 Responses to Convert a Excel workbook to an xml file

  1. You got a very good website, Glad I discovered it through yahoo.

  2. kredyty says:

    I’ve got a condition in this specific subject. If anyone will help me then remember to contact us in the handle fajnasuka@harvard.edu. Thank you and greatest respect

  3. place says:

    Very intreresting post. It was very useful. I was searching exaxtly for this. Thank you for your effort. I hope you will write more such useful posts.

  4. Sara hobbins says:

    Cooltopic, helped with my research!! Thanksfor that.

  5. free iphone says:

    Useful information like this one must be kept and maintained so I will put this one on my bookmark list. Thanks for this wonderful post and hoping to see more of this.

  6. Dick Cazarez says:

    I liked as much as you’ll receive carried out right here. The sketch is tasteful, your authored material stylish. however, you command get bought an nervousness over that you wish be handing over the following. sick without a doubt come further beforehand again since exactly the same nearly a lot regularly inside of case you defend this increase.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: