Last post Sep 02, 2020 09:36 AM by YihuiSun
Sep 01, 2020 12:38 PM|ashvinvee|LINK
I am trying to read and display excel contents in asp.net mvc page.
After displaying the excel contents, i am trying to download the details in excel from the mvc view page. The excel contents downloaded needs to have formula intact.
Can someone provide solutions about how we could achieve this.
Sep 01, 2020 02:51 PM|bruce (sqlwork.com)|LINK
You use the open xml sdk to read and write office documents.
you will need to write code to display the excel sheet. The sdk will read the formulas, but not execute them. This will not be easy, so you will probably need to buy a solution.
the download is simple, just return a file with the correct content type and disposition.
Sep 02, 2020 09:36 AM|YihuiSun|LINK
Do you mean not only want to read or write data but also be able to read or write formulas?
You can install Syncfusion.XlsIO.AspNet.Mvc5 through NuGet to meet your needs.You can refer to
this document for detailed code.