[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Excel XML
Simon, 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" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Author>Simon St.Laurent</Author> <LastAuthor>Simon St.Laurent</LastAuthor> <Created>2003-03-19T20:21:31Z</Created> <LastSaved>2003-03-19T20:23:08Z</LastSaved> <Company>simonstl.com</Company> <Version>11.4920</Version> </DocumentProperties> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> <DownloadComponents/> <LocationOfComponents HRef="file:///C:\MSOCache\All%20Users\20000409-6000-11D3-8CFE- 0150048383C9\"/> </OfficeDocumentSettings> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>8955</WindowHeight> <WindowWidth>11355</WindowWidth> <WindowTopX>360</WindowTopX> <WindowTopY>120</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font/> <Interior/> <NumberFormat/> <Protection/> </Style> </Styles> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="3" x:FullColumns="1" x:FullRows="1"> <Row> <Cell><Data ss:Type="Number">2</Data></Cell> </Row> <Row> <Cell><Data ss:Type="Number">2</Data></Cell> </Row> <Row> <Cell ss:Formula="=SUM(R[-2]C, R[-1]C)"><Data ss:Type="Number">4</Data></Cell> </Row> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Print> <ValidPrinterInfo/> <HorizontalResolution>600</HorizontalResolution> <VerticalResolution>600</VerticalResolution> </Print> <Selected/> <Panes> <Pane> <Number>3</Number> <ActiveRow>1</ActiveRow> <ActiveCol>1</ActiveCol> </Pane> </Panes> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet2"> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet3"> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> </Workbook> -- 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>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|