public static AppendValuesResponse AppendRowLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.AppendRequest> onRequest, params object[] rowValues)
{
var values = new List <IList <object> >
{
rowValues.ToList()
};
return(service.AppendRange(spreadsheetId, range, onRequest, values));
}
public static AppendValuesResponse AppendColumnLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.AppendRequest> onRequest, params object[] columnValues)
{
// convert columnValues to columList
var columList = columnValues.Select(v => new List <object> {
v
});
// Add columList to values and input to valueRange
var values = new List <IList <object> >();
values.AddRange(columList.ToList());
return(service.AppendRange(spreadsheetId, range, onRequest, values));
}
public IActionResult AppendRange(AppendRangeDto range)
{
return(CheckSheetExist(range.Sheetname, () =>
{
var result = SheetsService.AppendRange(
GoogleSheetsApi.SpreadSheetId,
SheetRange.ToRange(range.Sheetname, range.Range),
request =>
{
request.InsertDataOption = Google.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.AppendRequest.InsertDataOptionEnum.INSERTROWS;
},
range.Values);
return Ok(result);
}));
}
