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

org.apache.poi.hssf.record.BlankRecord
Title: Blank cell record
Description: Represents a column in a row with no value but with styling.
REFERENCE: PG 287 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver (acoliver at apache dot org) @author Jason Height (jheight at chariot dot net dot au) @version 2.0-pre

    return lastcell;
  }


  public void addMultipleBlanks(MulBlankRecord mbr) {
    for (int j = 0; j < mbr.getNumColumns(); j++) {
      BlankRecord br = new BlankRecord();


      br.setColumn(( short ) (j + mbr.getFirstColumn()));
      br.setRow(mbr.getRow());
      br.setXFIndex(mbr.getXFAt(j));
      insertCell(br);
    }
  }

View Full Code Here

        HSSFSheet sheet = workbook.createSheet("Sheet1");
        RowRecord rowRec = new RowRecord(ROW_IX);
        rowRec.setFirstCol((short)2);
        rowRec.setLastCol((short)5);


        BlankRecord br = new BlankRecord();
        br.setRow(ROW_IX);
    br.setColumn((short)COL_IX);


        sheet.getSheet().addValueRecord(ROW_IX, br);
        HSSFRow row = new HSSFRow(workbook, sheet, rowRec);
        HSSFCell cell = row.createCellFromRecord(br);

View Full Code Here

                }
                _record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != _cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) _record;
                }
                brec.setColumn(col);


                // During construction the cellStyle may be null for a Blank cell.
                brec.setXFIndex(styleIndex);
                brec.setRow(row);
                _record = brec;
                break;


            case CELL_TYPE_BOOLEAN :
                BoolErrRecord boolRec = null;

View Full Code Here

    case SSTRecord.sid:
      sstRecord = (SSTRecord) record;
      break;
      
        case BlankRecord.sid:
          BlankRecord brec = (BlankRecord) record;
          
            thisRow = brec.getRow();
            thisColumn = brec.getColumn();
            thisStr = "";
            break;
        case BoolErrRecord.sid:
          BoolErrRecord berec = (BoolErrRecord) record;

View Full Code Here

                
                
            // These are all the "cell" records
                
            case BlankRecord.sid:
              BlankRecord brec = (BlankRecord) record;
                thisRow = brec.getRow();
                thisColumn = brec.getColumn();
                break;
            case BoolErrRecord.sid:
              BoolErrRecord berec = (BoolErrRecord) record;
                thisRow = berec.getRow();
                thisColumn = berec.getColumn();

View Full Code Here

    InternalSheet sheet = InternalSheet.createSheet();


    RowRecord rr = new RowRecord(5);
    sheet.addRow(rr);


    CellValueRecordInterface cvr = new BlankRecord();
    cvr.setColumn((short)0);
    cvr.setRow(5);
    sheet.addValueRecord(5, cvr);




    int dbCellRecordPos = getDbCellRecordPos(sheet);
    if (dbCellRecordPos == 252) {

View Full Code Here

                }
                _record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != _cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) _record;
                }
                brec.setColumn(col);


                // During construction the cellStyle may be null for a Blank cell.
                brec.setXFIndex(styleIndex);
                brec.setRow(row);
                _record = brec;
                break;


            case CELL_TYPE_BOOLEAN :
                BoolErrRecord boolRec = null;

View Full Code Here

    return lastcell;
  }


  public void addMultipleBlanks(MulBlankRecord mbr) {
    for (int j = 0; j < mbr.getNumColumns(); j++) {
      BlankRecord br = new BlankRecord();


      br.setColumn(( short ) (j + mbr.getFirstColumn()));
      br.setRow(mbr.getRow());
      br.setXFIndex(mbr.getXFAt(j));
      insertCell(br);
    }
  }

View Full Code Here

  }


  private static List<Record> testData() {
    List<Record> records = new ArrayList<Record>();
    FormulaRecord formulaRecord = new FormulaRecord();
    BlankRecord blankRecord = new BlankRecord();
    formulaRecord.setRow(1);
    formulaRecord.setColumn((short) 1);
    blankRecord.setRow(2);
    blankRecord.setColumn((short) 2);
    records.add(formulaRecord);
    records.add(blankRecord);
    records.add(new WindowTwoRecord());
    return records;
  }

View Full Code Here


  public void testInsertCell() {
    CellValueRecordInterface[] cvrs = valueRecord.getValueRecords();
    assertEquals(0, cvrs.length);


    BlankRecord blankRecord = newBlankRecord();
    valueRecord.insertCell( blankRecord );
    cvrs = valueRecord.getValueRecords();
    assertEquals(1, cvrs.length);
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

com.common.platform.excel.parser.HSSFParser

evolaris.framework.sys.business.XLS2CSVmra

org.apache.poi.hssf.eventmodel.EventRecordFactory

org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra

org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener

org.apache.poi.hssf.model.TestSheet

org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate

org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate

org.apache.poi.hssf.usermodel.HSSFCell

org.apache.poi.hssf.usermodel.TestHSSFRow

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.