Hi Dojo,
I need to develop a connector which reads and writes to an excel file. I can't use Microsoft COM objects because the customer doesn't have Microsoft Office installed. I've tried multiple NuGet packages, but they need licenses to be used commercially.
Does anyone have a suggestion on how to approach this?
Benjamin Hodžić [SLC] [DevOps Advocate] Selected answer as best 13th April 2023
Hi Benjamin
I have previously used NPOI in an automation script to create a basic excel. In DIS internally I've also used NPOI for excel. This is a public NuGet package that you can then use. I've never had to read an excel, so is something you'll need to double check, but writing should not give any issues.
Benjamin Hodžić [SLC] [DevOps Advocate] Posted new comment 5th April 2023
Thank you, Michiel. I will certainly have a look at this.