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 Enabler] Selected answer as best 13th April 2023
If I remember correctly, multiple connectors that had to work with Excel spreadsheets make use of the OpenXml SDK:
https://www.nuget.org/packages/DocumentFormat.OpenXml
https://learn.microsoft.com/en-us/office/open-xml/open-xml-sdk
https://www.c-sharpcorner.com/article/creating-excel-file-using-openxml/
Benjamin Hodžić [SLC] [DevOps Enabler] Selected answer as best 13th April 2023
Thank you, Pedro. I’m attempting to integrate this right now. I’ll come back with the results 🙂