ExcelDna icon indicating copy to clipboard operation
ExcelDna copied to clipboard

Range.Columns property error encountered after upgrading to new version of exceldna

Open godefy opened this issue 7 months ago • 4 comments

ClassLibrary1_vb_testRange.zip

I recently encountered a problem using the latest version When the range object uses the Columns attribute, it cannot be used normally.

Range.Columns Property (Microsoft.Office.Interop.Excel) | Microsoft Learn

I used to use "rangeObj.Columns(1)" to get the first column of data in the range, but now when I use the same code, an exception occurs: "System.MissingMemberException" Previously the following code worked fine: dim result = rangeObj.Columns(1).value Now i can only: Dim temp = rangeObj.Columns(1) dim result = temp.value

This problem feels very strange to me. This is the only problem I have left after upgrading to the new version. Please help me confirm the reason.

I've attached the project I used. Excel input during debugging: Snipaste_2024-07-19_19-52-26

godefy avatar Jul 20 '24 01:07 godefy