Java CellUtil.setAlignment方法代码示例

import org.apache.poi.ss.util.CellUtil; //导入方法依赖的package包/类
protected void setupTotalCell(Cell cell, final String propId, final int currentRow, final int startRow, int col) {
    cell.setCellStyle(getCellStyle(propId, currentRow, startRow, col, true));
    final HorizontalAlignment poiAlignment = getGridHolder().getCellAlignment(propId);
    CellUtil.setAlignment(cell, poiAlignment);
    Class<?> propType = getGridHolder().getPropertyType(propId);
    if (isNumeric(propType)) {
        CellRangeAddress cra = new CellRangeAddress(startRow, currentRow - 1, col, col);
        if (isHierarchical()) {
            // 9 & 109 are for sum. 9 means include hidden cells, 109 means exclude.
            // this will show the wrong value if the user expands an outlined category, so
            // we will range value it first
            cell.setCellFormula("SUM(" + cra.formatAsString(hierarchicalTotalsSheet.getSheetName(),
                    true) + ")");
        } else {
            cell.setCellFormula("SUM(" + cra.formatAsString() + ")");
        }
    } else {
        if (0 == col) {
            cell.setCellValue(createHelper.createRichTextString("Total"));
        }
    }
}
 

import org.apache.poi.ss.util.CellUtil; //导入方法依赖的package包/类
/**
 * Adds the header row. Override this method to change header-row-related
 * aspects of the workbook. Alternately, the header Row Object is accessible
 * via getHeaderRow() after report creation. To change header CellStyle,
 * though, use setHeaderStyle().
 *
 * @param row the row
 */
protected void addHeaderRow(final int row) {
    headerRow = sheet.createRow(row);
    Cell headerCell;
    headerRow.setHeightInPoints(40);
    int col = 0;
    for (final String propId : getPropIds()) {
        headerCell = headerRow.createCell(col);
        headerCell.setCellValue(createHelper.createRichTextString(getGridHolder().getColumnHeader(propId)));
        headerCell.setCellStyle(getColumnHeaderStyle(row, col));

        final HorizontalAlignment poiAlignment = getGridHolder().getCellAlignment(propId);
        CellUtil.setAlignment(headerCell, poiAlignment);
        col++;
    }
}
 

import org.apache.poi.ss.util.CellUtil; //导入方法依赖的package包/类
private Cell createTableHeader(HSSFSheet sheet, int col, String label) {

		int n = sheet.getPhysicalNumberOfRows();
		Row row = null;

		if (n < 1)
			row = sheet.createRow(0);
		else
			row = sheet.getRow(0);

		Cell cell = row.createCell(col);
		cell.setCellValue(label);
		cell.setCellStyle(boldStyle);
		CellUtil.setAlignment(cell, sheet.getWorkbook(), CellStyle.ALIGN_CENTER);

		return cell;

	}
 

import org.apache.poi.ss.util.CellUtil; //导入方法依赖的package包/类
private Cell addTableCell(Row row, int col, String label) {
	Cell cell = row.createCell(col);
	cell.setCellValue(label);
	CellUtil.setAlignment(cell, row.getSheet().getWorkbook(),
			CellStyle.ALIGN_LEFT);

	return cell;
}
 

import org.apache.poi.ss.util.CellUtil; //导入方法依赖的package包/类
private Cell createInputCell(Sheet sheet, String label) {
	Row row = sheet.createRow(sheet.getPhysicalNumberOfRows());
	Cell cell1 = row.createCell(0);
	cell1.setCellValue(label + ":");
	Cell cell2 = row.createCell(1);
	CellUtil.setAlignment(cell2, sheet.getWorkbook(), CellStyle.ALIGN_RIGHT);

	inputCells.put(label, cell2);

	return cell2;
}
 

import org.apache.poi.ss.util.CellUtil; //导入方法依赖的package包/类
protected void setupCell(Cell sheetCell, Object value, Class<?> valueType, String propId, Object rootItemId, int row, int col) {
    sheetCell.setCellStyle(getCellStyle(propId, rootItemId, row, col, false));
    final HorizontalAlignment poiAlignment = getGridHolder().getCellAlignment(propId);
    CellUtil.setAlignment(sheetCell, poiAlignment);
    setCellValue(sheetCell, value, valueType, propId);
}
 

import org.apache.poi.ss.util.CellUtil; //导入方法依赖的package包/类
/** {@inheritDoc} */
@Override
protected void addDataRow(final Sheet sheetToAddTo, final Object rootItemId, final int row) {
    final Row sheetRow = sheetToAddTo.createRow(row);
    Property prop;
    Object propId;
    Object value;
    Cell sheetCell;
    for (int col = 0; col < getPropIds().size(); col++) {
        propId = getPropIds().get(col);
        prop = getProperty(rootItemId, propId);
        if (null == prop) {
            value = null;
        } else {
            value = prop.getValue();
        }
        sheetCell = sheetRow.createCell(col);
        final CellStyle cs = getCellStyle(rootItemId, row, col, false);
        sheetCell.setCellStyle(cs);
        final Short poiAlignment = getTableHolder().getCellAlignment(propId);
        CellUtil.setAlignment(sheetCell, workbook, poiAlignment);
        if (null != value) {
            if (!isNumeric(prop.getType())) {
                if (Date.class.isAssignableFrom(prop.getType())) {
                    sheetCell.setCellValue((Date) value);
                } else if (LocalDate.class.isAssignableFrom(prop.getType())) {
                    sheetCell.setCellValue(((LocalDate) value).toDate());
                } else if (DateTime.class.isAssignableFrom(prop.getType())) {
                    sheetCell.setCellValue(((DateTime) value).toGregorianCalendar());
                } else {
                    sheetCell.setCellValue(createHelper.createRichTextString(value.toString()));
                }
            } else {
                try {
                    // parse all numbers as double, the format will determine how they appear
                    final Double d = Double.parseDouble(value.toString());
                    sheetCell.setCellValue(d);
                } catch (final NumberFormatException nfe) {
                    sheetCell.setCellValue(createHelper.createRichTextString(value.toString()));
                }
            }
        }
    }
}