Toggle navigation
LINQPad
Categories
Discussions
Activity
Best Of...
Sign In
Home
.NetCore 3 and Excel intereop
andremoraes
July 2019
I've many scripts that uses Microsoft.Interop to read/write into excel. Any solutions for that yet?
Thanks, AM.
0
·
Share on Twitter
Share on Facebook
Comments
JoeAlbahari
July 2019
It sounds like there are plans to support this in netcore3:
https://twitter.com/runfaster2000/status/1053704090671185920
0
·
Share on Twitter
Share on Facebook
andremoraes
September 2019
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
Excel.linq.txt
572B
0
·
Share on Twitter
Share on Facebook
andremoraes
September 2019
[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...
0
·
Share on Twitter
Share on Facebook
Sign In
or
Register
to comment.
Comments
does the trick to interact w/ a new instance... just need to figure it out how to interact w/ an existing instance now
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...