Excel – preserve empty cells when saving excel as xml

excelexcel-2007

I have an excel document where some of the cells are empty
When i save the excel as xml spreadcheet i get the row with only the cells that have data and and the empty cells disapear (and the following cell gets an index attribute to indicate his true position)
Is there a way to save the excel in xml and have the empty cells apear insted of saving space ?
I am running xsl on that xml and need to know the value of a cell exactly even if its empty

Best Answer

I simply put a single quote in the empty cell --> '.

  1. Select the mapped area in Excel andopen use Excel's Find/Replace facility .
  2. Leave the "Find What" field blank.
  3. Enter a single quote in the "Replace With" field.
  4. Press Replace All and re-export to XML. All field should show now.
Related Topic