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] Data streams

[ Lists Home | Date Index | Thread Index ]

Here's the actual code generated by Excel:

<?xml version="1.0" ?> 
- <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
- <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
- <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <DownloadComponents /> 
  <LocationOfComponents HRef="file:///\\" /> 
- <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
- <Styles>
- <Style ss:ID="Default" ss:Name="Normal">
  <Alignment ss:Vertical="Bottom" /> 
  <Borders /> 
  <Font ss:FontName="Tahoma" /> 
  <Interior /> 
  <NumberFormat /> 
  <Protection /> 
- <Worksheet ss:Name="Sheet1">
- <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="100"
x:FullColumns="1" x:FullRows="1">
- <Row>
- <Cell>
  <Data ss:Type="Number">1</Data> 
- <Row>
- <Cell>
  <Data ss:Type="Number">1</Data> 
- <Row>
- <Cell>
... [ Note: The lines above repeat for every data element ]  ...
- <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
  <Selected /> 
- <Panes>
- <Pane>

As I said, Excel adds about 50 lines per file that are not directly related
to the data elements, although some are necessary for any XML doc.


-----Original Message-----
From: Elliotte Harold [mailto:elharo@metalab.unc.edu] 
Sent: Tuesday, December 07, 2004 5:05 AM
To: Bob Foster
Cc: Rick Marshall; Stephen E. Beller; xml-dev@lists.xml.org
Subject: Re: [xml-dev] Data streams

Bob Foster wrote:

> I don't think so.c Did you look at the sample he posted?
>  > Every one of the XML data elements had this tagging structure:
>  > <Row>
>  >    <Cell><Data ss:Type="Number">1</Data></Cell>
>  > </Row>
>  >
>  > In contrast, the CSV had this structure: 1,

We've yet to actually see the raw data, and I don't have a Windows box 
with Excel XP handy to try to reproduce it myself. However, I strongly 
doubt that is the only extra information in his file. Microsoft Office 
products tend to store a lot of extra content in even the simplest 
files, that tends to add a large constant factor to every file saved. 
This extra content is not included in CSV files but is included in 
Office XML files.

Elliotte Rusty Harold  elharo@metalab.unc.edu
XML in a Nutshell 3rd Edition Just Published!


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

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