I’d like to know is it possible to manipulate Excel that’s already running instead loading from file, like in
VB.NET using Excel Interop such as this command below:
XLapp = CType(Marshal.GetActiveObject("Excel.Application"), Excel.Application)
I want to manipulate Excel while the active workbook and active worksheet are being used and opened. In many examples, I see that GemBox.Spreadsheet always opens the file first and manipulates later, but instead of doing that, I want to manipulate the file content while it running.
Thanks in advance.