class GoogleSpreadsheets::Worksheet

Defined in:

Constructors

Class Method Summary

Instance Method Summary

Constructor Detail

def self.new(id, title, index, sheet_type, spreadsheet, properties) #

Class Method Detail

def self.from_json(spreadsheet, data : JSON::Any) #

Instance Method Detail

def append(data, range : String = "A1", major_dimension = MajorDimension::ROWS) #

def append(data : Hash(String, CellInput), range : String = "A1") #

def before_reading #

def before_updating #

def clear(data_filters : Array(DataFilter)) #

def clear(ranges : Array(String)) #

def clear(range : String) #

def column_to_letters(column : Int32) #

def get(filters : Array(DataFilter), major_dimension = MajorDimension::ROWS) #

def get(ranges : Array(String), major_dimension = MajorDimension::ROWS) #

def get(range, major_dimension = MajorDimension::ROWS) #

def id : Int64 #

def id=(id : Int64) #

def index : Int32 #

def index=(index : Int32) #

def sheet_type : String #

def sheet_type=(sheet_type : String) #

def spreadsheet : Spreadsheet #

def spreadsheet=(spreadsheet : Spreadsheet) #

def title : String #

def title=(title : String) #

def titles(range : String) #

def update(range, data, *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED) #

def update(value_range : ValueRange, *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED) #

def update(value_ranges : Array(ValueRange), *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED) #

def update(value_ranges : Array(DataFilterValueRange), *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED) #