Skip to content

Models

googleSheetsLib.models.InputOption = Literal['RAW', 'USER_ENTERED'] module-attribute

Determines how input data should be interpreted.

Values

RAW: The values the user has entered will not be parsed and will be stored as-is. USER_ENTERED: The values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc.

googleSheetsLib.models.InsertDataOption = Literal['INSERT_ROWS', 'OVERWRITE'] module-attribute

Determines how existing data is changed when new data is input.

Values

INSERT_ROWS: Rows are inserted for the new data. OVERWRITE: The new data overwrites existing data in the areas it covers.

googleSheetsLib.models.MajorDimension = Literal['ROWS', 'COLUMNS'] module-attribute

Indicates which dimension operations should apply to.

Values

ROWS: Operates on rows (horizontal). COLUMNS: Operates on columns (vertical).