private static GoogleSheetAppendRequest CreateAppendRequest(string sheetName, int columnKey, string valueKey,
int columnStart, object[] values)
{
var row = new GoogleSheetRow();
var countColumns = Math.Max(columnKey, columnStart + values.Length);
for (int i = 0; i < countColumns; i++)
{
row.Add(null);
}
for (int i = 0; i < values.Length; i++)
{
row[i + columnStart] = GoogleSheetCell.Create(values[i]);
}
row[columnKey] = GoogleSheetCell.Create(valueKey);
var request = new GoogleSheetAppendRequest(sheetName)
{
Rows = { row },
};
return(request);
}
private Request CreateAppendRequest(GoogleSheetAppendRequest r)
{
var sheetId = GetSheetId(r.SheetName);
if (sheetId == null)
{
throw new ArgumentException($"Не найдена таблица {r.SheetName}");
}
var listRowData = new List <RowData>();
var request = new Request
{
AppendCells = new AppendCellsRequest
{
SheetId = sheetId,
Rows = listRowData,
Fields = "*",
},
};
foreach (var row in r.Rows)
{
var listCellData = new List <CellData>();
foreach (var cell in row)
{
var cellData = CreateCellData(cell);
listCellData.Add(cellData);
}
var rowData = new RowData()
{
Values = listCellData
};
listRowData.Add(rowData);
}
return(request);
}
