Examples with SSTRecord org.apache.poi.hssf.record.SSTRecord used on opensource projects

Example 6 with SSTRecord

use of org.apache.poi.hssf.record.SSTRecord in project poi by apache.

the class InternalWorkbook method insertSST.

/**
     * use this function to add a Shared String Table to an existing sheet (say
     * generated by a different java api) without an sst....
     * @see #createExtendedSST()
     * @see org.apache.poi.hssf.record.SSTRecord
     */
public void insertSST() {
    LOG.log(DEBUG, "creating new SST via insertSST!");
    sst = new SSTRecord();
    records.add(records.size() - 1, createExtendedSST());
    records.add(records.size() - 2, sst);
}

Example 7 with SSTRecord

use of org.apache.poi.hssf.record.SSTRecord in project poi by apache.

the class HSSFWorkbook method convertLabelRecords.

/**
      * This is basically a kludge to deal with the now obsolete Label records.  If
      * you have to read in a sheet that contains Label records, be aware that the rest
      * of the API doesn't deal with them, the low level structure only provides read-only
      * semi-immutable structures (the sets are there for interface conformance with NO
      * Implementation).  In short, you need to call this function passing it a reference
      * to the Workbook object.  All labels will be converted to LabelSST records and their
      * contained strings will be written to the Shared String table (SSTRecord) within
      * the Workbook.
      *
      * @param records a collection of sheet's records.
      * @param offset the offset to search at
      * @see org.apache.poi.hssf.record.LabelRecord
      * @see org.apache.poi.hssf.record.LabelSSTRecord
      * @see org.apache.poi.hssf.record.SSTRecord
      */
private void convertLabelRecords(List<Record> records, int offset) {
    if (log.check(POILogger.DEBUG)) {
        log.log(POILogger.DEBUG, "convertLabelRecords called");
    }
    for (int k = offset; k < records.size(); k++) {
        Record rec = records.get(k);
        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");
    }
}

Example 8 with SSTRecord

use of org.apache.poi.hssf.record.SSTRecord in project poi by apache.

the class TestLinkTable method testMissingExternSheetRecord_bug47001b.

/**
	 * This problem was visible in POI svn r763332
	 * when reading the workbook of attachment 23468 from bugzilla 47001
	 */
public void testMissingExternSheetRecord_bug47001b() {
    Record[] recs = { SupBookRecord.createAddInFunctions(), new SSTRecord() };
    List<Record> recList = Arrays.asList(recs);
    WorkbookRecordList wrl = new WorkbookRecordList();
    LinkTable lt;
    try {
        lt = new LinkTable(recList, 0, wrl, Collections.<String, NameCommentRecord>emptyMap());
    } catch (RuntimeException e) {
        if (e.getMessage().equals("Expected an EXTERNSHEET record but got (org.apache.poi.hssf.record.SSTRecord)")) {
            throw new AssertionFailedError("Identified bug 47001b");
        }
        throw e;
    }
    assertNotNull(lt);
}