Exporting excel to xml spreadsheet with blank cells

Question

Hello

I am exporting an excel workbook into xml spreadsheet The excel has lets say 10 columns and 10 rows Some of the cells are empty(i.e with no value) When i save the file into xml spreadsheet and review the row that has blank cell in it it has only cells, the cell with the empty value is not there and the xml show that the cell before the blank and the cell after the blank are one after another (the empty cell just dont exists)

here is a sample of the xml:

<Cell ss:StyleID="s36"><Data ss:Type="Number">cell1</Data><NamedCell
  ss:Name="Print_Area"/></Cell>
<Cell><Data ss:Type="String">cell2</Data><NamedCell ss:Name="Print_Area"/></Cell>
<Cell><Data ss:Type="String">cell4</Data><NamedCell
  ss:Name="Print_Area"/></Cell>

The missing cell is cell3

Any idea anyone ?

Thanks in advance IB

Answer 1

If the cell is empty this seems a reasonable optimization to save space - why should it not be missing.

You have enough information to recreate the original spreadsheet

Answer 2

Is there a way to ask excel not to save space ? The recration is not that easy as it seems using xslt?

Answer 3

Exactly where is the information stored that lets him recreate the spreadsheet? If these rows:

• Data, empty, Data, empty, Data
• Data, Data, Data, empty, empty
• Data, empty, empty, Data, Data

all give

• Row
• Cell Data /Data /Cell
• Cell Data /Data /Cell
• Cell Data /Data /Cell
• /Row