Example usage for org.apache.poi.hssf.usermodel HSSFSheet setDefaultColumnStyle

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFSheet setDefaultColumnStyle.

Prototype

@Override
public void setDefaultColumnStyle(int column, CellStyle style) 

Source Link

Document

Sets the default column style for a given column.

Usage

From source file:org.databene.formats.xls.BeanXLSWriter.java

License:Open Source License

private void writeHeaderRow(E bean, HSSFSheet sheet) {
    HSSFRow headerRow = sheet.createRow(0);
    for (int i = 0; i < beanProperties.size(); i++) {
        PropFormat prop = beanProperties.get(i);
        // write column header
        String componentName = prop.getName();
        headerRow.createCell(i).setCellValue(new HSSFRichTextString(componentName));
        // apply pattern
        if (prop.getPattern() != null) {
            HSSFDataFormat dataFormat = workbook.createDataFormat();
            CellStyle columnStyle = workbook.createCellStyle();
            columnStyle.setDataFormat(dataFormat.getFormat(prop.getPattern()));
            sheet.setDefaultColumnStyle(i, columnStyle);
        }//from www. j ava 2  s  . c o m
    }
}

---

From source file:org.databene.platform.xls.XLSEntityExporter.java

License:Open Source License

private void writeHeaderRow(Entity entity, HSSFSheet sheet) {
    HSSFRow headerRow = sheet.createRow(0);
    int colnum = 0;
    for (Map.Entry<String, Object> component : getComponents(entity)) {
        String componentName = component.getKey();
        headerRow.createCell(colnum).setCellValue(new HSSFRichTextString(componentName));
        ComponentDescriptor cd = entity.descriptor().getComponent(componentName);
        PrimitiveType primitiveType;
        if (cd.getTypeDescriptor() instanceof SimpleTypeDescriptor)
            primitiveType = ((SimpleTypeDescriptor) cd.getTypeDescriptor()).getPrimitiveType();
        else//from   w ww.  ja  va2  s .  co m
            throw new UnsupportedOperationException("Can only export simple type attributes, "
                    + "failed to export " + entity.type() + '.' + cd.getName());
        Class<?> javaType = (primitiveType != null ? primitiveType.getJavaType() : String.class);
        String formatString = null;
        if (BeanUtil.isIntegralNumberType(javaType))
            formatString = getIntegralPattern();
        else if (BeanUtil.isDecimalNumberType(javaType))
            formatString = getDecimalPattern();
        else if (Time.class.isAssignableFrom(javaType))
            formatString = getTimePattern();
        else if (Timestamp.class.isAssignableFrom(javaType))
            formatString = getTimestampPattern();
        else if (Date.class.isAssignableFrom(javaType))
            formatString = getDatePattern();
        if (formatString != null) {
            HSSFDataFormat dataFormat = workbook.createDataFormat();
            CellStyle columnStyle = workbook.createCellStyle();
            columnStyle.setDataFormat(dataFormat.getFormat(formatString));
            sheet.setDefaultColumnStyle(colnum, columnStyle);
        }
        colnum++;
    }
}

---