Excel 2003 vs. XML

B

bruce

Hi
I don't have Excel 2003 but would like to know the following to determine if we should invest in Excel 2003
1) In Excel 2003, if you save a spreadsheet as a XML file, how do you validate the data
2) How do you specify the structure of the XML itself
Any help would be much appreciated
Thanks.
 
J

Jim Rech

When you save an Excel workbook in XML format via File, Save As the result
is in MS's "SpreadsheetML" schema. The Excel schema as well as the other
documented Office schemas can to obtained here:

http://www.microsoft.com/downloads/...52-3547-420A-A412-00A2662442D9&displaylang=en

This isn't to be confused with mapping your own schemas to Excel spreadsheet
cells and loading/save data to your XML files. An example of doing that is
found in this MSDN article:

http://msdn.microsoft.com/office/un...rary/en-us/odc_xl2003_ta/html/odc_xlexpen.asp
 
Top