After finding Linq to excel I felt relax,
I use LinqtoExcel library to read data from the excel sheet.
imported linqtoexcel.dll into my application and use this statement in the controller,
var excel = new ExcelQueryFactory("C:\\Documents and Settings\\rk.prabakar\\Desktop\\test.xlsx");
var dataContent = from c in excel.Worksheet<CheckingAccount>()
Here the data are retrieved from the excel sheet and stored in datacontent variable.
if (dataContent != null)
foreach (var a in dataContent)
userId = Convert.ToInt16(Session["UserId"]);
accountName = a.AccountName;
acctDate = a.AccountOpenDate;
currBal = a.CurrentBalance;
_checkingtransactionservice.CreateCheckingTransaction(userId, accountName, acctDate, currBal);
Finally I got it.