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....supported for Zip archive. Therefore, for Zip archive method...