Help with EPPlus.dll and AHK
Posted: 20 Jun 2018, 11:40
EDIT: Please see below for working examples. I'll keep updating this page unless someone decides it should be moved out of "Ask for Help"
Edit: July 10, 2018: See the post below on Templating for loading from, modifying, and saving to .XLSX.
Hello, after trying the code from tmplinshi's question answered by qwerty12, I have been trying to adapt that code to EPPLus.dll, for working with Excel .xlsx files without needing Excel installed. URL: EPPlus github repository.
From that page:So far all my efforts with running C# code samples via CLR have failed, almost always with "unable to load EPPLus or one of its dependencies." Attempts with Clr_LoadLibrary("EPPlus.dll") throw no errors, but I haven't been able to create a workbook or a worksheet. Many things are now working well.
To try to delve into the inner workings of what was going, I modified qwerty12's code like this:
The message box yielded this: Error GIF removed 7/10/18, no longer relevant.
That was helpful, and I was encouraged. However, when I tried something as simple as this:
Non-working code removed 7/10/18
there are no errors, but the msgbox shows no cname, name clsid or VT.
I have used dnspy as suggested by qwerty12 to try to determine the right objects to create, but so far no luck.
EPPlus is very useable from PowerShell and C#, however. I can't for the life of me figure out why it is so difficult for me in AHK. I am very much hoping someone can point me in the right direction.
Regards,
burque505
Latest post: July 10, 2018
Edit: July 10, 2018: See the post below on Templating for loading from, modifying, and saving to .XLSX.
Hello, after trying the code from tmplinshi's question answered by qwerty12, I have been trying to adapt that code to EPPLus.dll, for working with Excel .xlsx files without needing Excel installed. URL: EPPlus github repository.
From that page:
Create advanced Excel spreadsheets using .NET, without the need of interop.
EPPlus is a .NET library that reads and writes Excel files using the Office Open XML format (xlsx). EPPlus has no dependencies other than .NET.
Non-working code removed 7/10/18
I have used dnspy as suggested by qwerty12 to try to determine the right objects to create
Regards,
burque505
Latest post: July 10, 2018