Re: [xml-dev] I used Excel Save As to generate XML but some rows inthe XML are missing cells ... which cells?
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.
