private async Task CommitSignupRow(Sheet sheetToUpdate, RowData rowToUpdate, int rowIndex)
{
var sheetUpdates = new BatchUpdateSpreadsheetRequest();
sheetUpdates.Requests = new List <Request>()
{
new Request()
{
UpdateCells = new UpdateCellsRequest()
{
Start = new GridCoordinate()
{
SheetId = sheetToUpdate.Properties.SheetId, RowIndex = rowIndex, ColumnIndex = 0
},
Fields = "*",
Rows = new List <RowData>()
{
rowToUpdate
}
}
}
};
var updateRequest = new SpreadsheetsResource.BatchUpdateRequest(this.SheetsService, sheetUpdates, HeroicSheetsId);
await updateRequest.ExecuteAsync();
}
public async Task <BatchUpdateSpreadsheetResponse> RenameSheet(string spreadsheetId, int sheetId, string oldName, string newName)
{
var req = new BatchUpdateSpreadsheetRequest
{
Requests = new List <Request>
{
new Request
{
UpdateSheetProperties = new UpdateSheetPropertiesRequest
{
Properties = new SheetProperties
{
SheetId = sheetId,
Title = newName
}
}
}
}
};
SpreadsheetsResource.BatchUpdateRequest request = new SpreadsheetsResource.BatchUpdateRequest(_sheetsService, req, spreadsheetId);
var response = await request.ExecuteAsync();
return(response);
}
private async void HighlightCellAsync(int row, int col)
{
Google.Apis.Sheets.v4.Data.BatchUpdateSpreadsheetRequest requestBody = new Google.Apis.Sheets.v4.Data.BatchUpdateSpreadsheetRequest();
// Send a request that get the range, set the background color to highlight yellow, and set the date as today
requestBody.Requests = new List <Google.Apis.Sheets.v4.Data.Request>()
{
new Request()
{
RepeatCell = new RepeatCellRequest()
{
Range = new GridRange()
{
SheetId = this.SheetID,
StartRowIndex = row,
EndRowIndex = row + 1,
StartColumnIndex = col,
EndColumnIndex = col + 1
},
Cell = new CellData()
{
UserEnteredFormat = new CellFormat()
{
BackgroundColor = new Color()
{
Red = 1,
Green = 1,
Blue = 0
},
},
UserEnteredValue = new ExtendedValue()
{
StringValue = DateTime.Today.ToString("MM/dd/yyyy")
}
},
Fields = "userEnteredValue,userEnteredFormat.backgroundColor"
},
}
};
// Send the request
SpreadsheetsResource.BatchUpdateRequest request = Service.Spreadsheets.BatchUpdate(requestBody, this.SpreadSheetID);
Google.Apis.Sheets.v4.Data.BatchUpdateSpreadsheetResponse response = await request.ExecuteAsync();
Console.WriteLine(JsonConvert.SerializeObject(response));
}