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.


--
BigCohunes
------------------------------------------------------------------------
BigCohunes's Profile: http://www.excelforum.com/member.php...o&userid=30104
View this thread: http://www.excelforum.com/showthread...hreadid=400569