public async Task AppendRangeAsync(string range, IList <IList <object> > data, AppendRequest.ValueInputOptionEnum valueInputOption = AppendRequest.ValueInputOptionEnum.RAW, AppendRequest.InsertDataOptionEnum insertInputOption = AppendRequest.InsertDataOptionEnum.INSERTROWS ) { this.logger.LogTrace($"Putting values into range {range}..."); var request = this.CreateAppendRangeRequest(range, data, valueInputOption, insertInputOption); var result = await request.ExecuteAsync(); this.logger.LogTrace($"When appending range {range}, actual range: {result.Updates.UpdatedRange}"); }
public AppendRequest CreateAppendRangeRequest(string range, IList <IList <object> > data, AppendRequest.ValueInputOptionEnum valueInputOption = AppendRequest.ValueInputOptionEnum.RAW, AppendRequest.InsertDataOptionEnum insertInputOption = AppendRequest.InsertDataOptionEnum.INSERTROWS ) { var appendResource = this.valuesResource.Append(new ValueRange { Values = data }, this.SpreadsheetId, range); appendResource.ValueInputOption = valueInputOption; appendResource.InsertDataOption = insertInputOption; return(appendResource); }
public void AppendToSheet(Note note, string spreadsheetID, string sheetRange, string attachmentsFolderLink) { string spreadsheetId = spreadsheetID; string range = sheetRange; AppendRequest.ValueInputOptionEnum valueInputOption = AppendRequest.ValueInputOptionEnum.USERENTERED; AppendRequest.InsertDataOptionEnum insertDataOption = AppendRequest.InsertDataOptionEnum.INSERTROWS; var arr = new string[] { note.NoteType, note.NoteContent, note.NoteRecordtime, attachmentsFolderLink }; RequestBody.Values = new List <IList <object> > { arr }; Request = service.Spreadsheets.Values.Append(RequestBody, spreadsheetId, range); Request.ValueInputOption = valueInputOption; Request.InsertDataOption = insertDataOption; Request.Execute(); }