List of autoSizeColumn() Examples

Examples of autoSizeColumn()

org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn()
Adjusts the column width to fit the contents. @param column the column index
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
org.apache.poi.xssf.usermodel.XSSFSheet.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. @param column the column index

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

                    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

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

                    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

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

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




            //Comparable export
            for (Map.Entry<String, List<Result>> entry : results.entrySet()) {

View Full Code Here

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

                    Cell cell = row.getCell(colMapping.get(result.getDeclaringClass().getSimpleName()));
                    cell.setCellValue(result.getDuration());
                    //cell.setCellStyle(style);
                }


                sheet.autoSizeColumn(0);
                for (Integer i : colMapping.values()) {
                    sheet.autoSizeColumn(i);
                }
            }
            fileOut = new FileOutputStream(fileName);

View Full Code Here

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

                    //cell.setCellStyle(style);
                }


                sheet.autoSizeColumn(0);
                for (Integer i : colMapping.values()) {
                    sheet.autoSizeColumn(i);
                }
            }
            fileOut = new FileOutputStream(fileName);
            wb.write(fileOut);
        } catch (IOException e) {

View Full Code Here

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

            for (Map.Entry<String, String> entry : sysInfo) {
                Row row = sysSHeet.createRow(count++);
                row.createCell(0).setCellValue(entry.getKey());
                row.createCell(1).setCellValue(entry.getValue());
            }
            sysSHeet.autoSizeColumn(0);
            sysSHeet.autoSizeColumn(1);


            //Plain export
            for (Map.Entry<String, List<Result>> entry : results.entrySet()) {
                Sheet sheet = getOrCreateSheet(entry.getKey(), wb);

View Full Code Here

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

                Row row = sysSHeet.createRow(count++);
                row.createCell(0).setCellValue(entry.getKey());
                row.createCell(1).setCellValue(entry.getValue());
            }
            sysSHeet.autoSizeColumn(0);
            sysSHeet.autoSizeColumn(1);


            //Plain export
            for (Map.Entry<String, List<Result>> entry : results.entrySet()) {
                Sheet sheet = getOrCreateSheet(entry.getKey(), wb);
                log.info("Creating sheet " + sheet.getSheetName());

View Full Code Here

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

  {
    InputStream inStream = new FileInputStream("data/workbook.xls");
    Workbook workbook = WorkbookFactory.create(inStream);
    
    Sheet sheet = workbook.createSheet("new sheet");
    sheet.autoSizeColumn(0); //adjust width of the first column
    sheet.autoSizeColumn(1); //adjust width of the second column
    
    FileOutputStream fileOut;
    fileOut = new FileOutputStream("data/AutoFit_Apache.xls");
    workbook.write(fileOut);

View Full Code Here

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

    InputStream inStream = new FileInputStream("data/workbook.xls");
    Workbook workbook = WorkbookFactory.create(inStream);
    
    Sheet sheet = workbook.createSheet("new sheet");
    sheet.autoSizeColumn(0); //adjust width of the first column
    sheet.autoSizeColumn(1); //adjust width of the second column
    
    FileOutputStream fileOut;
    fileOut = new FileOutputStream("data/AutoFit_Apache.xls");
    workbook.write(fileOut);
    fileOut.close();

View Full Code Here

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

       cell = row.createCell((short) 3);
       cell.setCellValue(account.getEntityId());
       cell.setCellStyle(style);
     }


     sheet.autoSizeColumn(1);
     sheet.autoSizeColumn(2);
     sheet.autoSizeColumn(3);
     
      // Write the output to a file
      FileOutputStream fileOut = new FileOutputStream("C:/Temp/workbook.xls");

View Full Code Here

0 1 2 3 4

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.