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

Introduction

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

Prototype

@Override
public void setColumnWidth(int columnIndex, int width)

Source Link

Document

Set the width (in units of 1/256th of a character width)

The maximum column width for an individual cell is 255 characters.

Usage

From source file:xx.tream.chengxin.ms.service.ReportServiceImpl.java

@Override
public HSSFWorkbook incomeCommonReport(HSSFWorkbook workbook, Map<String, Object> queryMap) {
    HSSFSheet sheet = workbook.createSheet("new sheet");
    HSSFCellStyle headcell = ExcelUtil.headCell(workbook);
    String heads[] = { "", "?", "", "?", "?", "?", "",
            "", "" };
    String values[] = { "type", "income", "note", "createUserName", "createTime", "createTime", "auditUserName",
            "auditTime", "auditTime" };
    HSSFRow row = sheet.createRow(0);/*from  ww w. j a  v a2s  .  co  m*/
    for (int i = 0; i < heads.length; i++) {
        HSSFCell cell = row.createCell(i);
        cell.setCellValue(heads[i]);
        cell.setCellStyle(headcell);
        sheet.setColumnWidth(i, 4500);
    }
    String end = (String) queryMap.get("endTime");
    Date endDate = DateUtil.stringToDate(end, "yyyy-MM-dd");
    if (endDate != null) {
        //1
        Calendar cal = Calendar.getInstance();
        cal.setTime(endDate);
        cal.add(Calendar.DATE, 1);
        endDate = cal.getTime();
        end = DateUtil.DateToString(endDate, "yyyy-MM-dd");
        queryMap.put("endTime", end);
    }
    List<Map<String, Object>> list = this.incomeCommonService.queryByParam(queryMap);
    if (list != null && list.size() > 0) {
        Double payouts = 0d;
        for (int i = 0; i < list.size(); i++) {
            row = sheet.createRow(i + 1);
            Map<String, Object> map = list.get(i);
            for (int n = 0; n < values.length; n++) {
                HSSFCell cell = row.createCell(n);
                String value = "";
                if (n == 0) {
                    value = (String) map.get(values[n]);
                    if (value != null && value.equals("")) {
                        value = value + "(" + map.get("otherType") + ")";
                    }
                    cell.setCellValue(value);
                } else if (n == 4 || n == 5 || n == 7 || n == 8) {//
                    Date date = (Date) map.get(values[n]);
                    //value = DateUtil.DateToString(date, "yyyy-MM-dd HH:mm");
                    if (n == 4 || n == 7) {
                        value = DateUtil.DateToString(date, "yyyy-MM-dd");
                    } else if (n == 5 || n == 8) {
                        value = DateUtil.DateToString(date, "HH:mm");
                    }
                    cell.setCellValue(value);
                } else if (n == 1 && map.get(values[n]) != null) {
                    Double v = (Double) map.get(values[n]);
                    payouts += v;
                    cell.setCellValue(v);
                } else {
                    value = (String) map.get(values[n]);
                    cell.setCellValue(value);
                }
            }
        }
        row = sheet.createRow(list.size() + 1);
        HSSFCell cell = row.createCell(0);
        cell.setCellValue("?:");
        cell.setCellStyle(headcell);
        cell = row.createCell(1);
        cell.setCellValue(payouts);
    }
    return workbook;
}