Struct GoogleSheetsHandler 

pub struct GoogleSheetsHandler { /* private fields */ }

Handler for Google Sheets operations

Implementations

impl GoogleSheetsHandler

pub fn new() -> Self

Create a new Google Sheets handler

pub fn with_config(config: Config) -> Self

Create a new Google Sheets handler with custom config

pub fn parse_spreadsheet_id(&self, path: &str) -> Result<String>

Parse Google Sheets URL or ID to extract spreadsheet ID

pub fn parse_sheet_name(&self, path: &str) -> Option<String>

Parse sheet name from path

pub fn a1_to_row_col(&self, a1: &str) -> Result<(usize, usize)>

Convert A1 notation to row/column indices

pub fn row_col_to_a1(&self, row: usize, col: usize) -> String

Convert row/column indices to A1 notation

pub fn cell_range_to_a1( &self, range: &CellRange, sheet_name: Option<&str>, ) -> String

Convert CellRange to A1 notation range

pub fn list_sheet_titles(&self, spreadsheet_ref: &str) -> Result<Vec<String>>

List sheet titles for a spreadsheet using the Google Sheets API.

Requires google_sheets.api_key in Config (suitable for public spreadsheets when the Sheets API is enabled for the key).

Trait Implementations

impl Clone for GoogleSheetsHandler

fn clone(&self) -> Self

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl DataReader for GoogleSheetsHandler

fn read(&self, path: &str) -> Result<Vec<Vec<String>>>

Read all data from a file

fn read_with_headers(&self, path: &str) -> Result<Vec<Vec<String>>>

Read data with headers (first row contains column names)

fn read_range(&self, path: &str, range: &CellRange) -> Result<Vec<Vec<String>>>

Read a specific cell range from a file

fn read_as_json(&self, path: &str) -> Result<String>

Read data as JSON string

fn supports_format(&self, path: &str) -> bool

Check if the file format is supported

impl DataWriter for GoogleSheetsHandler

fn write( &self, path: &str, data: &[Vec<String>], options: DataWriteOptions, ) -> Result<()>

Write data to a file

fn write_range( &self, path: &str, data: &[Vec<String>], start_row: usize, start_col: usize, ) -> Result<()>

Write data to a specific cell range

fn append(&self, path: &str, data: &[Vec<String>]) -> Result<()>

Append data to an existing file

fn supports_format(&self, path: &str) -> bool

Check if the file format is supported

impl Default for GoogleSheetsHandler

fn default() -> Self

Returns the “default value” for a type.

impl FileHandler for GoogleSheetsHandler

fn format_name(&self) -> &'static str

Get the format name (e.g., “csv”, “xlsx”, “parquet”)

fn supported_extensions(&self) -> &'static [&'static str]

Get supported file extensions