Excel cell data

Question

my query is: I have to map the excel cell value to database not the whole excel file this is simple ok.. but how can i map specific cell with database column? my effort: i have retrieved all the data from excel sheet by Select * from [Sheet1$]; and then stored in dataset(ds)  so can i retrieve particular value from cell by this one +ds.Tables[0].Rows[0][ExcelColumn]+ or should i map each cell by indexing like [24][26] etc pls guide asap.. Thankyou guys!

Upendra Pratap Shahi · Answer

http://csharp.net-informations.com/excel/csharp-read-excel.htm

Upendra Pratap Shahi · Answer

string path = @C:\ProjectTesting\TwsDde.xlsm; oXL = new Microsoft.Office.Interop.Excel.Application(); oXL.Visible = true; oXL.DisplayAlerts = false; mWorkBook = oXL.Workbooks.Open(path 0 false 5   false Microsoft.Office.Interop.Excel.XlPlatform.xlWindows  true false 0 true false false); //Get all the sheets in the workbook mWorkSheets = mWorkBook.Worksheets; //Get the allready exists sheet mWSheet1 = (Microsoft.Office.Interop.Excel.Worksheet)mWorkSheets.get_Item(Basic Orders); Microsoft.Office.Interop.Excel.Range range= mWSheet1.UsedRange; mWSheet1.Cells[12 1] = bla bla bla; This code was taken from this article which also goes on to save the excel sheet: http://rmanimaran.wordpress.com/2011/02/15/programmatically-insert-to-existing-excel-file-using-c/