ExcelDNA / Managed XLL / Excel Interop

I find it completely implausible that the interop API is such a mess

Many methods have no comments and seem to be done very poorly.

Has anyone else experienced the same thing, and if so, which library do you use to control Exel with C #?

+3
source share
2 answers

An obvious practical problem with VSTO / COM Interop technology is the overhead that occurs when switching between a worksheet and managed code. (And if you are trying to talk to Excel without the help of VSTO, stop doing this and save yourself huge headaches). I thought VSTO did a pretty good job of providing a close equivalent of the Excel object model in a managed environment — of course, I didn't have to spend a lot of time trying to understand much more about .NET Interop.

For longer automation work, the overhead is not as important as for VBA automation - reduce the number of calls on the interface as much as possible to get maximum performance.

, ( , XLL, ), . ExcelDNA XLL - .

+4

SpreadsheetGear .NET - Excel, .NET. Excel, Excel- ASP.NET/WinForms/etc..., , , , , , , , Excel .NET. SpreadsheetGear - 100% - , , Excel.

API SpreadsheetGear API Excel - , API- , , , #, API Excel.

, ASP.NET /// VB # .

: SpreadsheetGear LLC

0

Source: https://habr.com/ru/post/1723847/


All Articles