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

Example 16 with UnicodeString

use of org.apache.poi.hssf.record.common.UnicodeString 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");
    }
}