GoogleSheet
Classes
- Columns
- GoogleSheetExtractor
- SheetRange
from_google_sheet()
from_google_sheet(array{type: string, project_id: string, private_key_id: string, private_key: string, client_email: string, client_id: string, auth_uri: string, token_uri: string, auth_provider_x509_cert_url: string, client_x509_cert_url: string}|Sheets $auth_config, string $spreadsheet_id, string $sheet_name[, bool $with_header = true ][, int $rows_per_page = 1000 ][, array{dateTimeRenderOption?: string, majorDimension?: string, valueRenderOption?: string} $options = [] ]) : Extractor
Parameters
-
$auth_config
: array{type: string, project_id: string, private_key_id: string, private_key: string, client_email: string, client_id: string, auth_uri: string, token_uri: string, auth_provider_x509_cert_url: string, client_x509_cert_url: string}|Sheets
-
-
$spreadsheet_id
: string
-
-
$sheet_name
: string
-
-
$with_header
: bool
= true
-
- @deprecated use withHeader method instead
-
$rows_per_page
: int
= 1000
-
- how many rows per page to fetch from Google Sheets API - @deprecated use withRowsPerPage method instead
-
$options
: array{dateTimeRenderOption?: string, majorDimension?: string, valueRenderOption?: string}
= []
-
- @deprecated use withOptions method instead
from_google_sheet_columns()
from_google_sheet_columns(array{type: string, project_id: string, private_key_id: string, private_key: string, client_email: string, client_id: string, auth_uri: string, token_uri: string, auth_provider_x509_cert_url: string, client_x509_cert_url: string}|Sheets $auth_config, string $spreadsheet_id, string $sheet_name, string $start_range_column, string $end_range_column[, bool $with_header = true ][, int $rows_per_page = 1000 ][, array{dateTimeRenderOption?: string, majorDimension?: string, valueRenderOption?: string} $options = [] ]) : Extractor
Parameters
-
$auth_config
: array{type: string, project_id: string, private_key_id: string, private_key: string, client_email: string, client_id: string, auth_uri: string, token_uri: string, auth_provider_x509_cert_url: string, client_x509_cert_url: string}|Sheets
-
-
$spreadsheet_id
: string
-
-
$sheet_name
: string
-
-
$start_range_column
: string
-
-
$end_range_column
: string
-
-
$with_header
: bool
= true
-
- @deprecated use withHeader method instead
-
$rows_per_page
: int
= 1000
-
- how many rows per page to fetch from Google Sheets API, default 1000 - @deprecated use withRowsPerPage method instead
-
$options
: array{dateTimeRenderOption?: string, majorDimension?: string, valueRenderOption?: string}
= []
-
- @deprecated use withOptions method instead