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