/** * Constructor * * @param esf the external sheet record to copy */ public ExternalSheetRecord(jxl.read.biff.ExternalSheetRecord esf) { super(Type.EXTERNSHEET); xtis = new ArrayList(esf.getNumRecords()); XTI xti = null; for (int i = 0 ; i < esf.getNumRecords(); i++) { xti = new XTI(esf.getSupbookIndex(i), esf.getFirstTabIndex(i), esf.getLastTabIndex(i)); xtis.add(xti); } }
/** * Used when copying a workbook to access the raw external sheet data * * @return the raw external sheet data */ public byte[] getData() { return getRecord().getData(); } }
int supbookIndex = externSheet.getSupbookIndex(index); SupbookRecord sr = (SupbookRecord) supbooks.get(supbookIndex); int firstTab = externSheet.getFirstTabIndex(index); int lastTab = externSheet.getLastTabIndex(index); String firstTabName = ""; String lastTabName = "";
int supbookIndex = externSheet.getSupbookIndex(index); SupbookRecord sr = (SupbookRecord) supbooks.get(supbookIndex); int lastTab = externSheet.getLastTabIndex(index);
/** * Package protected function which gets the real internal sheet index * based upon the external sheet reference. This is used for extern sheet * references which are specified in formulas * * @param index the external sheet reference * @return the actual sheet index */ public int getExternalSheetIndex(int index) { // For biff7, the whole external reference thing works differently // Hopefully for our purposes sheet references will all be local if (workbookBof.isBiff7()) { return index; } Assert.verify(externSheet != null); int firstTab = externSheet.getFirstTabIndex(index); return firstTab; }
/** * Package protected function which gets the real internal sheet index * based upon the external sheet reference. This is used for extern sheet * references which are specified in formulas * * @param index the external sheet reference * @return the actual sheet index */ public int getLastExternalSheetIndex(int index) { // For biff7, the whole external reference thing works differently // Hopefully for our purposes sheet references will all be local if (workbookBof.isBiff7()) { return index; } Assert.verify(externSheet != null); int lastTab = externSheet.getLastTabIndex(index); return lastTab; }
externSheet = new ExternalSheetRecord(r, settings); externSheet = new ExternalSheetRecord(r, settings, ExternalSheetRecord.biff7);
int supbookIndex = externSheet.getSupbookIndex(index); SupbookRecord sr = (SupbookRecord) supbooks.get(supbookIndex); int firstTab = externSheet.getFirstTabIndex(index); int lastTab = externSheet.getLastTabIndex(index); String firstTabName = ""; String lastTabName = "";
int supbookIndex = externSheet.getSupbookIndex(index); SupbookRecord sr = (SupbookRecord) supbooks.get(supbookIndex); int lastTab = externSheet.getLastTabIndex(index);
/** * Package protected function which gets the real internal sheet index * based upon the external sheet reference. This is used for extern sheet * references which are specified in formulas * * @param index the external sheet reference * @return the actual sheet index */ public int getExternalSheetIndex(int index) { // For biff7, the whole external reference thing works differently // Hopefully for our purposes sheet references will all be local if (workbookBof.isBiff7()) { return index; } Assert.verify(externSheet != null); int firstTab = externSheet.getFirstTabIndex(index); return firstTab; }
/** * Package protected function which gets the real internal sheet index * based upon the external sheet reference. This is used for extern sheet * references which are specified in formulas * * @param index the external sheet reference * @return the actual sheet index */ public int getLastExternalSheetIndex(int index) { // For biff7, the whole external reference thing works differently // Hopefully for our purposes sheet references will all be local if (workbookBof.isBiff7()) { return index; } Assert.verify(externSheet != null); int lastTab = externSheet.getLastTabIndex(index); return lastTab; }
externSheet = new ExternalSheetRecord(r, settings); externSheet = new ExternalSheetRecord(r, settings, ExternalSheetRecord.biff7);
/** * Constructor * * @param esf the external sheet record to copy */ public ExternalSheetRecord(jxl.read.biff.ExternalSheetRecord esf) { super(Type.EXTERNSHEET); xtis = new ArrayList(esf.getNumRecords()); XTI xti = null; for (int i = 0 ; i < esf.getNumRecords(); i++) { xti = new XTI(esf.getSupbookIndex(i), esf.getFirstTabIndex(i), esf.getLastTabIndex(i)); xtis.add(xti); } }
/** * Used when copying a workbook to access the raw external sheet data * * @return the raw external sheet data */ public byte[] getData() { return getRecord().getData(); } }
/** * Constructs this object from the raw data * * @param t the raw data * @param ws the workbook settings */ ExternalSheetRecord(Record t, WorkbookSettings ws) { super(t); byte[] data = getRecord().getData(); int numxtis = IntegerHelper.getInt(data[0], data[1]); if (data.length < numxtis * 6 + 2) { xtiArray = new XTI[0]; logger.warn("Could not process external sheets. Formulas may " + "be compromised."); return; } xtiArray = new XTI[numxtis]; int pos = 2; for (int i = 0; i < numxtis; i++) { int s = IntegerHelper.getInt(data[pos], data[pos + 1]); int f = IntegerHelper.getInt(data[pos + 2], data[pos + 3]); int l = IntegerHelper.getInt(data[pos + 4], data[pos + 5]); xtiArray[i] = new XTI(s, f, l); pos += 6; } }
/** * Constructs this object from the raw data * * @param t the raw data * @param ws the workbook settings */ ExternalSheetRecord(Record t, WorkbookSettings ws) { super(t); byte[] data = getRecord().getData(); int numxtis = IntegerHelper.getInt(data[0], data[1]); if (data.length < numxtis * 6 + 2) { xtiArray = new XTI[0]; logger.warn("Could not process external sheets. Formulas may " + "be compromised."); return; } xtiArray = new XTI[numxtis]; int pos = 2; for (int i = 0; i < numxtis; i++) { int s = IntegerHelper.getInt(data[pos], data[pos + 1]); int f = IntegerHelper.getInt(data[pos + 2], data[pos + 3]); int l = IntegerHelper.getInt(data[pos + 4], data[pos + 5]); xtiArray[i] = new XTI(s, f, l); pos += 6; } }