Toggle navigation
LINQPad
Categories
Discussions
Activity
Best Of...
Sign In
Home
›
General
.NetCore 3 and Excel intereop
andremoraes
July 2019
in
General
I've many scripts that uses Microsoft.Interop to read/write into excel. Any solutions for that yet?
Thanks, AM.
0
·
Share on Facebook
Share on Twitter
Comments
JoeAlbahari
July 2019
It sounds like there are plans to support this in netcore3:
https://twitter.com/runfaster2000/status/1053704090671185920?lang=en
0
·
Share on Facebook
Share on Twitter
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 Facebook
Share on Twitter
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 Facebook
Share on Twitter
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...