Bug 52108 - facing excel file size double issue
Summary: facing excel file size double issue
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC Windows Server 2003
: P2 blocker (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2011-10-28 07:17 UTC by ramesh
Modified: 2011-10-28 17:17 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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