Skip to content

gaslamp


Function: readDataFrameFromSheet()

readDataFrameFromSheet(sheet, options?): BareFrame

Read DataFrame from Google Sheets Sheet.

Parameters

sheet

Sheet

Google Sheets Sheet object

options?

DataFrameSheetOptions = {}

Read options

Returns

BareFrame

New DataFrame instance

Example

TypeScript
const sheet = SpreadsheetApp.getActiveSheet();
const df = readDataFrameFromSheet(sheet, { header: true });
console.log(df.shape); // [rows, cols]

Deprecated

Will be deprecated in a future version.