Examples of LabelSSTRecord

org.apache.poi.hssf.record.LabelSSTRecord
Title: Label SST Record
Description: Refers to a string in the shared string table and is a column value.
REFERENCE: PG 325 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

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

                LabelRecord label = (LabelRecord) record;
                addTextCell(record, label.getValue());
                break;


            case LabelSSTRecord.sid: // Ref. a string in the shared string table
                LabelSSTRecord sst = (LabelSSTRecord) record;
                UnicodeString unicode = sstRecord.getString(sst.getSSTIndex());
                addTextCell(record, unicode.getString());
                break;


            case NumberRecord.sid: // Contains a numeric cell value
                NumberRecord number = (NumberRecord) record;

View Full Code Here

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

        LabelRecord lrec = (LabelRecord) record;
        thisRow = lrec.getRow();
        thisText = lrec.getValue();
        break;
      case LabelSSTRecord.sid:
        LabelSSTRecord lsrec = (LabelSSTRecord) record;
        thisRow = lsrec.getRow();
        if(sstRecord == null) {
          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()

View Full Code Here

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

      thisRow = lrec.getRow();
      thisColumn = lrec.getColumn();
      thisStr = '"' + lrec.getValue() + '"';
      break;
    case LabelSSTRecord.sid:
      LabelSSTRecord lsrec = (LabelSSTRecord) record;


      thisRow = lsrec.getRow();
      thisColumn = lsrec.getColumn();
      if(sstRecord == null) {
        thisStr = '"' + "(No SST Record, can't identify string)" + '"';
      } else {
        thisStr = '"' + sstRecord.getString(lsrec.getSSTIndex()).toString() + '"';
      }
      break;
    case NoteRecord.sid:
      NoteRecord nrec = (NoteRecord) record;

View Full Code Here

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

               LabelRecord lrec = (LabelRecord) record;
               thisRow = lrec.getRow();
               thisText = lrec.getValue();
               break;
           case LabelSSTRecord.sid:
               LabelSSTRecord lsrec = (LabelSSTRecord) record;
               thisRow = lsrec.getRow();
               if(sstRecord == null) {
                   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()

View Full Code Here

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

    
    // Find the cell at 0,0
    int cell00 = -1;
    for(int i=0; i<r.length; i++) {
      if(r[i] instanceof LabelSSTRecord) {
        LabelSSTRecord lr = (LabelSSTRecord)r[i];
        if(lr.getRow() == 0 && lr.getColumn() == 0) { cell00 = i; }
      }
    }
    assertTrue(cell00 > -1);
    
    // We have rows 0, 1, 2, 20 and 21

View Full Code Here

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

    
    // Find the cell at 0,0
    int cell00 = -1;
    for(int i=0; i<r.length; i++) {
      if(r[i] instanceof LabelSSTRecord) {
        LabelSSTRecord lr = (LabelSSTRecord)r[i];
        if(lr.getRow() == 0 && lr.getColumn() == 0) { cell00 = i; }
      }
    }
    assertTrue(cell00 > -1);
    
    // We have rows 0, 1, 2, 20 and 21

View Full Code Here

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

                nrec.setRow(row);
                _record = nrec;
                break;


            case CELL_TYPE_STRING :
                LabelSSTRecord lrec;


                if (cellType == _cellType) {
                    lrec = (LabelSSTRecord) _record;
                } else {
                    lrec = new LabelSSTRecord();
                    lrec.setColumn(col);
                    lrec.setRow(row);
                    lrec.setXFIndex(styleIndex);
                }
                if (setValue) {
                    String str = convertCellValueToString();
                    int sstIndex = _book.getWorkbook().addSSTString(new UnicodeString(str));
                    lrec.setSSTIndex(sstIndex);
                    UnicodeString us = _book.getWorkbook().getSSTString(sstIndex);
                    _stringValue = new HSSFRichTextString();
                    _stringValue.setUnicodeString(us);
                }
                _record = lrec;

View Full Code Here

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

                LabelRecord label = (LabelRecord) record;
                addTextCell(record, label.getValue());
                break;


            case LabelSSTRecord.sid: // Ref. a string in the shared string table
                LabelSSTRecord sst = (LabelSSTRecord) record;
                UnicodeString unicode = sstRecord.getString(sst.getSSTIndex());
                addTextCell(record, unicode.getString());
                break;


            case NumberRecord.sid: // Contains a numeric cell value
                NumberRecord number = (NumberRecord) record;

View Full Code Here

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

                LabelRecord label = (LabelRecord) record;
                addTextCell(record, label.getValue());
                break;


            case LabelSSTRecord.sid: // Ref. a string in the shared string table
                LabelSSTRecord sst = (LabelSSTRecord) record;
                UnicodeString unicode = sstRecord.getString(sst.getSSTIndex());
                addTextCell(record, unicode.getString());
                break;


            case NumberRecord.sid: // Contains a numeric cell value
                NumberRecord number = (NumberRecord) record;

View Full Code Here

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

                thisColumn = lrec.getColumn();
                //System.out.println("Cell found containing String "
                //        + " at row " + lrec.getRow() + " and column " + lrec.getColumn());
                break;
            case LabelSSTRecord.sid:
              LabelSSTRecord lsrec = (LabelSSTRecord) record;
                thisRow = lsrec.getRow();
                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;

View Full Code Here

0 1 2 3 4 5

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.