Package org.apache.poi.hssf.record

Examples of org.apache.poi.hssf.record.CellValueRecordInterface

156
157
158
159
160
161
162
163
164
165
166
     * remove the HSSFCell from this row.
     * @param cell to remove
     */
    public void removeCell(HSSFCell cell)
    {
        CellValueRecordInterface cval = cell.getCellValueRecord();

        sheet.removeValueRecord(getRowNum(), cval);
        short column=cell.getCellNum();
        if(cell!=null && column<cells.length)
        {
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
        }

        cells[column]=null;

        if(alsoRemoveRecords) {
            CellValueRecordInterface cval = cell.getCellValueRecord();
            sheet.getSheet().removeValueRecord(getRowNum(), cval);
        }
        if (cell.getColumnIndex()+1 == row.getLastCol()) {
            row.setLastCol(calculateNewLastCellPlusOne(row.getLastCol()));
        }
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
            if (currentSheet == null) {
                // Ignore cells outside sheets
            } else if (cell == null) {
                // Ignore empty cells
            } else if (record instanceof CellValueRecordInterface) {
                CellValueRecordInterface value =
                    (CellValueRecordInterface) record;
                Point point = new Point(value.getColumn(), value.getRow());
                currentSheet.put(point, cell);
            }
        }
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
            throw new RuntimeException("Specified cell is not from this row");
        }
        cells[column]=null;
       
        if(alsoRemoveRecords) {
            CellValueRecordInterface cval = cell.getCellValueRecord();
            sheet.removeValueRecord(getRowNum(), cval);
        }
       
        if (cell.getCellNum()+1 == row.getLastCol()) {
            row.setLastCol((short) (findLastCell(row.getLastCol())+1));
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
            createRowFromRecord(row);

            row = sheet.getNextRow();
        }
        sheet.setLoc(sloc);
        CellValueRecordInterface cval = sheet.getNextValueRecord();
        long timestart = System.currentTimeMillis();

        if (log.check( POILogger.DEBUG ))
            log.log(DEBUG, "Time at start of cell creating in HSSF sheet = ",
                new Long(timestart));
        HSSFRow lastrow = null;

        while (cval != null)
        {
            long cellstart = System.currentTimeMillis();
            HSSFRow hrow = lastrow;

            if ( ( lastrow == null ) || ( lastrow.getRowNum() != cval.getRow() ) )
            {
                hrow = getRow( cval.getRow() );
                if (hrow == null) {
                    // Some tools (like Perl module Spreadsheet::WriteExcel - bug 41187) skip the RowRecords
                    // Excel, OpenOffice.org and GoogleDocs are all OK with this, so POI should be too.
                    if (rowRecordsAlreadyPresent) {
                        // if at least one row record is present, all should be present.
                        throw new RuntimeException("Unexpected missing row when some rows already present");
                    }
                    // create the row record on the fly now.
                    RowRecord rowRec = new RowRecord(cval.getRow());
                    sheet.addRow(rowRec);
                    hrow = createRowFromRecord(rowRec);
                }
            }
            if ( hrow != null )
View Full Code Here
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
            // Copy each cell from the source row to
            //  the destination row
            for(Iterator cells = row.cellIterator(); cells.hasNext(); ) {
              cell = (HSSFCell)cells.next();
                row.removeCell( cell );
                CellValueRecordInterface cellRecord = cell.getCellValueRecord();
                cellRecord.setRow( rowNum + n );
                row2Replace.createCellFromRecord( cellRecord );
                sheet.addValueRecord( rowNum + n, cellRecord );
            }
            // Now zap all the cells in the source row
            row.removeAllCells();
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
  public void testTurnToString() throws Exception {
    processFile("45365.xls");
   
    for(int i=0; i<mockListen._records.size(); i++) {
      Record r = (Record)mockListen._records.get(i);
      CellValueRecordInterface cvr = null;
     
      if(r instanceof NumberRecord) {
        cvr = (CellValueRecordInterface)r;
      }
      if(r instanceof FormulaRecord) {
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
  private FormulaExtractor() {
    // no instances of this class
  }
 
  public static Ptg[] getPtgs(HSSFCell cell) {
    CellValueRecordInterface vr = cell.getCellValueRecord();
    if (!(vr instanceof FormulaRecordAggregate)) {
      throw new IllegalArgumentException("Not a formula cell");
    }
    FormulaRecordAggregate fra = (FormulaRecordAggregate) vr;
    List tokens = fra.getFormulaRecord().getParsedExpression();
View Full Code Here
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
      assertEquals("90210", nc3.getRichStringCellValue().getString());
     
      // Now check record level stuff too
      ns.getSheet().setLoc(0);
      int fn = 0;
      CellValueRecordInterface cvr;
      while((cvr = ns.getSheet().getNextValueRecord()) != null) {
        if(cvr instanceof FormulaRecordAggregate) {
          FormulaRecordAggregate fr = (FormulaRecordAggregate)cvr;
         
          if(fn == 0) {
View Full Code Here
450
451
452
453
454
455
456
457
458
459
460
461
462
            if (cell == null) {
                // Ignore empty cells
            } else if (currentSheet != null
                    && record instanceof CellValueRecordInterface) {
                // Normal cell inside a worksheet
                CellValueRecordInterface value =
                    (CellValueRecordInterface) record;
                Point point = new Point(value.getColumn(), value.getRow());
                currentSheet.put(point, cell);
            } else {
                // Cell outside the worksheets
                extraTextCells.add(cell);
            }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.CellValueRecordInterface

  • org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener
  • org.apache.poi.hssf.eventusermodel.TestFormatTrackingHSSFListener
  • org.apache.poi.hssf.model.TestSheet
  • org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate$ValueIterator
  • org.apache.poi.hssf.usermodel.FormulaExtractor
  • org.apache.poi.hssf.usermodel.HSSFRow
  • org.apache.poi.hssf.usermodel.HSSFSheet
  • org.apache.poi.hssf.usermodel.TestBugs
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.