Find function aspose cells java


#1

Please let me know if we can search cell values using find function with conditions like >21, <30 etc
is there any property in FindOptions let me know.


#2

@genpact,

Thanks for your query.

Aspose.Cells Find/Search options works the same way as per MS Excel. How could you perform the task using Find options in MS Excel? I am not sure if there is no feasibility available in Find options.

The best way to cope with is is, we think you should iterate cells to find those matched ones in the spreadsheet. For example, you may use the Iterator API which can be got from Cells to search cells with your custom criteria, it is efficient way too.

By the way, if you only need to format those cells (which passes the conditions), you may try to use conditional formattings.