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

RE: Data streams

• To: 'Elliotte Harold' <elharo@m...>, 'Bob Foster' <bob@o...>
• Subject: RE: Data streams
• From: "Stephen E. Beller" <sbeller@n...>
• Date: Tue, 07 Dec 2004 08:09:38 -0500
• Cc: 'Rick Marshall' <rjm@z...>, xml-dev@l...
• Importance: Normal
• In-reply-to: <41B5803C.1030107@m...>
• Organization: NHDS, Inc.

Here's the actual code generated by Excel:

<?xml version="1.0" ?> 
- <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>SEB</Author> 
  <LastAuthor>SEB</LastAuthor> 
  <Created>2004-12-06T20:40:33Z</Created> 
  <Company>abc</Company> 
  <Version>10.6714</Version> 
  </DocumentProperties>
- <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <DownloadComponents /> 
  <LocationOfComponents HRef="file:///\\" /> 
  </OfficeDocumentSettings>
- <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>9345</WindowHeight> 
  <WindowWidth>15225</WindowWidth> 
  <WindowTopX>0</WindowTopX> 
  <WindowTopY>60</WindowTopY> 
  <ProtectStructure>False</ProtectStructure> 
  <ProtectWindows>False</ProtectWindows> 
  </ExcelWorkbook>
- <Styles>
- <Style ss:ID="Default" ss:Name="Normal">
  <Alignment ss:Vertical="Bottom" /> 
  <Borders /> 
  <Font ss:FontName="Tahoma" /> 
  <Interior /> 
  <NumberFormat /> 
  <Protection /> 
  </Style>
  </Styles>
- <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> 
  </Cell>
  </Row>
- <Row>
- <Cell>
  <Data ss:Type="Number">1</Data> 
  </Cell>
  </Row>
- <Row>
- <Cell>
    ==================================
... [ Note: The lines above repeat for every data element ]  ...
    ==================================
</Table>
- <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
  <Selected /> 
- <Panes>
- <Pane>
  <Number>3</Number> 
  <RangeSelection>R1C1:R100C1</RangeSelection> 
  </Pane>
  </Panes>
  <ProtectObjects>False</ProtectObjects> 
  <ProtectScenarios>False</ProtectScenarios> 
  </WorksheetOptions>
  </Worksheet>
  </Workbook>

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.

Steve

-----Original Message-----
From: Elliotte Harold [mailto:elharo@m...] 
Sent: Tuesday, December 07, 2004 5:05 AM
To: Bob Foster
Cc: Rick Marshall; Stephen E. Beller; xml-dev@l...
Subject: Re:  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@m...
XML in a Nutshell 3rd Edition Just Published!
http://www.cafeconleche.org/books/xian3/
http://www.amazon.com/exec/obidos/ISBN=0596007647/cafeaulaitA/ref=nosim

• Follow-Ups:
  • Re: Data streams
    • From: Frank Richards <frank@t...>
  • Re: Data streams
    • From: Elliotte Harold <elharo@m...>

• References:
  • Re: Data streams
    • From: Elliotte Harold <elharo@m...>

• Prev by Date: Re: What niche is XQuery targeting?
• Next by Date: RE: Data streams
• Previous by thread: Re: Data streams
• Next by thread: Re: Data streams
• Index(es):
  • Date
  • Thread