Need to find software tools for interacting with EXEL and 1C, is it possible to programmatically unload from 1C?

Question

excel

It is necessary to establish the relationship between 1C and Excel, internal tools do not allow you to get the desired functionality, it was decided to combine programmatically, in whole or in part. With Excel, it's more or less clear, there are macros in BASIC. But I'm looking for funds in C#. Read / write to cells, with 1C it is less and less clear how and what. It is advisable to indicate in which direction to smoke the topic if there are no ready-made guides :)

Answer 1

OLE/COM

Answer 2

I found Microsoft.Office.Interop.Excel , before that I also tried to work with it. There is a strange problem with the library, all you can do is programmatically open an Excel window and create a book, not a single code and examples and manuals work, you won’t be able to read or write data. https://docs.microsoft.com/ru-ru/dotnet/csharp/pro... at least from this link. Can you explain what is the reason? Maybe the library needs to be registered somewhere in Windows first? to VS successfully added dependencies.

Answer 3

thematic site, collected various information
https://infostart.ru/public/all/?st=t&sort=postsd&...

Answer 4

"Monsieur knows a lot about ..." (C)
In my opinion, even in the 1C user manual, examples are given with the creation of an Excel object directly with 1C code. Well, then VBA within the framework of the created object. That is, "internal funds" are more than enough to implement absolutely any interaction.
Unless, of course, screwing C# here is not initially a prerequisite ...