To search a keyword in Microsoft Office Excel spreadsheets search(String) method is used. This method returns the collection of SearchResult objects. For details, see Search Text.
Here are the steps to search a keyword in Microsoft Office Excel spreadsheet:
Instantiate Parser object for the initial spreadsheet; Call search(String) method and obtain the collection of SearchResult objects; Iterate through the collection and get the position and text. Warning search(String) method returns null value if search isn’t supported for the spreadsheet....like search with regular expressions, search by pages etc. parameter...to search with a regular expression in Microsoft Office Excel...