.NetCore 3 and Excel intereop

andremoraes

I've many scripts that uses Microsoft.Interop to read/write into excel. Any solutions for that yet?


Thanks, AM.

JoeAlbahari

It sounds like there are plans to support this in netcore3:

https://twitter.com/runfaster2000/status/1053704090671185920?lang=en

andremoraes

it's working now. ExcelDemo found in https://github.com/dotnet/samples/tree/master/core/extensions/ExcelDemo
does the trick to interact w/ a new instance... just need to figure it out how to interact w/ an existing instance now

andremoraes

[DllImport("ole32.dll")]
private static extern int GetRunningObjectTable(int reserved, out IRunningObjectTable prot);

does the trick for using an already open instance... so now I can fully covert some scripts to LinqPAD 6... so cool...