Create XML from Excel based on certajn schema

Posted on 2010-11-29
Medium Priority
Last Modified: 2012-05-10

I have an Application which is accepting importing the data only from XML files and I have the data which i need to import in Excel sheet, how i can use the xml schema from a source from the same application (which i got by exporting similar data to xml) and create an XML file ready to be imported to the application.

Can you please help me with this

Question by:nadermik
LVL 42

Expert Comment

by:Meir Rivkin
ID: 34229350
it depends how the data is represented in your excel file.
you probably need a conversion layer which generate xml based on the data in the excel.
LVL 13

Accepted Solution

gbanik earned 2000 total points
ID: 34234744
I would say ... i depends on how much time you are prepared to spend.

Read this article ...

Excel natively stores its data in XML. You can directly read the source XML file corresponding to each Excel file. You may have to write an initial small code for unzipping the Excel file.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question