u can make manipulate data in excel file in the same way u do with sql server or any other database. There will be only some minor changes. First of all, connection string will change. for e.g. ur excel file is "test.xlsx" in D drive, then:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\test.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES';
(Hope it works!! If it does not, then there are many more.)
Then u need to use OledbConnection
and similar classes for connectivity.
The table name will be the Sheet name with '$' sign at end.
For e.g. to select all rows from "Sheet1", query will be:
select * from [Sheet1$]
In similar way, to update:
update [Sheet1$] set Name = 'abc',Age = 15 where Id = 1
try this type of code and believe it will definately work. Works fine for me.
Happy coding.... :)