Class GoogleSheets
Provides an interface for syncing localization data to a Google Sheet.
Assembly: Unity.Localization.Editor.dll
Syntax
public class GoogleSheets
Constructors
Properties
Methods
Name |
Description |
AddSheet(string, NewSheetProperties)
|
Creates a new sheet within the Spreadsheet with the id SpreadSheetId.
|
CreateSpreadsheet(string, string, NewSheetProperties, ITaskReporter)
|
Creates a new Google Spreadsheet.
|
ExecuteRequestAsync<TResponse, TClientServiceRequest>(TClientServiceRequest)
|
|
ExecuteRequest<TResponse, TClientServiceRequest>(TClientServiceRequest)
|
|
GetColumnTitles(int)
|
Returns all the column titles(values from the first row) for the selected sheet inside of the Spreadsheet with id SpreadSheetId.
This method requires the SheetsService to use OAuth authorization as it uses a data filter which reuires elevated authorization.
|
GetRowCount(int)
|
Returns the total number of rows in the sheet inside of the Spreadsheet with id SpreadSheetId.
This method requires the SheetsService to use OAuth authorization as it uses a data filter which reuires elevated authorization.
|
GetRowCountAsync(int)
|
Asynchronous version of GetRowCount(int)
Returns the total number of rows in the sheet inside of the Spreadsheet with id SpreadSheetId.
This method requires the SheetsService to use OAuth authorization as it uses a data filter which reuires elevated authorization.
|
GetSheets()
|
Returns a list of all the sheets in the Spreadsheet with the id SpreadSheetId.
|
OpenSheetInBrowser(string)
|
Opens the spreadsheet in a browser.
|
OpenSheetInBrowser(string, int)
|
Opens the spreadsheet with the sheet selected in a browser.
|
PullIntoStringTableCollection(int, StringTableCollection, IList<SheetColumn>, bool, ITaskReporter, bool)
|
Pulls data from the Spreadsheet with id SpreadSheetId and uses columnMapping
to populate the collection .
|
PushStringTableCollection(int, StringTableCollection, IList<SheetColumn>, ITaskReporter)
|
Extracts data from collection using columnMapping and sends it to the sheet
inside of the Spreadsheet with id SpreadSheetId.
This method requires the SheetsService to use OAuth authorization as an API Key does not have the ability to write to a sheet.
|
PushStringTableCollectionAsync(int, StringTableCollection, IList<SheetColumn>, ITaskReporter)
|
Asynchronous version of PushStringTableCollection(int, StringTableCollection, IList<SheetColumn>, ITaskReporter)
Extracts data from collection using columnMapping and sends it to the sheet
inside of the Spreadsheet with id SpreadSheetId.
This method requires the SheetsService to use OAuth authorization as an API Key does not have the ability to write to a sheet.
|
SendBatchUpdateRequest(string, params Request[])
|
|
SendBatchUpdateRequest(string, IList<Request>)
|
|
SendBatchUpdateRequestAsync(string, IList<Request>)
|
|
Did you find this page useful? Please give it a rating:
Thanks for rating this page!
What kind of problem would you like to report?
Thanks for letting us know! This page has been marked for review based on your feedback.
If you have time, you can provide more information to help us fix the problem faster.
Provide more information
You've told us this page needs code samples. If you'd like to help us further, you could provide a code sample, or tell us about what kind of code sample you'd like to see:
You've told us there are code samples on this page which don't work. If you know how to fix it, or have something better we could use instead, please let us know:
You've told us there is information missing from this page. Please tell us more about what's missing:
You've told us there is incorrect information on this page. If you know what we should change to make it correct, please tell us:
You've told us this page has unclear or confusing information. Please tell us more about what you found unclear or confusing, or let us know how we could make it clearer:
You've told us there is a spelling or grammar error on this page. Please tell us what's wrong:
You've told us this page has a problem. Please tell us more about what's wrong:
Thank you for helping to make the Unity documentation better!
Your feedback has been submitted as a ticket for our documentation team to review.
We are not able to reply to every ticket submitted.