Examples of org.apache.poi.hssf.record.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

        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

    
    // 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

    
    // 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

        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

                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

    
    // 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

    
    // 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

             if (rec.getSid() == LabelRecord.sid)
             {
                 LabelRecord oldrec = ( LabelRecord ) rec;


                 records.remove(k);
                 LabelSSTRecord newrec   = new LabelSSTRecord();
                 int            stringid =
                     workbook.addSSTString(new UnicodeString(oldrec.getValue()));


                 newrec.setRow(oldrec.getRow());
                 newrec.setColumn(oldrec.getColumn());
                 newrec.setXFIndex(oldrec.getXFIndex());
                 newrec.setSSTIndex(stringid);
                       records.add(k, newrec);
             }
         }
         if (log.check( POILogger.DEBUG ))
             log.log(POILogger.DEBUG, "convertLabelRecords exit");

View Full Code Here

             if (rec.getSid() == LabelRecord.sid)
             {
                 LabelRecord oldrec = ( LabelRecord ) rec;


                 records.remove(k);
                 LabelSSTRecord newrec   = new LabelSSTRecord();
                 int            stringid =
                     workbook.addSSTString(new UnicodeString(oldrec.getValue()));


                 newrec.setRow(oldrec.getRow());
                 newrec.setColumn(oldrec.getColumn());
                 newrec.setXFIndex(oldrec.getXFIndex());
                 newrec.setSSTIndex(stringid);
                       records.add(k, newrec);
             }
         }
         if (log.check( POILogger.DEBUG ))
             log.log(POILogger.DEBUG, "convertLabelRecords exit");

View Full Code Here

                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

0 1 2 3 4 5 6 7 8 9

TOP

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

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.eventusermodel.TestMissingRecordAwareHSSFListener

org.apache.poi.hssf.extractor.EventBasedExcelExtractor$TextListener

org.apache.poi.hssf.usermodel.HSSFCell

org.apache.poi.hssf.usermodel.HSSFWorkbook

org.apache.tika.parser.microsoft.ExcelEventParser$TikaHSSFListener

org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener

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.