Search text in Microsoft Office Excel spreadsheets

View as MarkdownMarkdown

Set up your AI agent

Give your coding agent live access to the GroupDocs documentation and API reference through the GroupDocs Docs MCP server — no install, no API key. Learn more

claude mcp add --transport http groupdocs-docs https://docs.groupdocs.com/mcp

Also process documents locally

The GroupDocs.Parser MCP server lets your agent work with files on your machine; they are never uploaded. It runs in Docker: replace /path/to/documents with the folder it may use.

claude mcp add groupdocs-parser -- docker run --rm -i -v /path/to/documents:/data ghcr.io/groupdocs-parser/parser-net-mcp:latest
Folders, licensing and more →

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. For example, text extraction isn’t supported for Zip archive. Therefore, for Zip archive search(String) method returns null. For empty Microsoft Office Excel spreadsheet search(String) method returns an empty collection.

The following example shows how to find a keyword in Microsoft Office Excel spreadsheet:

// Create an instance of Parser class
try (Parser parser = new Parser(Constants.SampleXlsx)) {
    // Search a keyword:
    Iterable<SearchResult> sr = parser.search("Age");
    // Iterate over search results
    for (SearchResult s : sr) {
        // Print an index and found text:
        System.out.println(String.format("At %d: %s", s.getPosition(), s.getText()));
    }
}

search(String, SearchOptions) method is used for the advanced search in Microsoft Office Excel spreadsheets - like search with regular expressions, search by pages etc. SearchOptions parameter is used to customize a search.

Here are the steps to search with a regular expression in Microsoft Office Excel spreadsheet:

The following example shows how to search with a regular expression in Microsoft Office Excel spreadsheet:

// Create an instance of Parser class
try (Parser parser = new Parser(Constants.SampleXlsx)) {
    // Search with a regular expression with case matching
    Iterable<SearchResult> sr = parser.search("[0-9]+", new SearchOptions(true, false, true));
    // Iterate over search results
    for (SearchResult s : sr) {
        // Print an index and found text:
        System.out.println(String.format("At %d: %s", s.getPosition(), s.getText()));
    }
}

More resources

GitHub examples

You may easily run the code above and see the feature in action in our GitHub examples:

Free online document parser App

Along with full featured .NET library we provide simple, but powerful free Apps.

You are welcome to parse documents and extract data from PDF, DOC, DOCX, PPT, PPTX, XLS, XLSX, Emails and more with our free online Free Online Document Parser App.