Bug 51936 - The method 'public void setCellValue(String value)' from class 'SXSSFCell' is not using shared strings table
Summary: The method 'public void setCellValue(String value)' from class 'SXSSFCell' is...
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: unspecified
Hardware: PC Windows XP
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-02 07:16 UTC by raghava.javvaji
Modified: 2011-10-02 09:52 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description raghava.javvaji 2011-10-02 07:16:16 UTC 
The method 'public void setCellValue(String value)' from class 'SXSSFCell' is not using shared strings table for storing common string values. And my sheet*.xml files are huge in size because they are having duplicate string values.why can't we use shared strings table like the way we used in the class 'XSSFCell'.
Comment 1 Yegor Kozlov 2011-10-02 09:52:09 UTC 
It is a feature of the SXSSF API. It does not use shared strings table but instead immediately writes cell values in sheet.xml. The bigger file size is the price you pay for lower memory footprint.

Yegor