public static Data.UpdateValuesResponse UpdateSpreadsheet(string spreadsheetId, string range, SheetsService service, MyData dataObject)
{
Data.ValueRange requestBody = new Data.ValueRange();
requestBody.Values = ConvertObjectToList(dataObject);
//Create update request
SpreadsheetsResource.ValuesResource.UpdateRequest request = service.Spreadsheets.Values.Update(requestBody, spreadsheetId, range);
request.ValueInputOption = (SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum) 2;
Console.WriteLine("Updating range " + range + " in spreadsheet...");
//Execute the request
Data.UpdateValuesResponse response = request.Execute();
return(response);
}
public static Data.AppendValuesResponse AppendSpreadsheet(string spreadsheetId, string range, SheetsService service, MyData dataObject)
{
Data.ValueRange requestBody = new Data.ValueRange();
//Request Body consists of data to be appended
requestBody.Range = range;
requestBody.MajorDimension = "ROWS";
requestBody.Values = ConvertObjectToList(dataObject);
//Update Headers w.r.t the dataObject
UpdateHeadersInSpreadsheet(spreadsheetId, service, GetHeaders());
//Create append request
SpreadsheetsResource.ValuesResource.AppendRequest request = service.Spreadsheets.Values.Append(requestBody, spreadsheetId, range);
request.ValueInputOption = (SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum) 2;
Console.WriteLine("Appending to spreadsheet...");
//Execute the request
Data.AppendValuesResponse response = request.Execute();
return(response);
}
