Navin Kumar Sinha

Navin Kumar Sinha

  • 1.7k
  • 62
  • 3.6k

Excel cell data

Jun 22 2015 5:41 AM
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! 

Answers (2)