• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

convert from excel to xml

Hello experts,

I would like to know if there is a way to copy the data from an excel row to be placed inside an xml tag attribute. To see what Im talking about please take a look at the attached image.

So, I would like to grab a row from the excel file and place each cell on its corresponding xml attribute  as shown in the image. I don't do this manually  because there are hundreds of data and that would take me days to finish up. Any suggestion I would greatly appreciate it.

Thanks,

additions.gif
0
glepiza
Asked:
glepiza
1 Solution
 
Julian HansenCommented:
Save the excel spreadsheet as XML - then if you need to parse the XML file produce by Excel and write to your own format (or use XSLT)
0
 
yogi4lifeCommented:
You could simply use formulas to generate the tags from a table like in this spreadsheet. When you have your complete table filled in you can select all the rows and columns containing the XML and do a copy and paste into Notepad. Remember to SAVE AS UTF-8 and not ANSI...

Table2XML.xlsx
0
 
glepizaAuthor Commented:
yogi4life!, thank you very much, you are an genius!!!!!!!!!!

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now