Re: [xml-dev] I used Excel Save As to generate XML but some rows in the XML are missing cells ... which cells?

On 13.07.2021 19:51, Roger L Costello wrote:
> I noticed ss:Index="9" in one of the <Cell> elements and not any of the others. My guess is that it is trying to tell me that, "Hey, this <Cell> corresponds to column 9 (column I) of the spreadsheet, the previous <Cell> (column H) was dropped". Is that what it's saying? More generally, my question is: How do I determine which column Excel dropped in the conversion to XML? Does it always drop the same column, or does it drop different columns in different rows?

As you surmised, it tells you in which column the current cell is and, 
indirectly, how many empty cells you need to insert before in order to 
be able to eliminate @ss:Index.

It’s an attempt at XML data compression on Microsoft’s part I guess.