searching excel from asp.net RSS

• • Reply
  malek.safa

  Member

  37 Points

  73 Posts

  searching excel from asp.net

  Jul 12, 2010 06:34 AM|malek.safa|LINK

  hello i need some help trying to search an excel file from asp.net using vb language.

  I have an excel sheet that contains Items (1st column) and amount (2nd column), i want to get the amount for the corresponding Item, eg: in the web page i insert in the textbox the name of the item and i want to go into the excel file to the specific row of the amount.

   

  thx

   

• • Reply
  satalaj

  Contributor

  6678 Points

  2004 Posts

  Re: searching excel from asp.net

  Jul 12, 2010 11:23 AM|satalaj|LINK

  Hi,
   You can open excel file using Oledb provider and fire query like select * from sheetName where FieldName = 'xxx'  etc.
  http://www.revenmerchantservices.com/post/2009/08/08/c-read-excel-xlsx-2007.aspx
  

  How to send email without account || Html5 database connection
  
  
  
  
• • Reply
  beharavenkat...

  Participant

  1911 Points

  443 Posts

  Re: searching excel from asp.net

  Jul 12, 2010 11:33 AM|beharavenkata@gmail.com|LINK

  System.Data.OleDb.OleDbConnection db = new System.Data.OleDb.OleDbConnection();
              string path = @"C:\projects\Book1.xlsx";
              db.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";
              db.Open();
  
  
              System.Data.OleDb.OleDbDataAdapter dba = new System.Data.OleDb.OleDbDataAdapter("select * from [sheet1$]",db);
              System.Data.DataTable dt = new DataTable();
              dba.Fill(dt);
  
  
              foreach(DataRow dr in dt.Rows)
                  Console.Write(dr["ItemName"]);

  
  
  

  Please 'Mark as Answer' if my reply helped you..
  Nanda