A convenience class for quickly creating a List of Cells To update. /// The Cells. /// Adds the cell. /// /// Gets the cells. /// /// Adds the cell. /// /// Returns the list of Cells. /// A convenience class for adding a Cell with the necessary fields for inserting into a list of Cells.
        private static void AddValuesToSheet(SmartsheetClient smartsheet, long sheetId, string query)
        {
            Sheet sheet = smartsheet.SheetResources.GetSheet(sheetId, null, null, null, null, null, null, null);
            long columnId = sheet.Columns[0].Id.Value;
            Cell cell = new Cell.AddCellBuilder(columnId, query).SetStrict(false).Build();
            Row[] rows = new Row[] { new Row.AddRowBuilder(true, null, null, null, false).SetCells(new Cell[] { cell }).Build() };

            smartsheet.SheetResources.RowResources.AddRows(sheetId, rows);
        }