Export excel with dynamic formatting from ASP.NET RRS feed

  • Question

  • Hi,

    I am working on an ASP.NET 4.0 website. I want to export data from database to excel 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 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.


    Tuesday, April 7, 2015 2:53 PM


  • Hi

    I want to export to Excel 2013 (xlsx file) from ASP.NET website.



    Hi Ashok,

    For questions related Asp.Net should be posted in Asp.Net forum where you can contact ASP.NET experts.

    I've just do a quick search in the internet. A similar thread like yours


    If above solution still not resolve your issue,Please reopen a new thread in that forum. Thanks for your understanding.

    Best regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Just Karl Tuesday, April 14, 2015 7:26 PM
    • Marked as answer by Just Karl Thursday, April 23, 2015 9:51 PM
    Monday, April 13, 2015 7:46 AM

All replies