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


  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

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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