com.syntereen.gsheetj — com.syntereen/gsheetj 1.2.22

->ValueRange clj

(->ValueRange vec-of-vecs)

Convert a vector (rows) of vectors (cells) into a ValueRange suitable for Google Sheets.

append-sheet-range clj

(append-sheet-range
  sheets-service
  spreadsheet-id
  sheet-and-range
  data-values
  &
  {:keys [value-input-option insert-data-option include-values-in-response
          response-value-render-option response-date-time-render-option]})

Appends the specified range with the values specified. :value-input-option must be one of: "RAW" (as entered), "USER_ENTERED" (parsed as if entered in the UI). :insert-data-option must be one of: "OVERWRITE", "INSERT_ROWS". :include-values-in-response false (Do not return the new values. Default), true. :response-value-render-option can be one of: "FORMATTED_VALUE" (in the locale of the spreadsheet. Default.), "UNFORMATTED_VALUE", "FORMULA". response-date-time-render-option can be one of: "SERIAL_NUMBER" (Default.), "FORMATTED_STRING" (in the locale of the spreadsheet). Ignored if :response-value--render-option is "FORMATTED_VALUE".

clear-sheet-range clj

(clear-sheet-range sheets-service spreadsheet-id sheet-and-range)

Clears the specified range. Values only. No formatting is cleared.

get-sheet-range clj

(get-sheet-range sheets-service
                 spreadsheet-id
                 sheet-and-range
                 &
                 {:keys [value-render-option date-time-render-option]})

Return the range values as specified. :value-render-option can be one of: "FORMATTED_VALUE" (in the locale of the spreadsheet. Default.), "UNFORMATTED_VALUE", "FORMULA". date-time-render-option can be one of: "SERIAL_NUMBER" (Default.), "FORMATTED_STRING" (in the locale of the spreadsheet).

update-sheet-range clj

(update-sheet-range sheets-service
                    spreadsheet-id
                    sheet-and-range
                    data-values
                    &
                    {:keys [value-input-option include-values-in-response
                            response-value-render-option
                            response-date-time-render-option]})

Updates the specified range with the values specified. :value-input-option must be one of: "RAW" (as entered), "USER_ENTERED" (parsed as if entered in the UI). :include-values-in-response false (Do not return the new values. Default), true. :response-value-render-option can be one of: "FORMATTED_VALUE" (in the locale of the spreadsheet. Default.), "UNFORMATTED_VALUE", "FORMULA". response-date-time-render-option can be one of: "SERIAL_NUMBER" (Default.), "FORMATTED_STRING" (in the locale of the spreadsheet). Ignored if :response-value--render-option is "FORMATTED_VALUE".