We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
XLSM files to be written without Microsoft Interop components
1 reply
Last post Feb 11, 2019 02:01 PM by Mikesdotnetting
Last post Feb 11, 2019 02:01 PM by Mikesdotnetting
Member
72 Points
26 Posts
XLSM files to be written without Microsoft Interop components
Feb 11, 2019 10:27 AM|mike07|LINK
Hello Folks,
Do we have any other libraries which supports writing data to an xlsm file?
The interop components cannot be installed on my server due to restrictions and i'm looking for an alternative...
Thanks for your help in advance.
All-Star
195614 Points
28128 Posts
Moderator
Re: XLSM files to be written without Microsoft Interop components
Feb 11, 2019 02:01 PM|Mikesdotnetting|LINK
You can use the OpenXML SDK to work with these files, or you can use one of a number of libraries that have been designed to make working with OpenXML more intuitive, such as ClosedXML (https://github.com/ClosedXML/ClosedXML) or EPPlus (https://www.nuget.org/packages/EPPlus/)