Huge filesize when saving with hidden rows or cols


#1

Hi,

I am working with excel templates that have hidden rows and columns. For example a sheet, that has all rows above 50 are hidden, and all columns above 20, too.

When opening the template and saving it again the filesize is about 1,5mb, but the template has only 20kb.

I am using Aspose.Excel 2.8.3.0!

Any hints?

Michael Mann


#2

Dear Michael,

I test it in my machine and don’t find any problem.

Do you access the cells in those hidden areas?

Could you please send me your template and the generated file? I will check it.


#3

Hi,

no I don’t access the cells in the hidden area. I sent my example to
excel@aspose.com with the same subject.

I ran the example on my machine and the saved file size has raised from 18kb to 1,4mb.

Thanks
Michael


#4

Hi,

can you reproduce the problem with my example?

Michael


#5

Hi Michael,

Please download and try v2.8.6. And please remove your code to hide rows. Those lines of code increased the file size.


#6

Hi Laurence,

I got your hotfix, but I’m not able to open an excel template using a stream any more.
I sent you the same example as before with the same subject in the mail heading.

Thanks
Michael Mann


#7

Hi Michael,

In previous version, Aspose.Excel can open a file with dual format, for example, your file with “Microsoft Excel 97 - 2002 & 5.0/95 workbook” format. However, we find there are some problem since Aspose.Excel doesn’t support Excel95 and before format any more.

So please use Excel97 or above version MS Excel to open your template and save them as “Microsoft Excel Workbook”. Then all will be fine.


#8

Hi Laurence,

thanks for the hint - that did it. All works fine.

Michael