XML, SQL Server, and Excel
Recent articles on these MS Office related technologies.
Excel 2003 Sample: Replicating Formulas to SQL Server Learn how to automate a process for storing Excel 2003 formulas in a SQL Server database. This allows access from the database to the calculated spreadsheet values available only in the worksheet.
Automating the XML Data Mapping Process in Excel 2003 In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system.
XSH: Interactively Manipulate and Analyze XML Data from DevX.com's XML Zone. Most developers use some kind of XSLT engine to pick out and process data from structured XML files. Learn how XSH, an open source command-line XML shell, lets you interactively query and manipulate this data without the coding overhead.