Charles Maxson : TECHED Session CLI355 - Programming Microsoft Office Excel XML Solutions

TECHED Session CLI355 - Programming Microsoft Office Excel XML Solutions

This page is geared for Tech*Ed attendees who want to get access to the session demo content. It probably won't make sense to anyone else anyway but you can download it here and try to figure it out if you wish on your own. Note the following Microsoft disclaimer (just in case ;)

CLI355 - Programming Microsoft Office Excel XML Solutions (slide deck)

Session abstract

With its new XML support, Excel has become the premier rapid application development tool for integrating XML documents into line of business applications. Instead of forcing users to work with arcane XML schemas, you can harness all the power of Excel to process data in XML documents using the Excel user interface. In this session, you’ll see how to automate the new XML-related portions of the Excel object model to integrate Excel and XML. You’ll find out how to automate all of Excel’s XML functionality including adding schemas to Excel documents, mapping XML documents to spreadsheets, loading data into Excel from XML sources, and saving data from Excel back into XML documents. Excel makes creating XML-based workflows easy to implement.

(BTW I did not write that abstract. I also want to give a big shout out to John Peltonen for his inspiration on forming this session.)

Demo Recap

Demo 1 discusses using Excel to consume XML from InfoPath forms that reside in a SharePoint Forms Library.
Demo 2 covers how you can automate the entire process from Demo 1 using code in VSTO 2005.
Demo 3 focuses on SpreadsheetML and how you can use transforms to create workbooks without Excel.
Demo 4 reviews the Excel XML Toolbox add-in.

Downloads