locked
Export excel with dynamic formatting from ASP.NET RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thanks
    Ashok

    Tuesday, April 7, 2015 2:53 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

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

    Thanks

    Ashok

    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

    http://forums.asp.net/t/1768549.aspx?This+is+how+to+export+data+from+ASP+Net+database+into+Excel

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

    Best regards,

    kristin

    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