How to get formula from excel sheet to server side in asp.net

Posted by Shoyebaziz123 under ASP.NET on 7/5/2014 | Points: 10 | Views : 427 | Status : [Member] | Replies : 3
Hello All,

There is a requirement for us to draw a graph ( power , linear, exponential, etc) and based on that graph generate equation .

I write the code for that by passing my data to excel sheet and generating graph all of the things working fine , formula is also generated , now my problem is that how to get this formula value at my server side code. please help me




Responses

Posted by: Vuyiswamb on: 7/6/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
So basically you want to retrieve a Formula from Excel ?


Thank you for posting at Dotnetfunda
[Administrator]

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shoyeb on: 7/7/2014 [Member] Starter | Points: 25

Up
0
Down
Hello,

yes i need formula or formula value at our server side code.

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 7/7/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
then this should work

formula = worksheet.Cells(1, 1).Formula


Thank you for posting at Dotnetfunda
[Administrator]

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response