Excel cell data

Navin Kumar Sinha

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 [2,4],[2,6] etc

pls guide asap..

Thankyou guys!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
http://csharp.net-informations.com/excel/csharp-read-excel.htm
Upendra Pratap Shahi11y ago
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/