OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   RE: [xml-dev] Excel XML

[ Lists Home | Date Index | Thread Index ]


My gut reactions to the Excel XML:

- urn: scheme for namespace ids
  I prefer http, for the discovery possiblities that opens up

- DocumentProperties section
  What, no dublin core?

- file:///C:\MSOCache\All%20Users\20000409-6000-11D3-8CFE-...
  Not sure what this is... but I will hold off on gagging
  as it doesn't look like it's hiding any document data.

- ss:Formula="=SUM(R[-2]C, R[-1]C)"
  Maybe I'm sadistic, but I'd rather be given this as a tree
  than a string.

- ss:Type="Number"
  Hmmm... xsd:double, xsd:float, xsd:decimal might have worked.

- [ProtectObjects]False[/ProtectObjects]
  It might've made sense to use xsd:boolean here, but that
  doesn't seem to be the case, as the "F" is capitalized.
  From: http://www.w3.org/TR/xmlschema-2/#boolean
  "An instance of a datatype that is defined as ·boolean· can have 
   the following legal literals {true, false, 1, 0}" 

- Chris

-----Original Message-----
From: Simon St.Laurent [mailto:simonstl@simonstl.com]
Sent: Wednesday, March 19, 2003 4:11 PM
To: xml-dev@lists.xml.org
Subject: [xml-dev] Excel XML

Excel 2002 included a Save As XML option as well, so the document below
may be familiar territory to some of you.  The XSLT Cookbook includes a
recipe for processing Excel XML, and I know a fair number of businesses
are already at work mining data from spreadsheets and creating new
spreadsheets from data.  I haven't done extensive testing with this
format yet, but it purportedly stores everything in the spreadsheet
except VBA and charts, and some objects end up base64-encoded.

I suspect that the more exciting story about Excel 2003 is its ability
to import and analyze XML data separate from the stylesheet itself.
That prospect makes me (a spreadsheet-hater for nearly a decade) very
excited, since it separates presentation (Excel analysis) from content
(XML data) quite neatly.

For those curious about what Excel XML looks like, however, here's a
sample with only a small set of data.

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>Simon St.Laurent</Author>
  <LastAuthor>Simon St.Laurent</LastAuthor>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
 <Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="3"
    <Cell><Data ss:Type="Number">2</Data></Cell>
    <Cell><Data ss:Type="Number">2</Data></Cell>
    <Cell ss:Formula="=SUM(R[-2]C, R[-1]C)"><Data
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
 <Worksheet ss:Name="Sheet2">
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
 <Worksheet ss:Name="Sheet3">
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

Simon St.Laurent
Ring around the content, a pocket full of brackets
Errors, errors, all fall down!
http://simonstl.com -- http://monasticxml.org

The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this list use the subscription
manager: <http://lists.xml.org/ob/adm.pl>


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS