[
Lists Home |
Date Index |
Thread Index
]
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>
|