Bug 52108

Summary: facing excel file size double issue
Product: POI Reporter: ramesh <javaramesh123>
Component: HSSFAssignee: POI Developers List <dev>
Severity: blocker    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows Server 2003   

Description ramesh 2011-10-28 07:17:57 UTC
Dear Sir,

I am facing a issue in my struts 1.3 application, I have used
both (displaytag.sf.net) and  (org.apache.poi.hssf.usermodel.HSSFWorkbook) concepts to export the data
into excel.

for example I have exported the (300 rows * 20 Coulmn) in both the way
display tag and POI HSSFWorkbook,in display tag file size in 17 KB working fine
but in HSSFWorkbook the file size is trible (52 KB) compare to display tag.please guide
me how to resolve this issue.

Note: I am not reporting it is bug, I have required some help to
resolve this issue.

thanks and regards,
Comment 1 Nick Burch 2011-10-28 17:17:07 UTC
POI can read Excel files with optimised records (such as MulRK and MulBlank), but always writes in the expanded form. For files containing lots of small numbers (for an example), this can result in an increase in file size on writing