Examples of org.apache.poi.xssf.usermodel.XSSFRow.createCell()

Class org.apache.poi.xssf.usermodel.XSSFRow

Examples of org.apache.poi.xssf.usermodel.XSSFRow.createCell()

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)

                        row = table.getXSSFSheet().createRow(rowId);
                    }


                    XSSFCell cell = row.getCell(columnId);
                    if (cell == null) {
                        cell = row.createCell(columnId);
                    }
                    logger.log(POILogger.DEBUG, "Setting '" + value + "' to cell " + cell.getColumnIndex() + "-" + cell.getRowIndex() + " in sheet "
                                                    + table.getXSSFSheet().getSheetName());
                    cell.setCellValue(value.trim());
                }

View Full Code Here

                        row = table.getXSSFSheet().createRow(rowId);
                    }


                    XSSFCell cell = row.getCell(columnId);
                    if (cell == null) {
                        cell = row.createCell(columnId);
                    }
                    logger.log(POILogger.DEBUG, "Setting '" + value + "' to cell " + cell.getColumnIndex() + "-" + cell.getRowIndex() + " in sheet "
                                                    + table.getXSSFSheet().getSheetName());
                    cell.setCellValue(value.trim());
                }

View Full Code Here

            column.setId(i+1);
            //Create row
            row = sheet.createRow(i);
            for(int j=0; j<3; j++) {
                //Create cell
                cell = row.createCell(j);
                if(i == 0) {
                    cell.setCellValue("Column"+j);
                } else {
                    cell.setCellValue("0");
                }

View Full Code Here

            sVal.setIdx(idx);
            sVal.setV(key);


            idx++;
            XSSFRow row = sheet.createRow(rownum++);
            row.createCell(0).setCellValue(key);
            row.createCell(1).setCellValue(val);
        }
        numData.getPtCount().setVal(idx);
        strData.getPtCount().setVal(idx);

View Full Code Here

            sVal.setV(key);


            idx++;
            XSSFRow row = sheet.createRow(rownum++);
            row.createCell(0).setCellValue(key);
            row.createCell(1).setCellValue(val);
        }
        numData.getPtCount().setVal(idx);
        strData.getPtCount().setVal(idx);


        String numDataRange = new CellRangeAddress(1, rownum-1, 1, 1).formatAsString(sheet.getSheetName(), true);

View Full Code Here

                        row = table.getXSSFSheet().createRow(rowId);
                    }


                    XSSFCell cell = row.getCell(columnId);
                    if (cell == null) {
                        cell = row.createCell(columnId);
                    }
                    logger.log(POILogger.DEBUG, "Setting '" + value + "' to cell " + cell.getColumnIndex() + "-" + cell.getRowIndex() + " in sheet "
                                                    + table.getXSSFSheet().getSheetName());
                    cell.setCellValue(value.trim());
                }

View Full Code Here

            row = table.getXSSFSheet().createRow(rowId);
          }
          
          XSSFCell cell = row.getCell(columnId);
          if(cell==null){
            cell = row.createCell(columnId);
          }
          logger.log(POILogger.DEBUG,"Setting '"+value+"' to cell "+cell.getColumnIndex()+"-"+cell.getRowIndex()+" in sheet "+table.getXSSFSheet().getSheetName());
          cell.setCellValue(value.trim());
          
        }

View Full Code Here

        String sampleId = sampleinwell.split(":")[0];
        String wellId = sampleinwell.split(":")[1];
        String sampleAlias = sampleinwell.split(":")[2];
        String projectName = sampleinwell.split(":")[3];
        XSSFRow row = sheet.createRow(i);
        XSSFCell cellA = row.createCell(0);
        cellA.setCellValue(wellId);
        XSSFCell cellB = row.createCell(1);
        cellB.setCellValue(projectName);
        XSSFCell cellC = row.createCell(2);
        cellC.setCellValue(sampleAlias);

View Full Code Here

        String sampleAlias = sampleinwell.split(":")[2];
        String projectName = sampleinwell.split(":")[3];
        XSSFRow row = sheet.createRow(i);
        XSSFCell cellA = row.createCell(0);
        cellA.setCellValue(wellId);
        XSSFCell cellB = row.createCell(1);
        cellB.setCellValue(projectName);
        XSSFCell cellC = row.createCell(2);
        cellC.setCellValue(sampleAlias);
        i++;
      }

View Full Code Here

        XSSFRow row = sheet.createRow(i);
        XSSFCell cellA = row.createCell(0);
        cellA.setCellValue(wellId);
        XSSFCell cellB = row.createCell(1);
        cellB.setCellValue(projectName);
        XSSFCell cellC = row.createCell(2);
        cellC.setCellValue(sampleAlias);
        i++;
      }
      oDoc.write(fileOut);
      fileOut.close();

View Full Code Here

0 1 2

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.