How to use Excel Function Argument Dialog in C#.net.

Question

I would like to take the function name Argument name and value from Excel cell using c#.net

Amit Choudhary · Answer

hi you can go to the following article: http://support.microsoft.com/kb/302084 i hope it'll help you a lot. so don't forget to mark it

Amit Choudhary · Answer

hi friend Following code will help you in calling formula to the relative cells in excel using function. see following code: //Fill C2:C6 with a relative formula (=A2 &   & B2). oRng = oSheet.get_Range(C2 C6); oRng.Formula = =A2 & \ \ & B2; //Fill D2:D6 with a formula(=RAND()*100000) and apply format. oRng = oSheet.get_Range(D2 D6); oRng.Formula = =RAND()*100000; oRng.NumberFormat = $0.00; Mark the answer if it helps.

How to use Excel "Function Argument" Dialog in C#.net.