List of createCell() Examples

Examples of createCell()

org.apache.poi.hssf.usermodel.HSSFRow.createCell()
@deprecated (Aug 2008) use {@link HSSFRow#createCell(int) }
org.apache.poi.ss.usermodel.Row.createCell()
Use this to create new cells within the row and return it.
The cell that is returned is a {@link Cell#CELL_TYPE_BLANK}. The type can be changed either through calling setCellValue or setCellType. @param column - the column number this cell represents @return Cell a high level representation of the created cell. @throws IllegalArgumentException if columnIndex < 0 or greater than the maximum number of supported columns(255 for *.xls, 1048576 for *.xlsx)
org.apache.poi.xssf.usermodel.XSSFRow.createCell()
Use this to create new cells within the row and return it.
The cell that is returned is a {@link Cell#CELL_TYPE_BLANK}. The type can be changed either through calling setCellValue or setCellType.
@param columnIndex - the column number this cell represents @return Cell a high level representation of the created cell. @throws IllegalArgumentException if columnIndex < 0 or greater than 16384,the maximum number of columns supported by the SpreadsheetML format (.xlsx)
org.apache.poi.xwpf.usermodel.XWPFTableRow.createCell()
org.zkoss.poi.hssf.usermodel.HSSFRow.createCell()
org.zkoss.poi.ss.usermodel.Row.createCell()
org.zkoss.poi.xssf.usermodel.XSSFRow.createCell()
pt.ist.fenixWebFramework.renderers.components.HtmlTableRow.createCell()

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

                currentExcelGroupSum.setToRow((short) (l - 1));
                formulaCells.add(currentExcelGroupSum);
              }
              if (groupResultColumn != null) {
                currentExcelGroupSum = new ExcelGroupSum(
                    (short) l, row
                        .createCell(groupResultColumn
                            .shortValue()),
                    groupSumColumn.shortValue(),
                    dayColorIndex, wb.createCellStyle());
              }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

      setLabelInfo(labelInfo, infoString, j);
      row = excelSheet.createRow((short) l);
      l++;
      // dersom det skal skrives ut rad nummer
      if (writeRowNumber) {
        cell = row.createCell((short) (startCell - 1));
        cell.setCellValue(rowNumber);
      }
      // g�r gjennom alle kolonner for rad
      for (k = startCell; k < columnCount + startCell; k++) {
        // dersom kolonne skal v�re synlig

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

        // dersom kolonne skal v�re synlig
        if (notVisibleColumns == null
            || !notVisibleColumns.contains(k - startCell)) {
          setColumnSize(colSize, excelSheet, startCell, addedColumn,
              k);
          cell = row.createCell((short) k);
          // dersom celle har verdi
          if (table.getValueAt(j - currentRow, k - startCell) != null) {
            // dersom det er grupperingssum satt og den er ulik
            // forrige
            if (groupSumValueColumn != null

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

              }
              if (groupResultColumn != null
                  && groupSumColumn != null) {
                currentExcelGroupSum = new ExcelGroupSum(
                    (short) l,
                    row
                        .createCell((short) (groupResultColumn
                            .shortValue() + addedColumn)),
                    groupSumColumn.shortValue(),
                    DayEnum.getDayColorIndex(groupSumValue),
                    wb.createCellStyle());

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

         * sumFormula.getInfoText()); } }
         */


        if (sumColumns.contains(Integer.valueOf(i))) {
          createCell(row, cellStyle.getHeadingStyle(), (short) i, "");
          cell = row.createCell((short) (i + startCell));
          String columnLetter = getColLetter(i + startCell);
          ignoreCell = i + startCell;


          cell.setCellFormula("sum(" + columnLetter
              + sumFormula.getFromRow() + ":" + columnLetter

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

          }
        }
      }


      if (sumFormula.getSumLineFormulaColumn() != null) {
        cell = row.createCell(sumFormula.getSumLineFormulaColumn()
            .shortValue());
        cell.setCellFormula(sumFormula.getSumLineFormula());
        cell.setCellStyle(cellStyle.getHeadingStyle());
      }
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

    // 创建第1行，也就是输出表头
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;
    for (int i = 0; i < columnNames.length; i++)
    {
      cell = row.createCell(i);
      cell.setCellValue(new HSSFRichTextString(columnNames[i]));
    }
    // 下面是输出各行的数据
    for (int i = 0; i < list.size(); i++)
    {

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

    {
      row = sheet.createRow(i + 1);
      Object o = list.get(i);
      for (int j = 0; j < columnPropterties.length; j++)
      {
        cell = row.createCell(j);
        Object obj = ReflectionUtils.invokeGetterMethod(o, columnPropterties[j]);
        cell.setCellValue(obj == null ? "" : obj.toString());
      }
    }
    return workbook;

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

    // 创建第1行，也就是输出表头
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;
    for (int i = 0; i < columnNames.length; i++)
    {
      cell = row.createCell(i);
      cell.setCellValue(new HSSFRichTextString(columnNames[i]));
    }
    // 下面是输出各行的数据
    for (int i = 0; i < list.size(); i++)
    {

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFRow.createCell()

    {
      row = sheet.createRow(i + 1);
      Object o = list.get(i);
      for (int j = 0; j < columnPropterties.length; j++)
      {
        cell = row.createCell(j);
        Object obj = ReflectionUtils.invokeGetterMethod(o, columnPropterties[j]);
        cell.setCellValue(obj == null ? "" : obj.toString());
      }
    }
    wb.write(out);

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.