// Pass in your data as a list of a list (2-D lists are equivalent to the 2-D spreadsheet structure) public string UpdateData(List <IList <object> > data) { String range = "My Tab Name!A1:Y"; string valueInputOption = "USER_ENTERED"; // The new values to apply to the spreadsheet. List <Google.Apis.Sheets.v4.Data.ValueRange> updateData = new List <Google.Apis.Sheets.v4.Data.ValueRange>(); var dataValueRange = new Google.Apis.Sheets.v4.Data.ValueRange(); dataValueRange.Range = range; dataValueRange.Values = data; updateData.Add(dataValueRange); Google.Apis.Sheets.v4.Data.BatchUpdateValuesRequest requestBody = new Google.Apis.Sheets.v4.Data.BatchUpdateValuesRequest(); requestBody.ValueInputOption = valueInputOption; requestBody.Data = updateData; var request = _sheetsService.Spreadsheets.Values.BatchUpdate(requestBody, _spreadsheetId); Google.Apis.Sheets.v4.Data.BatchUpdateValuesResponse response = request.Execute(); // Data.BatchUpdateValuesResponse response = await request.ExecuteAsync(); // For async return(JsonConvert.SerializeObject(response)); }
public string WriteInGoogleSS(List <IList <object> > data, int writtingRange) { String range = "HojaPacientes!A" + writtingRange.ToString() + ":B"; string valueInputOption = "USER_ENTERED"; // The new values to apply to the spreadsheet. List <Google.Apis.Sheets.v4.Data.ValueRange> updateData = new List <Google.Apis.Sheets.v4.Data.ValueRange>(); var dataValueRange = new Google.Apis.Sheets.v4.Data.ValueRange(); dataValueRange.Range = range; dataValueRange.Values = data; updateData.Add(dataValueRange); Google.Apis.Sheets.v4.Data.BatchUpdateValuesRequest requestBody = new Google.Apis.Sheets.v4.Data.BatchUpdateValuesRequest(); requestBody.ValueInputOption = valueInputOption; requestBody.Data = updateData; var request = service.Spreadsheets.Values.BatchUpdate(requestBody, SpreadsheetId); Google.Apis.Sheets.v4.Data.BatchUpdateValuesResponse response = request.Execute(); // Data.BatchUpdateValuesResponse response = await request.ExecuteAsync(); // For async return(JsonConvert.SerializeObject(response)); }