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.
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
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
Participant
1911 Points
443 Posts
Re: searching excel from asp.net
Jul 12, 2010 11:33 AM|beharavenkata@gmail.com|LINK
Nanda