[prev in list] [next in list] [prev in thread] [next in thread] 

List:       xml-dev
Subject:    Re: [xml-dev] I used Excel Save As to generate XML but some rows in the XML are missing cells ... wh
From:       "Imsieke, Gerrit, le-tex" <gerrit.imsieke () le-tex ! de>
Date:       2021-07-13 18:30:43
Message-ID: 17e50e69-b50e-d398-00ba-8393d5c20e98 () le-tex ! de
[Download RAW message or body]



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.


_______________________________________________________________________

XML-DEV is a publicly archived, unmoderated list hosted by OASIS
to support XML implementation and development. To minimize
spam in the archives, you must subscribe before posting.

[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Or unsubscribe: xml-dev-unsubscribe@lists.xml.org
subscribe: xml-dev-subscribe@lists.xml.org
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php


[prev in list] [next in list] [prev in thread] [next in thread]