public static UpdateValuesResponse UpdateRowLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.UpdateRequest> onRequest, params object[] rowValues)
{
var values = new List <IList <object> >
{
rowValues.ToList()
};
return(service.UpdateRange(spreadsheetId, range, onRequest, values));
}
public IActionResult UpdateRange(AppendRangeDto range)
{
return(CheckSheetExist(range.Sheetname, () =>
{
var result = SheetsService.UpdateRange(
GoogleSheetsApi.SpreadSheetId,
new SheetRange(range.Sheetname, range.Range).ToRange(),
request => { },
range.Values);
return Ok(result);
}));
}
public static UpdateValuesResponse UpdateColumnLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.UpdateRequest> 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.UpdateRange(spreadsheetId, range, onRequest, values));
}
