ExcelDna
ExcelDna copied to clipboard
Range.Columns property error encountered after upgrading to new version of exceldna
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: