Export excel with dynamic formatting from ASP.NET

ashok.k

Member
Joined
Nov 17, 2014
Messages
14
Programming Experience
5-10
Hi,
I am working on an ASP.NET 4.0 website. I want to export data from database to excel 2013 (Xlsx) from the website.
I do not want to use Microsoft Interop excel dlls since it requires excel on the webserver.
I want to export the data to excel (Xlsx) and format the excel cells dynamically. (Font, Color coding, Merging cells and calculation)
How to format the excel cells dynamically based on the values in the cells without Interop dlls? Any suggestions or links to excel formatting would be helpful.

Thanks
Ashok
 
Last edited:
Top Bottom