EDN Admin
Well-known member
I found one reference that suggested this indicated the relative column position in a row. However, after reviewing a number of XML format spreadsheet I am convinced that is not true.
One spreadsheet XML I looked at had cell parameters like this:
<Row>
<Cell ss:Index="19 <Data ss:Type="Number 10993.74</Data></Cell><br/>
<Cell ss:Index="2 <Data ss:Type="Number 10993.7399</Data></Cell><br/>
<Cel ss:Index="12 <Data ss:Type="Number -1E-4</Data></Cell><br/>
<Cell><Data ss:Type="Number 0</Data></Cell><br/>
<Cell ss:Index="4 <Data ss:Type="Number 22.41</Data></Cell>
</Row>
with the data in columns A, B, C, D, and E so that pretty much indicates to me ss:Index is not the column number.
However, I have a spreadsheet where the data starts on the fifth row, and the XML shows <Row ss:Index="5 for that row. SO, in this instance the ss:Index does seem to indicate the physical position of that row in the spreadsheet.
Or is the ss:Index parameter just an artifact that gets ignored by Excel when its associated with a Cell? <hr class="sig Thanks, Bobw
View the full article
One spreadsheet XML I looked at had cell parameters like this:
<Row>
<Cell ss:Index="19 <Data ss:Type="Number 10993.74</Data></Cell><br/>
<Cell ss:Index="2 <Data ss:Type="Number 10993.7399</Data></Cell><br/>
<Cel ss:Index="12 <Data ss:Type="Number -1E-4</Data></Cell><br/>
<Cell><Data ss:Type="Number 0</Data></Cell><br/>
<Cell ss:Index="4 <Data ss:Type="Number 22.41</Data></Cell>
</Row>
with the data in columns A, B, C, D, and E so that pretty much indicates to me ss:Index is not the column number.
However, I have a spreadsheet where the data starts on the fifth row, and the XML shows <Row ss:Index="5 for that row. SO, in this instance the ss:Index does seem to indicate the physical position of that row in the spreadsheet.
Or is the ss:Index parameter just an artifact that gets ignored by Excel when its associated with a Cell? <hr class="sig Thanks, Bobw
View the full article