DO NOT REPLY [Bug 52786] New: Not able to write more than 100 rows using SXSSF

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=52786

             Bug #: 52786
           Summary: Not able to write more than 100 rows using SXSSF
           Product: POI
           Version: 3.8-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: critical
          Priority: P2
         Component: SXSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: sabdulrazak@inautix.co.in
    Classification: Unclassified


Hi,
I am trying to create an xlsx file and I have used SXSSF Workbook. I am able to
create a file with more than 100 rows when I run a java client independently.
But when I deploy it on my Websphere 6.1 server it writes only the first 100
rows and skipping the rest of the rows.

Can you please advice?
I am using poi-3.8-beta5 version. Here is the code snippet.

Workbook wb = new SXSSFWorkbook(100); // keep 100 rows in memory, exceeding
rows will be flushed to disk
        SXSSFSheet sh = (SXSSFSheet)wb.createSheet();

for(int rownum = 0; rownum < 10000; rownum++){
            Row row = sh.createRow(rownum);
            for(int cellnum = 0; cellnum < 35; cellnum++){
                Cell cell = row.createCell(cellnum);
                //String address = new CellReference(cellnum).formatAsString();
                cell.setCellValue("Hello World " + cellnum);
           }
}
FileOutputStream out;
        try {
            out = new FileOutputStream(filePath);
            wb.write(out);
            out.close();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 52786] Not able to write more than 100 rows using SXSSF

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=52786

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID

--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2012-02-28 13:47:02 UTC ---
It is a problem with WebSphere, not with POI. 

SXXSF writes temp files. Ensure your application has access to the temp
directory.

Yegor

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org