MS Excel Connecting Excel to the WorldMS Excel - Connecting Excel to the World
Load an XML Document into Excel
Save to SpreadsheetML and Extracting Data
Create Spreadsheets using SpreadsheetML
Import Data Directly into Excel
Access SOAP Web Services from Excel
Create Excel Spreadsheets Using Other Environments
If someone sends you an XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.
Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information.
While exporting spreadsheets as XML is useful, Excel also lets you import information this way, letting you create spreadsheets using SpreadsheetML.
Using Company's Web Services as a source of data, you can easily integrate live information about books into Excel spreadsheets. This example imports sales rank data for particular books and calculates the average rank.
If your spreadsheet needs to access constantly updated data, or if you need to access services hosted on another computer, Excel's Web Services support will enable you to get connected.