I have started using the Excel interop assemblies that are provided by Microsoft for one of my C# applications. Everything is going fine, but there seems to be a lack of strong typing, and honestly it feels like I am writing VBA code. Are there any alternative ways to interact with Excel from C# that would give a better OO experience? I am using VS2010 and .Net 4.0 by the way.
7 Answers
In 2020, the ClosedXML library at https://github.com/ClosedXML/ClosedXML seems pretty capable of generating Excel files. It is based on the Open XML SDK by Microsoft (https://github.com/OfficeDev/Open-XML-SDK). It does not require Excel to be installed on a computer/server to work. So apparently you can rig it to generate Excel files on a web server. It has a very nice set of objects that expose relatively easy means of manipulating Excel files.
Related