[Bug 59458] Exporting xlsx using apache poi 3.13 on weblogic : File format or extension not valid

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=59458

--- Comment #4 from Kishan Sarsecha <kishan089...@gmail.com> ---
Minimal code which is not working on WebLogic 10.3.5

        SXSSFWorkbook wb = new SXSSFWorkbook();
        SXSSFSheet sheet = wb.createSheet("Sheet1");

        String[] displayCols = new String[] {"FirstColumn", "SecondColumn",
"ThirdColumn"};
        String[][] values = new String[][] {
                {"Value1", "Value2", "Value3"},
                {"Value4", "Value5", "Value6"},
                {"Value7", "Value8", "Value9"}
        };

        // Creating Title Row
        Row row1 = sheet.createRow(0);

        // Creating the Title line
        Cell cell1 = row1.createCell(0);
        cell1.setCellValue("This is test report");

        // Column Name Row
        int j =0;
        Row row2 = sheet.createRow(1);
        for (String col : displayCols)
        {
            Cell cell2 = row2.createCell(j++);
            cell2.setCellValue(col);
        }

        int i = 2;
        for( String[] strs: values) {
            Row rows = sheet.createRow(i);
            int k = 0;
            for ( String value: strs) {
                Cell cell = rows.createCell(k++);
                cell.setCellValue(value);
            }
            i++;
        }

        try {
            wb.write(os); // os is ServletOutputStream of HTTPServletResponse
        } catch (IOException e) {
            e.printStackTrace();
        }

-- 
You are receiving this mail because:
You are the assignee for the bug.

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