Examples of org.apache.poi.ss.usermodel.Sheet.autoSizeColumn()

org.apache.poi.ss.usermodel.Sheet.autoSizeColumn()
Adjusts the column width to fit the contents.
This process can be relatively slow on large sheets, so this should normally only be called once per column, at the end of your processing.
You can specify whether the content of merged cells should be considered or ignored. Default is to ignore merged cells. @param column the column index

      }      
      createCell(workbook, row, counter+1, "Uspesno/Neuspesno", CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER);
      createCell(workbook, row, counter+2, "Komentar", CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER);
      
      for (int i=0; i<counter+3; i++) {
        sheet.autoSizeColumn(i);
      }
    }
      
    try {
      FileOutputStream fileOutput = new FileOutputStream(reportFile + ".xls");

View Full Code Here

            r1.getCell(i+0).setCellStyle(iPercent);
            r1.getCell(i+1).setCellStyle(d1Percent);
            r1.getCell(i+2).setCellStyle(d2Percent);
        }
        for (int i=0; i<12; i++) {
            s.autoSizeColumn(i);
        }
        
        // Check the 0(.00)% ones
        assertAlmostEquals(980, s.getColumnWidth(0), fontAccuracy);
        assertAlmostEquals(1400, s.getColumnWidth(1), fontAccuracy);

View Full Code Here

          cell.setCellValue(text);
          cindex++;
        }
      }
       for(int i=0; i<titleList.size(); i++){
                 sheet.autoSizeColumn(i); 
       }
      
    } catch (Exception e) {
      e.printStackTrace();
    }

View Full Code Here


        //increase row height to accomodate two lines of text
        row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints()));


        //adjust column width to fit the content
        sheet.autoSizeColumn(2);


        FileOutputStream fileOut = new FileOutputStream("ooxml-newlines.xlsx");
        wb.write(fileOut);
        fileOut.close();
    }

View Full Code Here


    //设定冻结表头
    s.createFreezePane(0, 2, 0, 2);


    //设定所有Column宽度自动配合内容宽度
    s.autoSizeColumn(0);
    s.autoSizeColumn(1);
    s.autoSizeColumn(2);


    //产生标题
    generateTitle(s);

View Full Code Here

    //设定冻结表头
    s.createFreezePane(0, 2, 0, 2);


    //设定所有Column宽度自动配合内容宽度
    s.autoSizeColumn(0);
    s.autoSizeColumn(1);
    s.autoSizeColumn(2);


    //产生标题
    generateTitle(s);
    //产生表头

View Full Code Here

    s.createFreezePane(0, 2, 0, 2);


    //设定所有Column宽度自动配合内容宽度
    s.autoSizeColumn(0);
    s.autoSizeColumn(1);
    s.autoSizeColumn(2);


    //产生标题
    generateTitle(s);
    //产生表头
    generateHeader(s);

View Full Code Here

                    resultRow.createCell(0).setCellValue(testId);
                    resultRow.createCell(1).setCellValue(result.getDeclaringClass().getSimpleName());
                    resultRow.createCell(2).setCellValue(description);
                    resultRow.createCell(3).setCellValue(time);
                }
                sheet.autoSizeColumn(0);
                sheet.autoSizeColumn(1);
                sheet.autoSizeColumn(2);
                sheet.autoSizeColumn(3);
            }

View Full Code Here

                    resultRow.createCell(1).setCellValue(result.getDeclaringClass().getSimpleName());
                    resultRow.createCell(2).setCellValue(description);
                    resultRow.createCell(3).setCellValue(time);
                }
                sheet.autoSizeColumn(0);
                sheet.autoSizeColumn(1);
                sheet.autoSizeColumn(2);
                sheet.autoSizeColumn(3);
            }

View Full Code Here

                    resultRow.createCell(2).setCellValue(description);
                    resultRow.createCell(3).setCellValue(time);
                }
                sheet.autoSizeColumn(0);
                sheet.autoSizeColumn(1);
                sheet.autoSizeColumn(2);
                sheet.autoSizeColumn(3);
            }




            //Comparable export

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.