SheetRefEvaluator CreateExternSheetRefEvaluator(int externSheetIndex)
{
ExternalSheet externalSheet = _workbook.GetExternalSheet(externSheetIndex);
WorkbookEvaluator targetEvaluator;
int otherSheetIndex;
if (externalSheet == null)
{
// sheet is in same workbook
otherSheetIndex = _workbook.ConvertFromExternSheetIndex(externSheetIndex);
targetEvaluator = _bookEvaluator;
}
else
{
// look up sheet by name from external workbook
String workbookName = externalSheet.GetWorkbookName();
try
{
targetEvaluator = _bookEvaluator.GetOtherWorkbookEvaluator(workbookName);
}
catch (WorkbookNotFoundException)
{
throw;
}
otherSheetIndex = targetEvaluator.GetSheetIndex(externalSheet.GetSheetName());
if (otherSheetIndex < 0)
{
throw new Exception("Invalid sheet name '" + externalSheet.GetSheetName()
+ "' in bool '" + workbookName + "'.");
}
}
return(new SheetRefEvaluator(targetEvaluator, _tracker, otherSheetIndex));
}
