Module GoogleApps.Sheet

Access and modify spreadsheet sheets.

type spreadsheet
val open_spreadsheet : File.t -> spreadsheet
type t
val get_sheet_by_name : spreadsheet -> name:string -> t
val get_active_sheet : unit -> t
val get_last_row : t -> int
val get_last_column : t -> int
val get_sheet_values : t -> start_row:int -> start_column:int -> num_rows:int -> num_columns:int -> Ojs.t array array
val get_range : t -> start_row:int -> start_column:int -> num_rows:int -> num_columns:int -> Range.t
val get_data_range : t -> Range.t
val get_name : t -> string
val insert_row : t -> index:int -> t
val hide_row : t -> index:int -> unit
val show_row : t -> index:int -> unit
val hide_column : t -> index:int -> unit
val show_column : t -> index:int -> unit
val show_columns : t -> from:int -> num:int -> unit
type ui
type menu
val get_ui : unit -> ui
val show_sidebar : ui -> html:HtmlOutput.t -> unit
val create_menu : ui -> caption:string -> Menu.t
val alert : ui -> msg:string -> unit