LINKIN_12

LINKIN_12

  • NA
  • 10
  • 0

help reading from excel

Aug 12 2004 11:21 AM
hi, I really need help I am currently using an OLEDBCONNECTION to access an excel spreadsheet but I want to access specific cells without defining a name to the cells in the excel spreadsheet. For example I wanto to be able to get info from cell C5, and then update the data on cell D6. How can I do this? this is part of the code I am currently using. OleDbConnection cnExcel = new OleDbConnection(sbConn.ToString()); cnExcel.Open(); OleDbCommand cmdExcel = new OleDbCommand("Select * From Info",cnExcel); OleDbDataReader drExcel = cmdExcel.ExecuteReader();

Answers (1)