How to get a range of Excel Cell using c#...?

See more:

C#

MS-Excel

I have create a Excel Workbook version is 97-2003 using c# code.

Now i have also write the code for inserting the record into Excel Sheet using c# code and i have also update that record, all this functionality performed successfully.
but when i try to delete the record it will gives error that

"Deleting data in a linked table is not supported by this ISAM"

I can use a oledb connection to perform insert, update, delete.

how can solve this error to perform deletion operation on excel.

or

one more thing i want to get the cell range where the selected values is located it will be using c# code...
like if i want to get the cell range where the value of id is 8 then it will show like that 'A8'

please help me..