Read multiple cells value of Different Sheets in Excel RSS

• • Reply
  

  prashantdigh...

  Member

  101 Points

  56 Posts

  Read multiple cells value of Different Sheets in Excel

  Nov 08, 2012 06:41 AM|LINK

  Hi All,

  I have some unique requirement that with OleDb connection , I need read the data(value) of more than one cell of different sheet in singal query.

  I looked on some site but I found only update query for that as follows

  String sConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\Book1.xls;Extended Properties='Excel 8.0;HDR=NO'";
          OleDbConnection objConn = new OleDbConnection(sConnectionString);
          objConn.Open();
          OleDbCommand objCmdSelect = new OleDbCommand("UPDATE [Sheet1$A2:A2] SET F1=123456", objConn);
          objCmdSelect.ExecuteNonQuery();
          objCmdSelect = new OleDbCommand("UPDATE [Sheet1$A4:A4] SET F1='hello'", objConn);
          objCmdSelect.ExecuteNonQuery();
          objCmdSelect = new OleDbCommand("UPDATE [Sheet1$A5:A5] SET F1='goodby'", objConn);
          objCmdSelect.ExecuteNonQuery();

  I want some similar code for select query with multiple values of different sheets

   

  Please help Thanks in Advanced.....

• • Reply
  

  geniusvishal

  Star

  14266 Points

  2810 Posts

  Re: Read multiple cells value of Different Sheets in Excel

  Nov 08, 2012 11:01 AM|LINK

  Use select command instead of update..

  Refer this link:

  http://stackoverflow.com/questions/509749/loading-excel-column-data-using-c-sharp-in-a-dropdown-menu

  Vishal Ranjan
  
  My Website
  www.dotnetvishal.com
  
  • Marked as answer by Amy Peng - MSFT on Nov 16, 2012 01:02 AM