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....spreadsheets - like search with regular expressions, search by pages etc...steps to search with a regular expression in Microsoft Office Excel...