class GoogleSpreadsheets::Worksheet

• GoogleSpreadsheets::Worksheet
• Reference
• Object

Defined in:

google_spreadsheets.cr

Constructors

• .new(id : Int64, title : String, index : Int32, sheet_type : String, spreadsheet : GoogleSpreadsheets::Spreadsheet, properties : GoogleSpreadsheets::GridProperties)

Class Method Summary

• .from_json(spreadsheet, data : JSON::Any)

Instance Method Summary

• #append(data : Hash(String, CellInput), range : String = "A1")
• #append(data, range : String = "A1", major_dimension = MajorDimension::ROWS)
• #before_reading
• #before_updating
• #clear(range : String)
• #clear(ranges : Array(String))
• #clear(data_filters : Array(DataFilter))
• #column_to_letters(column : Int32)
• #get(ranges : Array(String), major_dimension = MajorDimension::ROWS)
• #get(filters : Array(DataFilter), major_dimension = MajorDimension::ROWS)
• #get(range, major_dimension = MajorDimension::ROWS)
• #id : Int64
• #id=(id : Int64)
• #index : Int32
• #index=(index : Int32)
• #sheet_type : String
• #sheet_type=(sheet_type : String)
• #spreadsheet : Spreadsheet
• #spreadsheet=(spreadsheet : Spreadsheet)
• #title : String
• #title=(title : String)
• #titles(range : String)
• #update(range, data, *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED)
• #update(value_range : ValueRange, *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED)
• #update(value_ranges : Array(ValueRange), *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED)
• #update(value_ranges : Array(DataFilterValueRange), *, major_dimension = MajorDimension::ROWS, value_input_option = ValueInputOption::USER_ENTERED)

Constructor Detail

Class Method Detail

Instance Method Detail