public ExternalSheet GetExternalSheet(int externSheetIndex)
{
ExternalSheet sheet = _iBook.GetExternalSheet(externSheetIndex);
if (sheet == null)
{
// Try to treat it as a local sheet
int localSheetIndex = ConvertFromExternSheetIndex(externSheetIndex);
if (localSheetIndex == -1)
{
// The sheet referenced can't be found, sorry
return(null);
}
if (localSheetIndex == -2)
{
// Not actually sheet based at all - is workbook scoped
return(null);
}
// Look up the local sheet
String sheetName = GetSheetName(localSheetIndex);
// Is it a single local sheet, or a range?
int lastLocalSheetIndex = _iBook.GetLastSheetIndexFromExternSheetIndex(externSheetIndex);
if (lastLocalSheetIndex == localSheetIndex)
{
sheet = new ExternalSheet(null, sheetName);
}
else
{
String lastSheetName = GetSheetName(lastLocalSheetIndex);
sheet = new ExternalSheetRange(null, sheetName, lastSheetName);
}
}
return(sheet);
}
public ExternalSheet GetExternalSheet(int externSheetIndex)
{
return(_iBook.GetExternalSheet(externSheetIndex));
}