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

org.apache.poi.hssf.record.RecordBase
Common base class of {@link Record} and {@link org.apache.poi.hssf.record.aggregates.RecordAggregate} @author Josh Micich

    final List<RecordBase> records = sheet.getSheet().getRecords();
    
    /* store first series as template and find last series index */
    Iterator<RecordBase> iter = records.iterator();
    while (iter.hasNext()) {    
      RecordBase record = iter.next();
      idx++;
      
      if (record instanceof BeginRecord) {
        deep++;
      } else if (record instanceof EndRecord) {

View Full Code Here

     * belongs to a sheet.
     */
    public InternalSheet cloneSheet() {
        List<RecordBase> clonedRecords = new ArrayList<RecordBase>(_records.size());
        for (int i = 0; i < _records.size(); i++) {
            RecordBase rb = _records.get(i);
            if (rb instanceof RecordAggregate) {
                ((RecordAggregate) rb).visitContainedRecords(new RecordCloner(clonedRecords));
                continue;
            }
            Record rec = (Record) ((Record) rb).clone();

View Full Code Here

        PositionTrackingVisitor ptv = new PositionTrackingVisitor(rv, offset);


        boolean haveSerializedIndex = false;


        for (int k = 0; k < _records.size(); k++) {
            RecordBase record = _records.get(k);


            if (record instanceof RecordAggregate) {
                RecordAggregate agg = (RecordAggregate) record;
                agg.visitContainedRecords(ptv);
            } else {

View Full Code Here

    private int getSizeOfInitialSheetRecords(int bofRecordIndex) {


        int result = 0;
        // start just after BOF record (INDEX is not present in this list)
        for (int j = bofRecordIndex + 1; j < _records.size(); j++) {
            RecordBase tmpRec = _records.get(j);
            if (tmpRec instanceof RowRecordsAggregate) {
                break;
            }
            result += tmpRec.getRecordSize();
        }
        if (_isUncalced) {
            result += UncalcedRecord.getStaticRecordSize();
        }
        return result;

View Full Code Here

     * @return never <code>null</code>, typically empty array
     */
    public NoteRecord[] getNoteRecords() {
        List<NoteRecord> temp = new ArrayList<NoteRecord>();
        for(int i=_records.size()-1; i>=0; i--) {
            RecordBase rec = _records.get(i);
            if (rec instanceof NoteRecord) {
                temp.add((NoteRecord) rec);
            }
        }
        if (temp.size() < 1) {

View Full Code Here

    if (!(records.get(i) instanceof EOFRecord)) {
      throw new IllegalStateException("Last sheet record should be EOFRecord");
    }
    while (i > 0) {
      i--;
      RecordBase rb = records.get(i);
      if (isDVTPriorRecord(rb)) {
        Record nextRec = (Record) records.get(i + 1);
        if (!isDVTSubsequentRecord(nextRec.getSid())) {
          throw new IllegalStateException("Unexpected (" + nextRec.getClass().getName()
              + ") found after (" + rb.getClass().getName() + ")");
        }
        return i+1;
      }
      Record rec = (Record) rb;
      if (!isDVTSubsequentRecord(rec.getSid())) {

View Full Code Here

  private static int getGutsRecordInsertPos(List<RecordBase> records) {
    int dimensionsIndex = getDimensionsIndex(records);
    int i = dimensionsIndex-1;
    while (i > 0) {
      i--;
      RecordBase rb = records.get(i);
      if (isGutsPriorRecord(rb)) {
        return i+1;
      }
    }
    throw new RuntimeException("Did not find insert point for GUTS");

View Full Code Here

        HSSFComment comment = null;
        Map<Integer, TextObjectRecord> noteTxo =
                               new HashMap<Integer, TextObjectRecord>();
        int i = 0;
        for (Iterator<RecordBase> it = sheet.getRecords().iterator(); it.hasNext();) {
            RecordBase rec = it.next();
            if (rec instanceof NoteRecord) {
                NoteRecord note = (NoteRecord) rec;
                if (note.getRow() == row && note.getColumn() == column) {
                    if(i < noteTxo.size()) {
                        TextObjectRecord txo = noteTxo.get(note.getShapeId());

View Full Code Here

    /**
     * @return hyperlink associated with this cell or <code>null</code> if not found
     */
    public HSSFHyperlink getHyperlink(){
        for (Iterator<RecordBase> it = _sheet.getSheet().getRecords().iterator(); it.hasNext(); ) {
            RecordBase rec = it.next();
            if (rec instanceof HyperlinkRecord){
                HyperlinkRecord link = (HyperlinkRecord)rec;
                if(link.getFirstColumn() == _record.getColumn() && link.getFirstRow() == _record.getRow()){
                    return new HSSFHyperlink(link);
                }

View Full Code Here

     */
    protected static HSSFComment findCellComment(Sheet sheet, int row, int column){
        HSSFComment comment = null;
        HashMap txshapes = new HashMap(); //map shapeId and TextObjectRecord
        for (Iterator it = sheet.getRecords().iterator(); it.hasNext(); ) {
           RecordBase rec = (RecordBase) it.next();
           if (rec instanceof NoteRecord){
               NoteRecord note = (NoteRecord)rec;
               if (note.getRow() == row && note.getColumn() == column){
                   TextObjectRecord txo = (TextObjectRecord)txshapes.get(new Integer(note.getShapeId()));
                   comment = new HSSFComment(note, txo);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.apache.poi.hssf.model.InternalSheet

org.apache.poi.hssf.model.RecordOrderer

org.apache.poi.hssf.model.Sheet

org.apache.poi.hssf.model.TestDrawingAggregate

org.apache.poi.hssf.model.TestDrawingAggregate$DrawingAggregateInfo

org.apache.poi.hssf.record.aggregates.ChartSubstreamRecordAggregate

org.apache.poi.hssf.record.aggregates.CustomViewSettingsRecordAggregate

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

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

org.apache.poi.hssf.usermodel.HSSFCell

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.