elixir_google_spreadsheets v0.1.1 GSS.Spreadsheet

Model of Google Spreadsheet for external interaction.

Maximum size of the supported canvas is 1000 x 26 cells.

Summary

State of currently active Google spreadsheet:

%{
    spreadsheet_id => "16Wgt0fuoYDgEAtGtYKF4jdjAhZez0q77UhkKdeKI6B4"
}

Clear rows in spreadsheet by their index

id(pid)

Client API calls

spreadsheet_data()

spreadsheet_data() :: [String.t]

spreadsheet_response()

spreadsheet_response() :: {:json, map} | {:error, Exception.t}

state()

state() :: map

State of currently active Google spreadsheet:

%{
    spreadsheet_id => "16Wgt0fuoYDgEAtGtYKF4jdjAhZez0q77UhkKdeKI6B4"
}

append_row(pid, row_index, column_list, options \\ [])

append_row(pid, Integer, spreadsheet_data, Keyword.t) :: :ok

clear_row(pid, row_index, options \\ [])

clear_row(pid, Integer, Keyword.t) :: :ok

fetch(pid, range)

fetch(pid, String.t) ::
  {:ok, spreadsheet_data} |
  {:error, Exception.t}

handle_call(msg, from, state)

Clear rows in spreadsheet by their index.

id(pid)

id(pid) :: String.t

Client API calls.

properties(pid)

properties(pid) :: map

range(row_from, row_to, column_from, column_to)

range(Integer, Integer, Integer, Integer) :: String.t

read_row(pid, row_index, options \\ [])

read_row(pid, Integer, Keyword.t) ::
  {:ok, spreadsheet_data} |
  {:error, Exception.t}

rows(pid)

rows(pid) :: {:ok, Integer} | {:error, Exception.t}

start_link(spreadsheet_id)

start_link(String.t) :: {:ok, pid}

start_link(spreadsheet_id, name)

start_link(String.t, atom) :: {:ok, pid}

write_row(pid, row_index, column_list, options \\ [])

write_row(pid, Integer, spreadsheet_data, Keyword.t) :: :ok