| Tip | ||
|---|---|---|
| ||
Prerequisite
Google Spreadsheet ID and Sheet Id.
|
1. Return Value (CSV) headers
...
2. Plugin operations and required parameters
Operations | Parameters | Output |
|---|
Read a Spreadsheet | Spreadsheet Id | Values from the cell range of the sheet in form of CSV. |
Sheet Range (e.g. Sheet1!A1:B3, sheetname!A1) | ||
Create a Spreadsheet | Spreadsheet Name | Spreadsheet Id |
Write a Spreadsheet | Spreadsheet Id |
Spreadsheet Id | ||
Sheet Range | ||
Excel/CSV File *Only accept .xslx or .csv format | ||
Inputfile Sheet *Sheetname of input excel file | ||
Rename a Spreadsheet | Spreadsheet Id | Spreadsheet Id |
Spreadsheet Name |
Add a Sheet | Spreadsheet Id |
Sheet Id, Spreadsheet Id | ||
Sheet Name | ||
Sheet Id (optional): Integer e.g. 123 | ||
Delete a Sheet | Spreadsheet Id | Sheet Id, Spreadsheet Id |
Sheet Id: The sheet id to delete | ||
Rename a Sheet | Spreadsheet Id |
Sheet Id, Spreadsheet Id | |
Sheet Id: The sheet id to rename | |
Sheet Name | |
Duplicate a Sheet | Spreadsheet Id |
Newssheet Id, oldsheet Id, Spreadsheet Id | ||
Sheet Id: The sheet id to be duplicated | ||
Sheet Name | ||
Find and Replace | Spreadsheet Id | Sheet Id, Spreadsheet Id |
3. Example of the plugin in STU
...