| || |
Create XML from excel data sheet
Has anyone come across a requirement where you create XML from the excel data sheet. I have a spreadsheet that has "n" number of data columns, each data column presents attribute. I am suppose to fetch data and create XML that will be input in a field on web page. Then I receive a XML string as response, which I need to parse and fetch some data elements and do validations. I am looking if someone has something that I can reuse. I am looking for the creation part.
Thanks in advance
Re: Create XML from excel data sheet
From Excel 2003, File->Save As
For Save As Type, Select XML Data