Breaking changes in the Sheets keywords. All actions/properties
related to a whole spreadsheet will use spreadsheet name and sheet will
be used to indicate a single sheet in a spreadsheet. This is to be consistent
with Google API naming.
Add new keywords:
Copy spreadsheet - copy existing spreadsheet into another spreadsheet
Create spreadsheet - create a new spreadsheet
Delete sheet - delete existing sheet with a given spreadsheet id
Generic spreadsheet batch update - keyword used internally by the library which allows a lot of operations to be done with a given spreadsheet (see keyword documentation)
Get all sheet values - returns all sheet values (the range is determined from sheet information) about a given spreadsheet id and sheet name (optional, default is the first sheet).
Get spreadsheet basic information - returns a dictionary (title, id, url, sheets) about a given spreadsheet id.
Get spreadsheet details - returns basic information plus for example sheet formatting information about a given spreadsheet id.
Rename sheet - rename the existing sheet with a given spreadsheet id with a different name
To column letter - converts the number (for a column) and converts it to a column letter, for example 30 to column letter AD
Repurposed keywords
Copy sheet (now will copy a sheet within a spreadsheet)
Create sheet (now will create a sheet within a spreadsheet)
WARNING
Breaking changes in the
Sheetskeywords. All actions/properties related to a whole spreadsheet will usespreadsheetname andsheetwill be used to indicate a single sheet in a spreadsheet. This is to be consistent with Google API naming.Add new keywords:
Copy spreadsheet- copy existing spreadsheet into another spreadsheetCreate spreadsheet- create a new spreadsheetDelete sheet- delete existing sheet with a given spreadsheet idGeneric spreadsheet batch update- keyword used internally by the library which allows a lot of operations to be done with a given spreadsheet (see keyword documentation)Get all sheet values- returns all sheet values (the range is determined from sheet information) about a given spreadsheet id and sheet name (optional, default is the first sheet).Get spreadsheet basic information- returns a dictionary (title, id, url, sheets) about a given spreadsheet id.Get spreadsheet details- returns basic information plus for example sheet formatting information about a given spreadsheet id.Rename sheet- rename the existing sheet with a given spreadsheet id with a different nameTo column letter- converts the number (for a column) and converts it to a column letter, for example 30 to column letter ADRepurposed keywords
Copy sheet(now will copy a sheet within a spreadsheet)Create sheet(now will create a sheet within a spreadsheet)