[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: I used Excel Save As to generate XML but some rows inthe X

• From: Peter Flynn <peter@silmaril.ie>
• To: xml-dev@lists.xml.org
• Date: Tue, 13 Jul 2021 19:17:12 +0100

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

• References:
  • I used Excel Save As to generate XML but some rows in the XML aremissing cells ... which cells?
    • From: Roger L Costello <costello@mitre.org>