Results 1 to 4 of 4

Thread: How to convert Excel file data into XML code

  1. #1
    Join Date
    Jun 2009
    Posts
    49

    How to convert Excel file data into XML code

    I am in search of a way how to convert an Excel file data into XML code. I'm not an expert and have no programming knowledge. I've heard that it is easy ti achieve but don't know how. Can you help me how to do so?

  2. #2
    Join Date
    Feb 2008
    Posts
    1,852

    Re: How to convert Excel file data into XML code

    The easiest way to convert a spreadsheet's data to XML is to use either a commercial product (such as iMaker for Excel for a single developer license) or any of a number of publicly-available VB/VBA modules (such as Scott Woods's contribution).

    For more information: http://www.xml.com/pub/a/2002/01/09/q-and-a.html

  3. #3
    Join Date
    May 2008
    Posts
    685

    Re: How to convert Excel file data into XML code

    A VBA macro can convert a table into a simple XML file. The file will contain 6 records, each containing 5 fields as shown below. When the procedure is run it prompts you for the output filename; the range of cells containing the field names; and the data table itself. To see the VBA program see the attachment. You can Copy the text, open Excel VBA and Paste the selection into a module.

  4. #4
    Join Date
    Nov 2005
    Posts
    1,323

    Re: How to convert Excel file data into XML code

    XML Converter is a data converting software that lets the user to interactively create a data transformation. It allows you to use XML documents by exporting source data into XML file. XML Converter is a visual mapping and conversion tool, which manages all dialects of XML such as DTD, XSD, and XML formats. It is used for quickly building application integration solutions. It will allow you to map and integrate a lot of source data types to XML document in a user-friendly graphical mode.

Similar Threads

  1. Replies: 4
    Last Post: 04-01-2014, 10:47 AM
  2. Replies: 2
    Last Post: 17-02-2012, 02:06 PM
  3. Replies: 3
    Last Post: 13-01-2012, 04:57 PM
  4. Convert Excel data to HTML Table
    By Chalina in forum Software Development
    Replies: 2
    Last Post: 04-08-2009, 11:21 PM
  5. Convert tabular data to a matrix in Excel
    By Rookieinexcel in forum Windows Software
    Replies: 2
    Last Post: 23-04-2009, 10:19 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,716,881,672.34318 seconds with 17 queries