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...
I have exported data into excel file using oledb since I cannot use interop or any third party library. Here is my code
''' Export datagridview's data contained in an data table to excel file
One of the requirements for an application that handles reports is to export or import reports into various file formats.
EasyXLS covers one of these file formats, the most common one, the Excel file format.
The library can be used from C# windows forms or ASP.NET web pages, but...