Excel 2003 vs. XML

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open XML Spreadsheets with Excel 2000 1
Can Excel 2002 XML Spreadsheet format be read by Excel 2007? 1
Question on XML in Excel 2003 1
2003 - Import XML 5
Excel 2003 XML Tools Add-in and Excel 2007 1
help required to change format when converted from excel to xml. 1
Import Multiple XML Files into Excel 3
XML File Opened In Excel is Missing Header Row 0

Back
Top