Skip to content
Sheetwrite

Sheetwrite / Documentation

SearchOptions@sheetwrite/core

Case, whole-cell, sheet, and column constraints for grid search.
@sheetwrite/coreinterface

Case, whole-cell, sheet, and column constraints for grid search.

Package
@sheetwrite/core
Source
packages/core/src/types/grid.ts#L301

Members 4

matchCase Case-sensitive match (default false). 
matchCase?: boolean;
wholeCell Match only when the whole cell text equals the query (default false: substring). 
wholeCell?: boolean;
sheet Restrict to a sheet (defaults to the active sheet). 
sheet?: SheetId;
columns Restrict to these column indices (defaults to all columns). 
columns?: number[];

Declaration

View full TypeScript declaration 
export interface SearchOptions {
  matchCase?: boolean;
  wholeCell?: boolean;
  sheet?: SheetId;
  columns?: number[];
}