Thanks for providing us some details and sample code.
Well, I am afraid, MS Excel only allows to search data present in cell, it does not include multiple cells’ data within the rows/columns by inserting it into “Find What” Text box in one go for its search criteria. If you do find such an option in MS Excel to accomplish your task in MS Excel manually, let us know with details, sample file and steps involved, we will check it soon. Aspose.Cells follows MS Excel standards and specifications, so if Ms Excel does not allow this, Aspose.Cells also cannot accomplish the task in one go. I think you may write your own code to try to search those cells (one by one) using your search criteria (see the document for your reference here: http://www.aspose.com/docs/display/cellsjava/Find+or+Search+Data ) and get the relevant row index/number (by using Cell.getRow()/getColumn method(s)) to store into some arrays/list, so you may find out the underlying rows/cols which contains your desired data into different cells.
I tied below code for filtering, but it just select the test8 in first column filter, but didnt get applied on that column. It shows me all rows in worksheet. If I open the 1st col filter then only test8 value is selected. So it means filter get selected but not get applied.
I am expecting one row, but getting all rows with 1st col filter selected value test8.
Does I need to invoke any other method to get apply that selected filter
Workbook workbook = new Workbook(“D:\ASPOSE\Book1.xlsx”);
Well, to find the row index/number you need to use Find and Search options provided by Aspose.Cells APIs as you were doing previously. All you need to do is specify your area where the search would be done and you would search the string/text with respect to your find options. Once you find the cell, you will use Cell.getRow() method to get the row index/number of the searched row. See the sample code segment below for your reference.
e.g
Sample code:
…
//Specify the area range. e.g B2 to last data cell in B column;