Example usage for org.apache.poi.ss.usermodel Cell setCellValue

List of usage examples for org.apache.poi.ss.usermodel Cell setCellValue

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Cell
  6. setCellValue

Introduction

In this page you can find the example usage for org.apache.poi.ss.usermodel Cell setCellValue.

Prototype

void setCellValue(boolean value);

Source Link

Document

Set a boolean value for the cell

Usage

From source file:com.dawg6.web.dhcalc.server.ExportExcel.java

License:Open Source License

private Cell createInputHeader(Sheet sheet, String label) {
    Row row = sheet.createRow(sheet.getPhysicalNumberOfRows());
    Cell cell1 = row.createCell(0);
    cell1.setCellValue(label);
    cell1.setCellStyle(boldStyle);/*w w  w  . j  a  va2s. co  m*/

    return cell1;
}

From source file:com.dawg6.web.dhcalc.server.ExportExcel.java

License:Open Source License

private Cell createInput(Sheet sheet, double value, String label, HSSFCellStyle style) {
    Cell cell = createInputCell(sheet, label);
    cell.setCellValue(value);
    cell.setCellStyle(style);/*w w w  .  j  a va  2 s . co m*/

    return cell;
}

From source file:com.dawg6.web.dhcalc.server.ExportExcel.java

License:Open Source License

private Cell createInput(Sheet sheet, boolean value, String label) {
    Cell cell = createInputCell(sheet, label);
    cell.setCellValue(value);

    return cell;//from  ww w  .  j  a v  a 2 s  .c  o m
}

From source file:com.dawg6.web.dhcalc.server.ExportExcel.java

License:Open Source License

private Cell createInput(Sheet sheet, int value, String label) {
    Cell cell = createInputCell(sheet, label);
    cell.setCellValue(value);
    cell.setCellStyle(intStyle);//  w ww . j  ava 2  s .co  m

    return cell;
}

From source file:com.dawg6.web.dhcalc.server.ExportExcel.java

License:Open Source License

private Cell createInput(Sheet sheet, String text, String label) {
    Cell cell = createInputCell(sheet, label);
    cell.setCellValue(text);

    return cell;/*from ww  w.ja va 2s.  c o  m*/
}

From source file:com.dawg6.web.dhcalc.server.ExportExcel.java

License:Open Source License

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);/*  w w w  .  j a  va 2  s .  c o m*/
    CellUtil.setAlignment(cell2, sheet.getWorkbook(), CellStyle.ALIGN_RIGHT);

    inputCells.put(label, cell2);

    return cell2;
}

From source file:com.dbumama.market.web.core.render.excel.PoiExporter.java

License:Apache License

