ExcelDna icon indicating copy to clipboard operation
ExcelDna copied to clipboard

Allow use of ExcelReference from outside Excel context

Open govert opened this issue 1 year ago • 0 comments

From this discussion: https://groups.google.com/g/exceldna/c/1CkGn4zLA18/m/0S9ocPxvAAAJ

For testing purposes, it can be convenient to use the ExcelReference class in a context where the code is not running as an Excel add-in in Excel. This scenario broke in version 1.1 and since has caused a NullReferenceException to be thrown.

There is a workaround for this under .NET Framework, but it might be useful to create some public and supported way to do this more generally.

govert avatar Dec 11 '23 14:12 govert