private static Excel.Range ToRange(ExcelReference excelReference) { Excel.Application app = new Excel.Application(null, ExcelDnaUtil.Application); Excel.Range refRange = app.Range(XlCall.Excel(XlCall.xlfReftext, excelReference, true)); return(refRange); }
internal static Excel.Range FromExcelReferenceToRange(ExcelReference excelReference) { Excel.Application app = new Excel.Application(null, ExcelDnaUtil.Application); object address = XlCall.Excel(XlCall.xlfReftext, excelReference, true); Excel.Range range = app.Range(address); return(range); }
// this will be executing on the host's appdomain private static Excel.Range TransferableValueToRange(object transferableValue) { string address = (string)transferableValue; var application = new Excel.Application(null, ExcelDnaUtil.Application); var range = application.Range(address); range.OnDispose += (args) => { range.Application.Dispose(); }; return(range); }