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

org.apache.poi.hssf.record.SupBookRecord
Title: Sup Book
Description: A Extrenal Workbook Deciption (Sup Book) Its only a dummy record for making new ExternSheet Record
REFERENCE:
@author Libin Roman (Vista Portal LDT. Developer) @author Andrew C. Oliver (acoliver@apache.org)

  }


  public int checkExternSheet(int sheetIndex) {
    int thisWbIndex = -1; // this is probably always zero
    for (int i=0; i<_externalBookBlocks.length; i++) {
      SupBookRecord ebr = _externalBookBlocks[i].getExternalBookRecord();
      if (ebr.isInternalReferences()) {
        thisWbIndex = i;
        break;
      }
    }
    if (thisWbIndex < 0) {

View Full Code Here

        int extBlockIndex = -1;
        ExternalBookBlock extBlock = null;


        // find ExternalBlock for Add-In functions and remember its index
        for (int i = 0; i < _externalBookBlocks.length; i++) {
            SupBookRecord ebr = _externalBookBlocks[i].getExternalBookRecord();
            if (ebr.isAddInFunctions()) {
                extBlock = _externalBookBlocks[i];
                extBlockIndex = i;
                break;
            }
        }

View Full Code Here

    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();


    int idx = findFirstRecordLocBySid(CountryRecord.sid);
    if(idx < 0) {
      throw new RuntimeException("CountryRecord not found");
    }

View Full Code Here

    return lastName.getSheetNumber() == firstName.getSheetNumber();
  }


  public String[] getExternalBookAndSheetName(int extRefIndex) {
    int ebIx = _externSheetRecord.getExtbookIndexFromRefIndex(extRefIndex);
    SupBookRecord ebr = _externalBookBlocks[ebIx].getExternalBookRecord();
    if (!ebr.isExternalReferences()) {
      return null;
    }
    // Sheet name only applies if not a global reference
    int shIx = _externSheetRecord.getFirstSheetIndexFromRefIndex(extRefIndex);
    String usSheetName = null;
    if(shIx >= 0) {
       usSheetName = ebr.getSheetNames()[shIx];
    }
    return new String[] {
        ebr.getURL(),
        usSheetName,
    };
  }

View Full Code Here

    return lastName.getSheetNumber() == firstName.getSheetNumber();
  }


  public String[] getExternalBookAndSheetName(int extRefIndex) {
    int ebIx = _externSheetRecord.getExtbookIndexFromRefIndex(extRefIndex);
    SupBookRecord ebr = _externalBookBlocks[ebIx].getExternalBookRecord();
    if (!ebr.isExternalReferences()) {
      return null;
    }
    // Sheet name only applies if not a global reference
    int shIx = _externSheetRecord.getFirstSheetIndexFromRefIndex(extRefIndex);
    String usSheetName = null;
    if(shIx >= 0) {
       usSheetName = ebr.getSheetNames()[shIx];
    }
    return new String[] {
        ebr.getURL(),
        usSheetName,
    };
  }

View Full Code Here

        usSheetName,
    };
  }


  public int getExternalSheetIndex(String workbookName, String sheetName) {
    SupBookRecord ebrTarget = null;
    int externalBookIndex = -1;
    for (int i=0; i<_externalBookBlocks.length; i++) {
      SupBookRecord ebr = _externalBookBlocks[i].getExternalBookRecord();
      if (!ebr.isExternalReferences()) {
        continue;
      }
      if (workbookName.equals(ebr.getURL())) { // not sure if 'equals()' works when url has a directory
        ebrTarget = ebr;
        externalBookIndex = i;
        break;
      }
    }

View Full Code Here

  }


  public int checkExternSheet(int sheetIndex) {
    int thisWbIndex = -1; // this is probably always zero
    for (int i=0; i<_externalBookBlocks.length; i++) {
      SupBookRecord ebr = _externalBookBlocks[i].getExternalBookRecord();
      if (ebr.isInternalReferences()) {
        thisWbIndex = i;
        break;
      }
    }
    if (thisWbIndex < 0) {

View Full Code Here

    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();


    int idx = findFirstRecordLocBySid(CountryRecord.sid);
    if(idx < 0) {
      throw new RuntimeException("CountryRecord not found");
    }

View Full Code Here

    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();


    int idx = findFirstRecordLocBySid(CountryRecord.sid);
    if(idx < 0) {
      throw new RuntimeException("CountryRecord not found");
    }

View Full Code Here

    return lastName.getSheetNumber() == firstName.getSheetNumber();
  }


  public String[] getExternalBookAndSheetName(int extRefIndex) {
    int ebIx = _externSheetRecord.getExtbookIndexFromRefIndex(extRefIndex);
    SupBookRecord ebr = _externalBookBlocks[ebIx].getExternalBookRecord();
    if (!ebr.isExternalReferences()) {
      return null;
    }
    int shIx = _externSheetRecord.getFirstSheetIndexFromRefIndex(extRefIndex);
    UnicodeString usSheetName = ebr.getSheetNames()[shIx];
    return new String[] {
        ebr.getURL(),
        usSheetName.getString(),
    };
  }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

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

org.apache.poi.hssf.model.LinkTable

org.apache.poi.hssf.model.TestLinkTable

org.apache.poi.hssf.record.TestSupBookRecord

org.apache.poi.hssf.record.UnicodeString.UnicodeRecordStats

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.