How can i handle the auto size issue in a java report usinig poi 3.15?

Question

trying to export on one excel file using this method:

private Sheet activeSheet;
public void addText(int column, int rowNumber, String s) throws Exception {
    // TODO Auto-generated method stub
    Row row = activeSheet.getRow(rowNumber);
    if(row==null){
        row = activeSheet.createRow(rowNumber);
    }
    Cell cell = row.createCell(column);

    s = ToolUtils.nn(s);
    if(s.indexOf("\n")!=-1){
        int nbLines = StringUtils.countMatches(s, "\n") ;
        CellStyle cs = workbook.createCellStyle();
        cs.setWrapText(true);
        //cs.set
        cell.setCellStyle(cs);
        row.setHeightInPoints(((nbLines+1)*activeSheet.getDefaultRowHeightInPoints()));
        activeSheet.autoSizeColumn(column);

    }

    //cell.setCellValue(s);
    cell.setCellValue(s == null ? "" : s);
}

I have got this error:

java.lang.IllegalStateException: Could not auto-size column. Make sure the column was tracked prior to auto-sizing the column

I have try to call this methode:

trackAllColumnsForAutoSizing() to fix the issue but it does not work as know method for the sheet interface. Shall I upgrade the apache poi version? what shall I do do fix the method that insert data into the excel columns?

just as other remarque when I try to call the methode trackAllColumnsFor AutoSizing() : alwyes I have got this : The method trackAllColumnsForAutoSizing() is undefined for the type SXSSFSheet !! — user3070123, Jul 19 '18 at 13:42
https://stackoverflow.com/questions/14497082/autosizecolumns-on-sxssfworkbook Refer this may this help. — sidd shadab, Jul 19 '18 at 13:46
unfortunatly not , I have updated on my methode to make sure the cells are not empty .. but it does not solve the problem — user3070123, Jul 19 '18 at 13:50

sidd shadab · Answer 1 · 2018-07-19T16:20:03.663

3

private SXSSFSheet activeSheet;
public void addText(int column, int rowNumber, String s) throws Exception {
    // TODO Auto-generated method stub

ActiveSheet=workbook.createSheet();
    Row row = activeSheet.getRow(rowNumber);
    if(row==null){
        row = activeSheet.createRow(rowNumber);
    }
    Cell cell = row.createCell(column);
cell.setCellValue(s == null ? "" : s);
    s = ToolUtils.nn(s);
    if(s.indexOf("\n")!=-1){
        int nbLines = StringUtils.countMatches(s, "\n") ;
        CellStyle cs = workbook.createCellStyle();
        cs.setWrapText(true);
        //cs.set
        cell.setCellStyle(cs);
        row.setHeightInPoints(((nbLines+1)*activeSheet.getDefaultRowHeightInPoints()));
   activeSheet.trackColumnsForAutoSizing();    activeSheet.autoSizeColumn(column);

    }



}

Try this once may this helps you There may be some syntax error just resolved/adjust those in your IDE.

edited Jul 19 '18 at 16:20

answered Jul 19 '18 at 13:51

sidd shadab

123
1
11

any other suggestions ? – user3070123 Jul 19 '18 at 14:51
Before autoresize() try use trackColumnsForAutoSizing() – sidd shadab Jul 19 '18 at 15:05
This is known issue of Api and gets fixed in POI 3.15-beta2 via – sidd shadab Jul 19 '18 at 15:12
((SXSSFSheet) activeSheet).trackColumnsForAutoSizing(); activeSheet.autoSizeColumn(column) .... I have try this but i have got "The method trackColumnsForAutoSizing() is undefined for the type SXSSFSheet" ...Shall I change the API version – user3070123 Jul 19 '18 at 15:15
Try activesheet.trackColumnforAutoSizing(int column ), you can try by cntrl+space in your IDE if eclipe/intellij/Rad – sidd shadab Jul 19 '18 at 15:19
Even doc of Api says this Call trackAllColumnsForAutoSizing() on the SXSSFSheet object before calling autoSizeColumn(columnIndex) and it will be fixed – sidd shadab Jul 19 '18 at 15:21
the method trackColumnsForAutoSizing(int) is undefined for the type Sheet..this what I get – user3070123 Jul 19 '18 at 15:26
private Sheet activeSheet; // I have made a cast as this ((SXSSFSheet) activeSheet).trackColumnsForAutoSizing(); // but it return that message : The method trackColumnsForAutoSizing() is undefined for the type SXSSFSheet" – user3070123 Jul 19 '18 at 15:42
private Sheet activeSheet change this to private SXSSFSheet activeSheet – sidd shadab Jul 19 '18 at 15:48
rearlly many thanks for you help .. but I have alwayes this error :The method trackColumnsForAutoSizing(int) is undefined for the type SXSSFSheet – user3070123 Jul 19 '18 at 15:57
Even after changing sheet to SXSSFSHEET? – sidd shadab Jul 19 '18 at 16:10
Make that thing to activeSheet =workbook.createSheet(); – sidd shadab Jul 19 '18 at 16:13
I have alwyes same issue :'( – user3070123 Jul 19 '18 at 16:22
Could you please share me your import – sidd shadab Jul 19 '18 at 16:23
Sharing imports? – sidd shadab Jul 19 '18 at 16:31
what do you mean by sharing import ? sorry but I have not get it ? – user3070123 Jul 19 '18 at 16:33
It's OK, if this starts working then please let me know what was the root cause. – sidd shadab Jul 20 '18 at 21:34

score 1 · Answer 2 · answered Jul 19 '18 at 16:25

public void addText(int column, int rowNumber, String s) throws Exception {
    // TODO Auto-generated method stub
    Row row = activeSheet.getRow(rowNumber);
    if(row==null){
        row = activeSheet.createRow(rowNumber);
    }
    Cell cell = row.createCell(column);
    s = ToolUtils.nn(s);



    if(s.indexOf("\n")!=-1){
        int nbLines = StringUtils.countMatches(s, "\n") ;
        CellStyle cs = workbook.createCellStyle();
        cs.setWrapText(true);
        //cs.set
        cell.setCellStyle(cs);
        row.setHeightInPoints(((nbLines+1)*activeSheet.getDefaultRowHeightInPoints()));
        activeSheet.trackColumnsForAutoSizing(column);
        activeSheet.autoSizeColumn(column);


    }

    //cell.setCellValue(s);
    cell.setCellValue(s == null ? "" : s);

}

score 0 · Accepted Answer · answered Jun 02 '21 at 04:21

0

may not be exactly related, but you can try this:

        sheet.trackAllColumnsForAutoSizing();
    for (int i = 0; i < 11; i++) {
        sheet.autoSizeColumn(i);
    }

("i" should be less than your column numbers)

answered Jun 02 '21 at 04:21

Mahdi Ahmadvand

16
1

How can i handle the auto size issue in a java report usinig poi 3.15?

3 Answers3