Answer 1

Hello, sbuddhika !
Till now i am trying to take cell values directly to variables, now i will try to take cell values to an array using Range. Thanks!!!! – Teja Varma 13 mins ago

No. I didn't even mean that :) As I mentioned in the comment that you can store the entire range in an array. That doesn't mean that you need to loop though each cell to store it in an array. You can directly assign the values of the range to the array. See this example.

xlRng = xlWorkSheet.get_Range("A1", "A20"); Object arr = xlRng.Value; foreach (object s in (Array)arr) { MessageBox.Show(s.ToString()); }
https://stackoverflow.com/questions/16213255/how-to-read-cell-values-from-existing-excel-file