Save as html creates huge files

[etal]

I have written an application that outputs Excel XML 2003 files. These are
simple files around 100k each , each containing a few worksheets with
tablular data ,nothing fancy.

Most of these work fine but one of these files when I load it in Excel 2003
and convert it to html outputs over 60MB of html. I looked at the html output
and found that it consists mostly of empty cells.
Is there something wrong with this file? Is this a known problem? Is there a
workaround?

Any help will be most appriciated.

 

[Nick Hodge]

Etal

Excel will replicate what seems to be it's UsedRange into HTML even if it is
not being used, try resetting it like so

http://www.nickhodge.co.uk/tipstrick.htm#usedrangereset

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

 

[etal]

Thanks, that worked.

I'm still looking into what in the file caused this however and how to
prevent it in the future.

 

[Nick Hodge]

Etal

You cannot really stop it, just take the remedial action either via the UI
or code. Excel has always been poor at re-sizing it's grid after data is
deleted. Additionally, I think some import routines may bring in a standard
size grid, which would also cause this problem

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/