Save As .XML, not exporting blank cells

[roblo]

I have a sheet with a XML map applied and I want to use the Save As o
Export command to transfer that data to a .XML file. But I also wan
the blank cells exported as well. Excel 2003 doesn't seem to expor
cells if they are empty.

Is there a way to export all the cells even if they are blank?

Thanks
rober

 

[roblo]

bump....

 

[BigCohunes]

Unfortunatly, Excel does not provide a way to do this. There is no way
for Excel to export empty cells.

I ran into this problem a little while back, I ended up writing a perl
script to create the XML.

Good luck.