Home > Articles > Web Services > XML

XML Case Study: Converting Excel Diaries to XML

  • Print
  • + Share This
Excel workbooks are extremely versatile at calculating and graphing workbook data. But workbooks don't make an ideal repository, given Excel's inherent size limitations and less-than-stellar access by other enterprise applications. This article explores the process using VBScript to convert Excel workbooks to a composite XML file.

Introduction

Source files related to this article can be downloaded here.

The sheer weight and number of popular Microsoft Excel how-to manuals speaks volumes on Excel's usefulness and ubiquity. Excel produces magnificent spreadsheets and charts for both business and personal use. However, limitations on rows, columns, and sheer size preclude Excel workbooks from being the optimal repository for burgeoning data stores. Add to this the difficulty of comparing worksheets to other enterprise data sources, and questions surface of how and where to store this data to make it both accessible and extensible.

One solution is to convert some of the workbooks to XML, which is rapidly becoming the data-conversion medium of choice both on the Internet and in large conversion projects from diverse sources and systems. XML provides the quintessential separation of content from display.

It's no coincidence that Microsoft uses XML as the underpinning of recordsets in .NET. The ease with which Visual Studio .NET can generate hierarchical relationships and schema from an XML file loudly trumpets this fact.

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.