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();
}
