asp.net mvc read / write Excel with formula

Question

User-1961814522 posted

Hi all,

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.

Thanks,

Ashvin

Answer 1

User-474980206 posted

You use the open xml sdk to read and write office documents.

    https://docs.microsoft.com/en-us/office/open-xml/open-xml-sdk

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.

Answer 2

User1686398519 posted

Hi ashvinvee,

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.

• sheet.Range["C1"].Formula;//Read Formula

Best Regards,

YihuiSun