Free Support Forum -

Search String in Sheet from a particular row number

Hi, I want to search some content in a sheet. I am using Cells().findString method. But i have a requirement where i want to search the string from a particular row number. for example search the string from row number 5. Is there a way to do it?

Thanks & Regards,

Rohan Naik


I think, you can use the find string that searches inside a particular area. Here are these two such overloads that could be helpful.

Cells - API

findString(java.lang.StringinputString, CellpreviousCell, CellAreaarea)

Finds the cell with the input string in the specified area.

findString(java.lang.StringinputString, CellpreviousCell, CellAreaarea, booleanupDown)

Finds the cell with the input string in the specified area.



Rohan Naik


Thanks for your posting.

Please download and use the latest version:

Aspose.Cells for Java 7.3.3

We have now introduced some new API(s) and classes to find/search data. findString() method is now deprecated.

Please check the following document for your reference.

Please also download and try the Offline - Aspose.Cells for Java Demos for working examples.