public Workbook export() {
    Preconditions.checkNotNull(data, "data can not be null");
    Preconditions.checkNotNull(headers, "headers can not be null");
    Preconditions.checkNotNull(columns, "columns can not be null");
    Preconditions.checkArgument(//from   w  w  w.j  a  va2s .com
            data.length == sheetNames.length && sheetNames.length == headers.length
                    && headers.length == columns.length,
            "data,sheetNames,headers and columns'length should be the same." + "(data:" + data.length
                    + ",sheetNames:" + sheetNames.length + ",headers:" + headers.length + ",columns:"
                    + columns.length + ")");
    Preconditions.checkArgument(cellWidth >= 0, "cellWidth can not be less than 0");
    Workbook wb;
    if (VERSION_2003.equals(version)) {
        wb = new HSSFWorkbook();
        if (data.length > 1) {
            for (int i = 0; i < data.length; i++) {
                List<?> item = data[i];
                Preconditions.checkArgument(item.size() < MAX_ROWS,
                        "Data [" + i + "] is invalid:invalid data size (" + item.size()
                                + ") outside allowable range (0..65535)");
            }
        } else if (data.length == 1 && data[0].size() > MAX_ROWS) {
            data = dice(data[0], MAX_ROWS).toArray(new List<?>[] {});
            String sheetName = sheetNames[0];
            sheetNames = new String[data.length];
            for (int i = 0; i < data.length; i++) {
                sheetNames[i] = sheetName + (i == 0 ? "" : (i + 1));
            }
            String[] header = headers[0];
            headers = new String[data.length][];
            for (int i = 0; i < data.length; i++) {
                headers[i] = header;
            }
            String[] column = columns[0];
            columns = new String[data.length][];
            for (int i = 0; i < data.length; i++) {
                columns[i] = column;
            }
        }
    } else {
        wb = new XSSFWorkbook();
    }
    if (data.length == 0) {
        return wb;
    }
    for (int i = 0; i < data.length; i++) {
        Sheet sheet = wb.createSheet(sheetNames[i]);
        Row row;
        Cell cell;
        if (headers[i].length > 0) {
            row = sheet.createRow(0);
            if (headerRow <= 0) {
                headerRow = HEADER_ROW;
            }
            headerRow = Math.min(headerRow, MAX_ROWS);
            for (int h = 0, lenH = headers[i].length; h < lenH; h++) {
                if (cellWidth > 0) {
                    sheet.setColumnWidth(h, cellWidth);
                }
                cell = row.createCell(h);
                cell.setCellValue(headers[i][h]);
            }
        }

        for (int j = 0, len = data[i].size(); j < len; j++) {
            row = sheet.createRow(j + headerRow);
            Object obj = data[i].get(j);
            if (obj == null) {
                continue;
            }
            if (obj instanceof Map) {
                processAsMap(columns[i], row, obj);
            } else if (obj instanceof Model) {
                processAsModel(columns[i], row, obj);
            } else if (obj instanceof Record) {
                processAsRecord(columns[i], row, obj);
            } else {
                throw new RuntimeException("Not support type[" + obj.getClass() + "]");
            }
        }
    }
    return wb;
}

From source file:com.dbumama.market.web.core.render.excel.PoiExporter.java

License:Apache License

@SuppressWarnings("unchecked")
private static void processAsMap(String[] columns, Row row, Object obj) {
    Cell cell;
    Map<String, Object> map = (Map<String, Object>) obj;
    if (columns.length == 0) { // show all if column not specified
        Set<String> keys = map.keySet();
        int columnIndex = 0;
        for (String key : keys) {
            cell = row.createCell(columnIndex);
            cell.setCellValue(map.get(key) + "");
            columnIndex++;/*from  w w w  .  j  ava  2 s  .  c o m*/
        }
    } else {
        for (int j = 0, len = columns.length; j < len; j++) {
            cell = row.createCell(j);
            cell.setCellValue(map.get(columns[j]) == null ? "" : map.get(columns[j]) + "");
        }
    }
}

From source file:com.dbumama.market.web.core.render.excel.PoiExporter.java

License:Apache License

private static void processAsModel(String[] columns, Row row, Object obj) {
    Cell cell;
    Model<?> model = (Model<?>) obj;
    Set<Entry<String, Object>> entries = model._getAttrsEntrySet();
    if (columns.length == 0) { // show all if column not specified
        int columnIndex = 0;
        for (Entry<String, Object> entry : entries) {
            cell = row.createCell(columnIndex);
            cell.setCellValue(entry.getValue() + "");
            columnIndex++;// w  ww  .j ava2  s . co m
        }
    } else {
        for (int j = 0, len = columns.length; j < len; j++) {
            cell = row.createCell(j);
            cell.setCellValue(model.get(columns[j]) == null ? "" : model.get(columns[j]) + "");
        }
    }
}

From source file:com.dbumama.market.web.core.render.excel.PoiExporter.java

License:Apache License

private static void processAsRecord(String[] columns, Row row, Object obj) {
    Cell cell;
    Record record = (Record) obj;//ww w . j a v a 2s . c o  m
    Map<String, Object> map = record.getColumns();
    if (columns.length == 0) { // show all if column not specified
        record.getColumns();
        Set<String> keys = map.keySet();
        int columnIndex = 0;
        for (String key : keys) {
            cell = row.createCell(columnIndex);
            cell.setCellValue(record.get(key) + "");
            columnIndex++;
        }
    } else {
        for (int j = 0, len = columns.length; j < len; j++) {
            cell = row.createCell(j);
            cell.setCellValue(map.get(columns[j]) == null ? "" : map.get(columns[j]) + "");
        }
    }
}