• From: Roger L Costello <costello@m...>
• To: "xml-dev@l..." <xml-dev@l...>
• Date: Tue, 13 Jul 2021 18:27:12 +0000

Hi Peter,

> if the right-hand-most column[s] are missing (no data) they can be omitted.

A very reasonable guess indeed. Unfortunately, not correct. In my data the very first <Row> containing 15 child elements, the last child element (the last Excel column) contains data. An earlier column was deleted. Which one? 

/Roger


-----Original Message-----
From: Peter Flynn <peter@s...> 
Sent: Tuesday, July 13, 2021 2:17 PM
To: xml-dev@l...
Subject: [EXT] Re:  I used Excel Save As to generate XML but some rows in the XML are missing cells ... which cells?


On 13/07/2021 18:51, Roger L Costello wrote:
> Hi Folks,
> 
> I have an Excel spreadsheet. If has 16 columns. I did a File >> Save 
> As "XML Spreadsheet 2003 (*.xml)" to generate XML.
> 
> I opened the generated XML document. It has a <Row> for the header. 
> That <Row> has 16 child elements, corresponding to the 16 columns in
> the spreadsheet. And, there is a <Row> corresponding to each row in
> the spreadsheet. Most of the <Row> elements have 16 child elements,
> but some have only 15 child elements.

My [limited] understanding of spreadsheets is that if the
right-hand-most column[s] are missing (no data) they can be omitted.
This appears to be true for CSS export (try it and see), so perhaps they
are doing the same for their XML.

Peter

_______________________________________________________________________

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@l...
subscribe: xml-dev-subscribe@l...
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php