How to Create an Excel XML Map for Vb.Net

Written by lora covrett
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create an Excel XML Map for Vb.Net
XML has greatly simplified data handling between different computer technologies. (Jason Reed/Photodisc/Getty Images)

XML schema mapping is a new feature of Excel 2003 that allows developers to link database data directly to an Excel workbook. Data from a database stored as XML can be imported directly into an Excel workbook once that data is mapped. XML data can also be easily exported from an Excel map. A reference to an Excel workbook, the "XMLMaps" object, an XML schema file, and an XML data file are all that is needed to display XML data in Excel.

Skill level:
Moderately Challenging

Other People Are Reading

Instructions

  1. 1

    Declare variables to hold the "Workbook" and the "XMLMap" in Excel. The "MapData" method retrieves the XML map information to the VB.Net application.

  2. 2

    Use the "Add" method of the XMLMaps collection to create a new XMLMap object from an XML spreadsheet.

  3. 3

    Import the XML data with the "importXML" method of the XMLMap object. Provide the XML data stream to the "importXML" method.

  4. 4

    Export data from the Excel map to an XML file using the "exportXML" method of the XMLMap object.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.