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

DotNet_Developer 1 Reputation point
2021-05-12T09:36:56.223+00:00

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.

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,279 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions