[Home] [By Thread] [By Date] [Recent Entries]


On Tuesday 07 December 2004 08:09, Stephen E. Beller wrote:

Right off the bat, those 'data' tags, and the 'ss:Type' attribute are 
redundant. That information is not in the CSV, it just assumes that there is 
one datum per cell, and that they're all numbers. Make a schema, or throw in 
two lines at the top of the xml doc to establish that, and more than half of 
your xml file is gone with no loss of information.

If you really care, goto single letter tag names, and even for single digit 
data (how real is that?) you have '<d>1</d>' vs '1,' or 8 to 2, not 50 to 1.

Frank

> Here's the actual code generated by Excel:

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

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member