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();