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
Hello Benjamin,
Could OleDBConnection be of any use? I've dealt with Excel files in the past using it and it suited the purpose. Not sure if it would work without having office installed.
If you need an example for this, just answer this one and I can look something up 🙂
Benjamin Hodžić [SLC] [DevOps Advocate] Posted new comment 5th April 2023
Hi João and thank you, I’ve looked it up and it doesn’t require Office being installed. But it wouldn’t suit me well since it isn’t convenient to write queries to update only a couple of cells.