question

DotNetDeveloper-2634 avatar image
0 Votes"
DotNetDeveloper-2634 asked DuaneArnold-0443 commented

Need to Update and Read complex excel with too many formulas in c# dot net Web API

after update cell value in excel, the formula which depend on the updated cell, should get executed and then values of cells (which is in different sheets) needs to update automatically using c# and wep api. Once formula get executed, I want to access values from sheets which is updated using formulas.

I tried OpenXML, ClosedXML and even Microsoft.Office.Interop.Excel, but no luck.

Your help is highly appreciated.

Note: I am using xslm format file.

dotnet-csharpoffice-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What do you mean by you did some XML stuff? What do you mean? And how does ASP.NET WebAPI play a part in this?

0 Votes 0 ·

0 Answers