public IActionResult AppendColumnLine(AppendColumnDto column)
{
return(CheckSheetExist(column.Sheetname, () =>
{
var result = SheetsService.AppendColumnLine(
GoogleSheetsApi.SpreadSheetId,
SheetRange.ToRange(column.Sheetname, column.Range),
request => { },
column.Line);
return Ok(result);
}));
}
public IActionResult GetRowLine(string sheetname, string range)
{
return(CheckSheetExist(sheetname, () =>
{
var result = SheetsService.ReadRange(GoogleSheetsApi.SpreadSheetId,
SheetRange.ToRange(sheetname, range),
r =>
{
r.MajorDimension = SpreadsheetsResource.ValuesResource.GetRequest.MajorDimensionEnum.ROWS;
});
return Ok(result);
}));
}
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);
}));
}