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....Conversion Product Solution GroupDocs...documents and extract data from PDF, DOC, DOCX, PPT, PPTX, XLS, XLSX...