Interacting over the Web with XML

The goal of XML is to be a universal language, allowing data to move freely from one application to another. In this case, that means that saving an Excel worksheet as an XML document would allow any other spreadsheet program to read the XML file, separate out the cell names and data, and use the annotations to recreate the worksheet. By the same token, you could take a worksheet saved as an XML file and, regardless of the program in which the file was created, import it into Excel.

Save a Workbook as an XML Spreadsheet

  1. Click the Microsoft Office button.

  2. Click Save As.

  3. Click the Save As Type down arrow.

  4. Click XML Spreadsheet 2003.

  5. Type the file name you want.

  6. Click Save.

    Save a Workbook as an XML Spreadsheet

Import Spreadsheet XML

  1. Click the Microsoft Office button.

  2. Click Open.

  3. Navigate to the folder containing the XML document you want.

  4. Double-click the XML document.

    Import Spreadsheet XML
    Import Spreadsheet XML

    Tip

    Tip

    If you don’t see any XML documents in the Open dialog box, click the file type button and click All Microsoft Excel Files.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.218.239.182