[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Excel XML

  • To: "Simon St.Laurent" <simonstl@s...>,<xml-dev@l...>
  • Subject: RE: Excel XML
  • From: "Chris Wilper" <cwilper@c...>
  • Date: Wed, 19 Mar 2003 16:52:24 -0500
  • Thread-index: AcLuW/SHR7hFpaCtS72eLFVkSpifrwAAS/jg
  • Thread-topic: Excel XML

excel xml

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@s...]
Sent: Wednesday, March 19, 2003 4:11 PM
To: xml-dev@l...
Subject:  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>


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.