C#•2y ago

✅ Microsoft.Interop.Excel version?

I have this error and after some research the version of Microsoft.Interop.Excel NuGet Package should be the same as the office installation one? If it has nothing to do with the office version, what should I do?

TeBeCo•1/13/24, 11:54 AM

office 14 is office 2010

TeBeCo•1/13/24, 11:54 AM

that's rather ultra old

TeBeCo•1/13/24, 11:54 AM

TeBeCo•1/13/24, 11:54 AM

means there's a COM

TeBeCo•1/13/24, 11:55 AM

means it's talking to something installed on computer

TeBeCo•1/13/24, 11:55 AM

that's how office "interop" in general

TeBeCo•1/13/24, 11:55 AM

you need to inter ... operate with the installed version

TeBeCo•1/13/24, 11:55 AM

and the nuget package has to be written to be compliant with that version

TeBeCo•1/13/24, 11:55 AM

hence my screenshot

TeBeCo•1/13/24, 11:56 AM

TeBeCo•1/13/24, 11:56 AM

means that the nuget version can only talk to version

ʙʀʊʍɨOP•1/13/24, 12:18 PM

yea i just installed the 15 but it still doesnt work

ʙʀʊʍɨOP•1/13/24, 12:19 PM

probably cuz i have office 2021

ʙʀʊʍɨOP•1/13/24, 12:22 PM

also found COM reference Interop.Microsoft.Office.Interop.Excel

ʙʀʊʍɨOP•1/13/24, 12:22 PM

which is v 16

TeBeCo•1/13/24, 12:24 PM

i mean the package says 2013 2016 2019

TeBeCo•1/13/24, 12:24 PM

so no it's not gonna supposed to be workign with 2021

ʙʀʊʍɨOP•1/13/24, 12:25 PM

with the COM reference it seems to work

ʙʀʊʍɨOP•1/13/24, 12:25 PM

well at least the error was solved

ʙʀʊʍɨOP•1/13/24, 12:25 PM

but now i got other errors

TeBeCo•1/13/24, 12:26 PM

i mean you're using an incompatible package

TeBeCo•1/13/24, 12:26 PM

or at least non-official

TeBeCo•1/13/24, 12:26 PM

you forced it in another

TeBeCo•1/13/24, 12:26 PM

so i'd expect there's breaking changes

TeBeCo•1/13/24, 12:27 PM

either internal or on api level

TeBeCo•1/13/24, 12:27 PM

it's basically up to being lucky

TeBeCo•1/13/24, 12:27 PM

if you consume none of these breakignb api you're lucky

TeBeCo•1/13/24, 12:27 PM

else kaboum

ʙʀʊʍɨOP•1/13/24, 12:27 PM

i see

ʙʀʊʍɨOP•1/13/24, 12:28 PM

this is what it says now

TeBeCo•1/13/24, 12:28 PM

ʙʀʊʍɨOP•1/13/24, 12:29 PM

ah well ill see what i can find on the internet but thanks

TeBeCo•1/13/24, 12:29 PM

as on the nuget repo directly