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

org.apache.poi.hssf.record.ExternSheetSubRecord
Title: A sub Record for Extern Sheet
Description: Defines a named range within a workbook.
REFERENCE:
@author Libin Roman (Vista Portal LDT. Developer) @version 1.0-pre

    return _externSheetRecord.getREFRecordAt(externSheetNumber).getIndexToFirstSupBook();
  }


  public short addSheetIndexToExternSheet(short sheetNumber) {


    ExternSheetSubRecord record = new ExternSheetSubRecord();
    record.setIndexToFirstSupBook(sheetNumber);
    record.setIndexToLastSupBook(sheetNumber);
    _externSheetRecord.addREFRecord(record);
    _externSheetRecord.setNumOfREFStructures((short)(_externSheetRecord.getNumOfREFStructures() + 1));
    return (short)(_externSheetRecord.getNumOfREFStructures() - 1);
  }

View Full Code Here

  public short checkExternSheet(int sheetNumber) {


    //Trying to find reference to this sheet
    int nESRs = _externSheetRecord.getNumOfREFStructures();
    for(short i=0; i< nESRs; i++) {
      ExternSheetSubRecord esr = _externSheetRecord.getREFRecordAt(i);


      if (esr.getIndexToFirstSupBook() ==  sheetNumber
          && esr.getIndexToLastSupBook() == sheetNumber){
        return i;
      }
    }


    //We Haven't found reference to this sheet

View Full Code Here

    return _externSheetRecord.getREFRecordAt(externSheetNumber).getIndexToFirstSupBook();
  }


  public short addSheetIndexToExternSheet(short sheetNumber) {


    ExternSheetSubRecord record = new ExternSheetSubRecord();
    record.setIndexToFirstSupBook(sheetNumber);
    record.setIndexToLastSupBook(sheetNumber);
    _externSheetRecord.addREFRecord(record);
    _externSheetRecord.setNumOfREFStructures((short)(_externSheetRecord.getNumOfREFStructures() + 1));
    return (short)(_externSheetRecord.getNumOfREFStructures() - 1);
  }

View Full Code Here

  public short checkExternSheet(int sheetNumber) {


    //Trying to find reference to this sheet
    int nESRs = _externSheetRecord.getNumOfREFStructures();
    for(short i=0; i< nESRs; i++) {
      ExternSheetSubRecord esr = _externSheetRecord.getREFRecordAt(i);


      if (esr.getIndexToFirstSupBook() ==  sheetNumber
              && esr.getIndexToLastSupBook() == sheetNumber){
        return i;
      }
    }


    //We Haven't found reference to this sheet

View Full Code Here

    return _externSheetRecord.getREFRecordAt(externSheetNumber).getIndexToFirstSupBook();
  }


  public short addSheetIndexToExternSheet(short sheetNumber) {


    ExternSheetSubRecord record = new ExternSheetSubRecord();
    record.setIndexToFirstSupBook(sheetNumber);
    record.setIndexToLastSupBook(sheetNumber);
    _externSheetRecord.addREFRecord(record);
    _externSheetRecord.setNumOfREFStructures((short)(_externSheetRecord.getNumOfREFStructures() + 1));
    return (short)(_externSheetRecord.getNumOfREFStructures() - 1);
  }

View Full Code Here

  public short checkExternSheet(int sheetNumber) {


    //Trying to find reference to this sheet
    int nESRs = _externSheetRecord.getNumOfREFStructures();
    for(short i=0; i< nESRs; i++) {
      ExternSheetSubRecord esr = _externSheetRecord.getREFRecordAt(i);


      if (esr.getIndexToFirstSupBook() ==  sheetNumber
          && esr.getIndexToLastSupBook() == sheetNumber){
        return i;
      }
    }


    //We Haven't found reference to this sheet

View Full Code Here

TOP

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

org.apache.poi.hssf.model.LinkTable

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.