Package org.apache.poi.hssf.record

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

235
236
237
238
239
240
241
242
243
244
245
246
          throw new IllegalStateException("No SST record found");
        }
        thisText = sstRecord.getString(lsrec.getSSTIndex()).toString();
        break;
      case NoteRecord.sid:
        NoteRecord nrec = (NoteRecord) record;
        thisRow = nrec.getRow();
        // TODO: Find object to match nrec.getShapeId()
        break;
      case NumberRecord.sid:
        NumberRecord numrec = (NumberRecord) record;
        thisRow = numrec.getRow();
View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
246
247
248
      } else {
        thisStr = '"' + sstRecord.getString(lsrec.getSSTIndex()).toString() + '"';
      }
      break;
    case NoteRecord.sid:
      NoteRecord nrec = (NoteRecord) record;

      thisRow = nrec.getRow();
      thisColumn = nrec.getColumn();
      // TODO: Find object to match nrec.getShapeId()
      thisStr = '"' + "(TODO)" + '"';
      break;
    case NumberRecord.sid:
      NumberRecord numrec = (NumberRecord) record;
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
                   throw new IllegalStateException("No SST record found");
               }
               thisText = sstRecord.getString(lsrec.getSSTIndex()).toString();
               break;
           case NoteRecord.sid:
               NoteRecord nrec = (NoteRecord) record;
               thisRow = nrec.getRow();
               // TODO: Find object to match nrec.getShapeId()
               break;
           case NumberRecord.sid:
               NumberRecord numrec = (NumberRecord) record;
               thisRow = numrec.getRow();
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
139
140
          // Exand this out into multiple regular number cells
          MulRKRecord mrk = (MulRKRecord)record;
          expandedRecords = RecordFactory.convertRKRecords(mrk);
          break;
        case NoteRecord.sid:
          NoteRecord nrec = (NoteRecord) record;
          thisRow = nrec.getRow();
          thisColumn = nrec.getColumn();
          break;
      }
    }

    // First part of expanded record handling
View Full Code Here
118
119
120
121
122
123
124
125
126
127
        obj.addSubRecord(e);
        return obj;
    }

    private NoteRecord createNoteRecord(){
        NoteRecord note = new NoteRecord();
        note.setFlags(NoteRecord.NOTE_HIDDEN);
        note.setAuthor("");
        return note;
    }
View Full Code Here
246
247
248
249
250
251
252
253
        TextObjectRecord txo = (TextObjectRecord) getTextObjectRecord().cloneViaReserialise();
        EscherContainerRecord spContainer = new EscherContainerRecord();
        byte [] inSp = getEscherContainer().serialize();
        spContainer.fillFields(inSp, 0, new DefaultEscherRecordFactory());
        ObjRecord obj = (ObjRecord) getObjRecord().cloneViaReserialise();
        NoteRecord note = (NoteRecord) getNoteRecord().cloneViaReserialise();
        return new HSSFComment(spContainer, obj, txo, note);
    }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
145
146
                thisColumn = lsrec.getColumn();
                //System.out.println("Cell found containing String "
                //        + " at row " + lsrec.getRow() + " and column " + lsrec.getColumn());
                break;
            case NoteRecord.sid:
              NoteRecord nrec = (NoteRecord) record;
              thisRow = nrec.getRow();
              thisColumn = nrec.getColumn();
                break;
            case NumberRecord.sid:
                NumberRecord numrec = (NumberRecord) record;
                thisRow = numrec.getRow();
                thisColumn = numrec.getColumn();
View Full Code Here
209
210
211
212
213
214
215
216
217
218
219
220
                throw new IllegalStateException("No SST record found");
              }
              thisText = sstRecord.getString(lsrec.getSSTIndex()).toString();
              break;
          case NoteRecord.sid:
            NoteRecord nrec = (NoteRecord) record;
            thisRow = nrec.getRow();
            // TODO: Find object to match nrec.getShapeId()
              break;
          case NumberRecord.sid:
              NumberRecord numrec = (NumberRecord) record;
              thisRow = numrec.getRow();
View Full Code Here
192
193
194
195
196
197
198
199
200
201
202
203
204
205
            } else {
              thisStr = '"' + sstRecord.getString(lsrec.getSSTIndex()).toString() + '"';
            }
            break;
        case NoteRecord.sid:
          NoteRecord nrec = (NoteRecord) record;
         
          thisRow = nrec.getRow();
          thisColumn = nrec.getColumn();
          // TODO: Find object to match nrec.getShapeId()
          thisStr = '"' + "(TODO)" + '"';
            break;
        case NumberRecord.sid:
            NumberRecord numrec = (NumberRecord) record;
View Full Code Here
743
744
745
746
747
748
749
750
751
752
753
        DrawingRecord d2 = new DrawingRecord();
        d2.setData( HexRead.readFromString( msoDrawingRecord2 ) );

        TextObjectRecord r2 = new TextObjectRecord();
        r2.setStr(new HSSFRichTextString("Aggregated"));
        NoteRecord n2 = new NoteRecord();

        List<Record> recordStream = new ArrayList<Record>();
        recordStream.add(InternalSheet.createBOF());
        recordStream.add( d1 );
        recordStream.add( r1 );
View Full Code Here
TOP

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

  • com.common.platform.excel.parser.HSSFParser
  • evolaris.framework.sys.business.XLS2CSVmra
  • org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra
  • org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener
  • org.apache.poi.hssf.extractor.EventBasedExcelExtractor$TextListener
  • org.apache.poi.hssf.model.CommentShape
  • org.apache.poi.hssf.model.TestSheet
  • org.apache.poi.hssf.usermodel.HSSFCell
  • org.apache.poi.hssf.usermodel.HSSFComment
  • org.apache.poi.hssf.usermodel.HSSFSheet
    • 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.