preserve empty cells when saving excel as xml

Question

Hello,

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

Thanks in advance IB

Answer 1

From your question it is not clear if you are talking about empty cells within the data or cell outside the data. If you are talking about empty cells outside of the data area than there is not much you can do since it is effectively an infinite number of cells. You could always simply pad the cells after importing if you want to have more cells or rows.

Answer 2

Just type spaces in the cells you want to preserve.

Answer 3

The cells are spread out along the excel and i have 1000+ rows. Also my client suppose to save the excel as xsl spreadsheet and send me the xml. I can tell him what to do (checking checkboxxes etc) but unable to send him macro or any special program.