Example usage for org.apache.poi.xssf.usermodel XSSFSheet autoSizeColumn

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFSheet autoSizeColumn.

Prototype

@Override
public void autoSizeColumn(int column, boolean useMergedCells) 

Source Link

Document

Adjusts the column width to fit the contents.

Usage

From source file:com.griffinslogistics.document.excel.CMRGenerator.java

private static void generate(XSSFWorkbook workbook, BookspackageCMRModel bookspackageCMRModel,
        Pulsiodetails pulsioDetails) {//from   ww  w  .j av a  2 s. co  m
    //Get first sheet from the workbook
    XSSFSheet sheet = workbook.createSheet(bookspackageCMRModel.getPackageNumber());
    setDefaultSheetStyles(sheet);

    Map<String, CellStyle> styles = createStyles(workbook);
    int currentRow = 2;
    Row headerRow = sheet.createRow(currentRow);

    generateHeaderRow(headerRow, styles, bookspackageCMRModel.getPackageNumber());
    currentRow = generateSenderAndDriver(sheet, styles, currentRow);
    currentRow = generatePoint2Till9(sheet, styles, currentRow, bookspackageCMRModel.getDeliveryAddress());

    double weight = bookspackageCMRModel.getTotalWeight();
    Long totalBoxesCount = bookspackageCMRModel.getTotalBoxesCount();
    currentRow = generatePoints10Till15(totalBoxesCount, weight, sheet, styles, currentRow);
    currentRow = generatePoint15Till19(sheet, styles, currentRow);
    currentRow = generatePoint20Till24(sheet, styles, currentRow, pulsioDetails);

    sheet.autoSizeColumn(1, false);
    sheet.autoSizeColumn(2, false);
    sheet.autoSizeColumn(7, false);
    sheet.autoSizeColumn(9, false);

    sheet.setFitToPage(true);
}

---

From source file:com.griffinslogistics.excel.CMRGenerator.java

public static void generateAll(OutputStream outputStream, List<BookspackageCMRModel> bookspackageCMRModels,
        Pulsiodetails pulsioDetails) {/*from   w  ww . ja  v a 2  s . c om*/
    try {
        XSSFWorkbook workbook = new XSSFWorkbook();

        for (BookspackageCMRModel bookspackageCMRModel : bookspackageCMRModels) {

            XSSFSheet sheet = workbook.createSheet(bookspackageCMRModel.getPackageNumber());
            setDefaultSheetStyles(sheet);

            Map<String, CellStyle> styles = createStyles(workbook);
            int currentRow = 2;
            Row headerRow = sheet.createRow(currentRow);

            generateHeaderRow(headerRow, styles, bookspackageCMRModel.getPackageNumber());
            currentRow = generateSenderAndDriver(sheet, styles, currentRow);
            currentRow = generatePoint2Till9(sheet, styles, currentRow,
                    bookspackageCMRModel.getDeliveryAddress());

            double weight = bookspackageCMRModel.getTotalWeight();
            Long totalBoxesCount = bookspackageCMRModel.getTotalBoxesCount();
            currentRow = generatePoints10Till15(totalBoxesCount, weight, sheet, styles, currentRow);
            currentRow = generatePoint15Till19(sheet, styles, currentRow);
            currentRow = generatePoint20Till24(sheet, styles, currentRow, pulsioDetails);

            sheet.autoSizeColumn(1, true);
            sheet.autoSizeColumn(2, true);
        }

        workbook.write(outputStream);
    } catch (FileNotFoundException ex) {
        Logger.getLogger(CMRGenerator.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(CMRGenerator.class.getName()).log(Level.SEVERE, null, ex);
    }
}

---