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

                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

             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

                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

             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

            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

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

                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

                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

                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

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.