Geeks With Blogs
Tech Notes There are 10 types of people in the world, those who understand binary, and those who dont!

Learn how to use XML maps to customize Excel as a data input and display system.

Many automated spreadsheet solutions support the fact that XML maps in Microsoft Office Excel 2003 provide a fast and flexible way to move data between scattered spreadsheet cells and a back-end data source. Custom automation of the XML mapping process does three things:

  • Eliminates errors when spreadsheet authors want to change the layout (for example, add or remove or move data cells)
  • Significantly decreases change-processing time
  • Provides useful metadata to facilitate database maintenance, and streamlines reporting from data gathered in the data source–linked spreadsheet.

This article describes several useful methods that enable advanced Excel users to automate the XML mapping process.

Posted on Thursday, April 28, 2005 8:29 PM | Back to top

Comments on this post: Automating the XML Data Mapping Process in Excel 2003

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Thota Umesh | Powered by: