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

Re: Data streams

• To: "Stephen E. Beller" <sbeller@n...>
• Subject: Re: Data streams
• From: Elliotte Harold <elharo@m...>
• Date: Tue, 07 Dec 2004 09:21:03 -0500
• Cc: 'Bob Foster' <bob@o...>, 'Rick Marshall' <rjm@z...>, xml-dev@l...
• In-reply-to: <005b01c4dc5e$0263fbc0$6501a8c0@dell8100>
• References: <005b01c4dc5e$0263fbc0$6501a8c0@dell8100>
• User-agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.3) Gecko/20040910

Stephen E. Beller wrote:

> Here's the actual code generated by Excel:

 From the code below we see that the XML document does contain quite a 
bit of information that's simply not present in a CSV file. The mere act 
of saving to CSV loses information compared to either the XML or native 
binary Excel format. You're comparing oranges to grapefruits, and 
concluding oranges are smaller, no surprise there. A fairer comparison 
would eliminate the extra metadata Excel includes in its binary and XML 
files but not in the CSV files, and then compare the compressed XML and 
CSV formats.

> - <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">

-- 
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

• References:
  • RE: Data streams
    • From: "Stephen E. Beller" <sbeller@n...>

• Prev by Date: RE: Data streams
• Next by Date: Re: Data streams
• Previous by thread: RE: Data streams
• Next by thread: Re: Data streams
• Index(es):
  • Date
  • Thread