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....Usage / Extract data from various formats / Extract data from...Excel spreadsheets method is used. This method returns the collection...