code_junkie

Reading Excel in .NET, how to get row number?

Nov 12th, 2011
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
  2. using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connectionString)) {
  3. System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
  4. cmd.Connection = conn;
  5. cmd.CommandText = "SELECT top 13 City,State FROM [Cities$]";
  6.  
  7. conn.Open();
  8. System.Data.IDataReader dr = cmd.ExecuteReader();
  9.  
  10. int row = 2;
  11. while (dr.Read()) {
  12. if (row++ >= 4) {
  13. // do stuff
  14. Console.WriteLine("{0}, {1}", dr[0], dr[1]);
  15. }
  16. }
  17. }
Add Comment
Please, Sign In to add comment