Save as html creates huge files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thanks, that worked.

I'm still looking into what in the file caused this however and how to
prevent it in the future.
 
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/
 
Back
Top