SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Function grep

    • Searches a workbook's text by pattern — its cells, and what is written off the grid.

      Parameters

      Returns Promise<GrepResult>

      Per sheet: the cells in reading order (a comment rides its cell), then the shapes and charts in reading order of their anchors. Defined names follow every sheet, since they belong to none.

      Deliberately shaped after ripgrep — args, defaults and vocabulary are pretrained, and every novel idiom is paid for in error loops.

      Hidden rows, columns and sheets are excluded by default (the .gitignore analogy — the user has already declared they are not looking at these); hidden includes them, and naming a hidden sheet in scope searches it.