How to search in Excel 2007 (not csv) through C# code ?

Question

I have column A B C D

how to search in Excel (not csv) if "test" in column A - and if found

I want to receive A B C D column's

thanks for any help

Answer 1

If you're working client-side (i.e. your code run on user machine), you can to use Excel API, like describe here: How to: Search for Text in Worksheet Ranges

Server-side (like in an ASP.NET application) it's a bit harder, as usually you can't install Microsoft Office on servers. So you can open your XLSX file by using an OpenXML API and to search it manually.

Answer 2

if you use something like aspose on your server (which we do...) you don't need to directly interact with excel (so no excel server installation is required) but it is a tad pricey.