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()

    CellRangeAddress titleRange = new CellRangeAddress(0, 0, 0, 
        setInfo.getFieldNames().get(sheetNum).length);
    sheets[sheetNum].addMergedRegion(titleRange);
    HSSFRow titleRow = sheets[sheetNum].createRow(0);
    titleRow.setHeight((short) 800);
    HSSFCell titleCell = titleRow.createCell(0);
    titleCell.setCellStyle(titleStyle);
    titleCell.setCellValue(setInfo.getTitles()[sheetNum]);
  }


  /**

View Full Code Here

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

    CellRangeAddress dateRange = new CellRangeAddress(1, 1, 0, 
        setInfo.getFieldNames().get(sheetNum).length);
    sheets[sheetNum].addMergedRegion(dateRange);
    HSSFRow dateRow = sheets[sheetNum].createRow(1);
    dateRow.setHeight((short) 350);
    HSSFCell dateCell = dateRow.createCell(0);
    dateCell.setCellStyle(dateStyle);
    dateCell.setCellValue(new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
  }


  /**

View Full Code Here

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

  {
    // 表头
    HSSFRow headRow = sheets[sheetNum].createRow(2);
    headRow.setHeight((short) 350);
    // 序号列
    HSSFCell snCell = headRow.createCell(0);
    snCell.setCellStyle(headStyle);
    snCell.setCellValue("序号");
    // 列头名称
    for(int num = 1, len = setInfo.getHeadNames().get(sheetNum).length; num <= len; num++)
    {

View Full Code Here

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

    snCell.setCellStyle(headStyle);
    snCell.setCellValue("序号");
    // 列头名称
    for(int num = 1, len = setInfo.getHeadNames().get(sheetNum).length; num <= len; num++)
    {
      HSSFCell headCell = headRow.createCell(num);
      headCell.setCellStyle(headStyle);
      headCell.setCellValue(setInfo.getHeadNames().get(sheetNum)[num - 1]);
    }
  }

View Full Code Here

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

      
      HSSFSheet sheet = wb.createSheet("Test");
      HSSFRow row = sheet.createRow(0);
      HSSFCell cell;
      
      cell = row.createCell((short)0);
      cell.setCellFormula("NoQuotesNeeded!A1");
      
      cell = row.createCell((short)1);
      cell.setCellFormula("'Quotes Needed Here &#$@'!A1");
    }

View Full Code Here

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

      HSSFCell cell;
      
      cell = row.createCell((short)0);
      cell.setCellFormula("NoQuotesNeeded!A1");
      
      cell = row.createCell((short)1);
      cell.setCellFormula("'Quotes Needed Here &#$@'!A1");
    }
    
    public void testUnaryMinus()
    {

View Full Code Here

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

      
      HSSFSheet sheet = wb.createSheet("Test");
      HSSFRow row = sheet.createRow(0);
      HSSFCell cell;
      
      cell = row.createCell((short)0);
      cell.setCellFormula("Cash_Flow!A1");
    
  }


    // bug 38396 : Formula with exponential numbers not parsed correctly.

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Row.createCell()

    final Cell cell = row.getCell(x);
    if (cell != null)
    {
      return cell;
    }
    return row.createCell(x);
  }


  private Row getRowAt(final int y)
  {
    final Row row = sheet.getRow(y);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Row.createCell()

       for(Workbook wb : wbs) {
          Sheet s = wb.createSheet();
          Row r = s.createRow(0);
          
          // Setup
          Cell cn = r.createCell(0, Cell.CELL_TYPE_NUMERIC);
          cn.setCellValue(1.2);
          Cell cs = r.createCell(1, Cell.CELL_TYPE_STRING);
          cs.setCellValue("Testing");
          
          Cell cfn = r.createCell(2, Cell.CELL_TYPE_FORMULA);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Row.createCell()

          Row r = s.createRow(0);
          
          // Setup
          Cell cn = r.createCell(0, Cell.CELL_TYPE_NUMERIC);
          cn.setCellValue(1.2);
          Cell cs = r.createCell(1, Cell.CELL_TYPE_STRING);
          cs.setCellValue("Testing");
          
          Cell cfn = r.createCell(2, Cell.CELL_TYPE_FORMULA);
          cfn.setCellFormula("A1");  
          Cell cfs = r.createCell(3, Cell.CELL_TYPE_FORMULA);

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.