@Override public String toString() { StringBuffer sb = new StringBuffer(); int nItems = _list.size(); sb.append("[EXTERNSHEET]\n"); sb.append(" numOfRefs = ").append(nItems).append("\n"); for (int i=0; i < nItems; i++) { sb.append("refrec #").append(i).append(": "); sb.append(getRef(i)); sb.append('\n'); } sb.append("[/EXTERNSHEET]\n"); return sb.toString(); }
/** * @param refIndex specifies the n-th refIndex * * @return the index of the SupBookRecord for this index */ public int getExtbookIndexFromRefIndex(int refIndex) { RefSubRecord refRec = getRef(refIndex); return refRec.getExtBookIndex(); }
/** * Returns the first sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped. * * @param extRefIndex external sheet reference index * * @return the first sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped */ public int getFirstSheetIndexFromRefIndex(int extRefIndex) { return getRef(extRefIndex).getFirstSheetIndex(); }
/** * @param extBookIndex external sheet reference index * * @return -1 if not found */ public int findRefIndexFromExtBookIndex(int extBookIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { if (getRef(i).getExtBookIndex() == extBookIndex) { return i; } } return -1; }
/** * Returns the last sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped. * For a single sheet reference, the first and last should be * the same. * * @param extRefIndex external sheet reference index * * @return the last sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped. */ public int getLastSheetIndexFromRefIndex(int extRefIndex) { return getRef(extRefIndex).getLastSheetIndex(); }
@Override public void serialize(LittleEndianOutput out) { int nItems = _list.size(); out.writeShort(nItems); for (int i = 0; i < nItems; i++) { getRef(i).serialize(out); } }
public int getRefIxForSheet(int externalBookIndex, int firstSheetIndex, int lastSheetIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord ref = getRef(i); if (ref.getExtBookIndex() != externalBookIndex) { continue; } if (ref.getFirstSheetIndex() == firstSheetIndex && ref.getLastSheetIndex() == lastSheetIndex) { return i; } } return -1; }
public static ExternSheetRecord combine(ExternSheetRecord[] esrs) { ExternSheetRecord result = new ExternSheetRecord(); for (ExternSheetRecord esr : esrs) { int nRefs = esr.getNumOfREFRecords(); for (int j=0; j<nRefs; j++) { result.addREFRecord(esr.getRef(j)); } } return result; } }
@Override public String toString() { StringBuffer sb = new StringBuffer(); int nItems = _list.size(); sb.append("[EXTERNSHEET]\n"); sb.append(" numOfRefs = ").append(nItems).append("\n"); for (int i=0; i < nItems; i++) { sb.append("refrec #").append(i).append(": "); sb.append(getRef(i)); sb.append('\n'); } sb.append("[/EXTERNSHEET]\n"); return sb.toString(); }
/** * @return -1 if not found */ public int findRefIndexFromExtBookIndex(int extBookIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { if (getRef(i).getExtBookIndex() == extBookIndex) { return i; } } return -1; }
/** * @return -1 if not found */ public int findRefIndexFromExtBookIndex(int extBookIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { if (getRef(i).getExtBookIndex() == extBookIndex) { return i; } } return -1; }
/** * @param refIndex specifies the n-th refIndex * * @return the index of the SupBookRecord for this index */ public int getExtbookIndexFromRefIndex(int refIndex) { RefSubRecord refRec = getRef(refIndex); return refRec.getExtBookIndex(); }
public String toString() { StringBuffer sb = new StringBuffer(); int nItems = _list.size(); sb.append("[EXTERNSHEET]\n"); sb.append(" numOfRefs = ").append(nItems).append("\n"); for (int i=0; i < nItems; i++) { sb.append("refrec #").append(i).append(": "); sb.append(getRef(i).toString()); sb.append('\n'); } sb.append("[/EXTERNSHEET]\n"); return sb.toString(); }
@Override public void serialize(LittleEndianOutput out) { int nItems = _list.size(); out.writeShort(nItems); for (int i = 0; i < nItems; i++) { getRef(i).serialize(out); } }
public void serialize(LittleEndianOutput out) { int nItems = _list.size(); out.writeShort(nItems); for (int i = 0; i < nItems; i++) { getRef(i).serialize(out); } }
public void serialize(LittleEndianOutput out) { int nItems = _list.size(); out.writeShort(nItems); for (int i = 0; i < nItems; i++) { getRef(i).serialize(out); } }
public int getRefIxForSheet(int externalBookIndex, int sheetIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord ref = getRef(i); if (ref.getExtBookIndex() != externalBookIndex) { continue; } if (ref.getFirstSheetIndex() == sheetIndex && ref.getLastSheetIndex() == sheetIndex) { return i; } } return -1; }
public int getRefIxForSheet(int externalBookIndex, int sheetIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord ref = getRef(i); if (ref.getExtBookIndex() != externalBookIndex) { continue; } if (ref.getFirstSheetIndex() == sheetIndex && ref.getLastSheetIndex() == sheetIndex) { return i; } } return -1; }
public static ExternSheetRecord combine(ExternSheetRecord[] esrs) { ExternSheetRecord result = new ExternSheetRecord(); for (int i = 0; i < esrs.length; i++) { ExternSheetRecord esr = esrs[i]; int nRefs = esr.getNumOfREFRecords(); for (int j=0; j<nRefs; j++) { result.addREFRecord(esr.getRef(j)); } } return result; } }
public static ExternSheetRecord combine(ExternSheetRecord[] esrs) { ExternSheetRecord result = new ExternSheetRecord(); for (ExternSheetRecord esr : esrs) { int nRefs = esr.getNumOfREFRecords(); for (int j=0; j<nRefs; j++) { result.addREFRecord(esr.getRef(j)); } } return result; } }