Any NET C# Opensource libraries for exporting to excel including customization like color,font,colspan etc..?

[rajashekar2012]

I'm using C# .NET MVC application. I have a requirement of generating excel reports(.xlsx) with multiple worksheets and cell customizations like font, color etc... I tried and couldn't find any opensource library that could do this. I don't want Excel Interop library as excel application installation is required at the server. We tried Fast Excel and Excel Library but due to lack of documentation and references online we are not able to find any code of how to customize cell color/font/width etc.. There are lot of good commercially available ones. But are there any good opensource libraries that can be used.

 

[Skydiver]

Welcome to the Open XML SDK 2.5 for Office

Documentation and guidance for the strongly-typed classes in the Open XML SDK 2.5 for Office.

learn.microsoft.com

GitHub - dotnet/Open-XML-SDK: Open XML SDK by Microsoft

Open XML SDK by Microsoft. Contribute to dotnet/Open-XML-SDK development by creating an account on GitHub.

github.com

 

[kareninstructor]

Check out Spreadsheetlight which has downloadable help file.

 

[cjard]

ClosedXml