Search string (Word) in Excel file using C# and VB.Net in ASP.Net

Question

Hi TeamI want to search string word came from search textbox in excel fileIf the word match then i want to return a value as Text found on labelThanks

dharmendr · Accepted Answer

Hi  WaghmareFor reading Excel i have used ClosedXML Library Refer below link for detailsRead and Import Excel data to DataTable using ClosedXml in ASPNet with C and VBNetCheck this example Now please take its reference and correct your codeHTMLltaspTextBox runat34server34 ID34txtSearchTerm34 gtltaspButton Text34Search34 runat34server34 OnClick34Search34 gtltbr gtltaspLabel ID34lblText34 runat34server34 gtNamespacesCusing ClosedXMLExcelVBNetImports ClosedXMLExcelCodeCprotected void Searchobject sender EventArgs e    string filePath  ServerMapPath34FilesExcelxlsx34    using XLWorkbook workBook  new XLWorkbookfilePath             Read the first Sheet from Excel file        IXLWorksheet workSheet  workBookWorksheet1         Loop through the Worksheet rows        foreach IXLRow row in workSheetRows                     Loop through the cells of each row

dharmendr · Answer

Hi WaghmareCheck this example Now please take its reference and correct your codeHTMLltaspTextBox runat34server34 ID34txtSearchTerm34 gtltaspButton ID34Button134 Text34Search34 runat34server34 OnClick34Search34 gtltbr gtltaspLabel ID34lblText34 runat34server34 gtNamespacesCusing Excel  MicrosoftOfficeInteropExcelVBNetImports Excel  MicrosoftOfficeInteropExcelCodeCprotected void Searchobject sender EventArgs e    string filePath  ServerMapPath34FilesExcelxlsx34    ExcelApplication application  new ExcelApplication    ExcelWorkbook workBook  applicationWorkbooksOpenfilePath    ExcelWorksheet worksheet  ExcelWorksheetworkBookWorksheets1    ExcelRange xlRange  worksheetUsedRange    int rowCount  xlRangeRowsCount    int colCount  xlRangeColumnsCount    for int i  1 i lt rowCount i            for int j  1 j lt colCount j

Search string (Word) in Excel file using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us