حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Import Excel data with Formula to table in ASP.Net

Barathan

hi sir,

how to dynamically import excel sheet formula to table using oledbConnection.

example:

A B C D

1 2 3 = SUM(A1+B1+C1)

i want to Dynamically import 'D' values with formula to table

dharmend...

0 2

Refer the below link.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Import Excel data with Range and Formula using ClosedXML in ASP.Net