How do I get a WorkSheet from an ExcelReference?
I've seen examples of the following but this don't work:
ExcelReference reference = (ExcelReference)XlCall.Excel(XlCall.xlfCaller);
Excel.Application xlApp = (Excel.Application)ExcelDna.Integration.ExcelDnaUtil.Application;
string sheetName = (string)XlCall.Excel(XlCall.xlSheetNm, reference);
Excel.Worksheet xlActiveSheet = (Excel.Worksheet)xlApp.ActiveWorkbook.Worksheets[sheetName];
