Visual Studio Tools for Office: Using C# with Excel, Word, Outlook, and InfoPath

Chapter 21. Working with XML in Excel

Introduction to Excel's XML Features

The first thing to note about the XML features described in this chapter is that most of them are only available in Microsoft Office Professional Edition 2003 and the standalone Microsoft Office Excel 2003. If you work with other Office editions, such as Microsoft Office Standard Edition 2003, Microsoft Office Student and Teacher Edition 2003, or Microsoft Office Basic Edition 2003, the XML features described in this chapter are not available.

Many of the XML features of Excel are accessed via Excel's XML Source task pane. To bring up the XML Source task pane, display the task pane if it is not already displayed by choosing Task Pane from Excel's View menu. The task pane ...