public void InsertRows() { #region radspreadsheet-model-working-with-rows-and-columns-insert-and-remove_0 Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets.Add(); int index = 2; int itemCount = 3; if (worksheet.Rows.CanInsert(index, itemCount)) { RowSelection selection = worksheet.Rows[index, index + itemCount]; selection.Insert(); } #endregion }
private Workbook GenerateWorkBook() { this.headerRowCount = this.ShowColumnHeaders ? 1 : 0; this.headerRowCount += this.ChildrenOfType <GridViewColumnGroupRow>().Count(); Workbook workbook = null; workbook = this.ExportToWorkbook(); var worksheet = workbook.ActiveWorksheet; DataTemplate dt = this.HierarchyChildTemplate; DependencyObject dio = dt.LoadContent(); var childGrid = dio as RadGridView; foreach (var subItem in subItemsDictionary) { var rowIndex = subItem.Key; RowSelection selection = worksheet.Rows[rowIndex + 1, rowIndex + subItem.Value.Count]; selection.Insert(); for (var i = 0; i < subItem.Value.Count; i++) { var item = subItem.Value[i]; for (var j = 0; j < childGrid.Columns.Count; j++) { var column = childGrid.Columns[j] as GridViewDataColumn; var cell = worksheet.Cells[rowIndex + 1 + i, j]; var property = item.GetType().GetProperty(column.DataMemberBinding.Path.Path); var value = property != null?property.GetValue(item).ToString() : string.Empty; cell.SetValueAsText(value); var solidPatternFill = new PatternFill(PatternType.Solid, Color.FromArgb(255, 46, 204, 113), Colors.Transparent); cell.SetFill(solidPatternFill); } } } for (var j = 0; j < childGrid.Columns.Count; j++) { worksheet.Columns[j].AutoFitWidth(); } return(workbook); }
private Workbook GenerateWorkBook() { this.headerRowCount = this.ShowColumnHeaders ? 1 : 0; this.headerRowCount += this.ChildrenOfType <GridViewColumnGroupRow>().Count(); Workbook workbook = null; workbook = this.ExportToWorkbook(); var worksheet = workbook.ActiveWorksheet; worksheet.GroupingProperties.SummaryRowIsBelow = false; DataTemplate template = this.HierarchyChildTemplate; DependencyObject content = template.LoadContent(); var childGrid = content as RadGridView; var parentItemCount = 0; foreach (var parentItem in parentItemsDictionary) { var rowIndex = parentItem.ExportIndex + headerRowCount + parentItemCount + 1; parentItemCount++; RowSelection selection = worksheet.Rows[rowIndex, rowIndex + parentItem.SubItems.Count]; selection.Insert(); for (var j = 0; j < childGrid.Columns.Count; j++) { var column = childGrid.Columns[j] as GridViewDataColumn; var header = column.Header != null?column.Header.ToString() : column.DataMemberBinding.Path.Path; var headerCell = worksheet.Cells[rowIndex, j]; headerCell.SetValueAsText(header); var headerCellFill = new PatternFill(PatternType.Solid, Color.FromArgb(255, 150, 150, 150), Colors.Transparent); headerCell.SetFill(headerCellFill); headerCell.SetIsBold(true); for (var i = 0; i < parentItem.SubItems.Count; i++) { var item = parentItem.SubItems[i]; var cell = worksheet.Cells[rowIndex + 1 + i, j]; var property = item.GetType().GetProperty(column.DataMemberBinding.Path.Path); var value = property != null?property.GetValue(item).ToString() : string.Empty; cell.SetValueAsText(value); var subItemCellFill = new PatternFill(PatternType.Solid, Color.FromArgb(255, 46, 204, 113), Colors.Transparent); cell.SetFill(subItemCellFill); } } selection.Group(); var originalItem = this.Items[parentItem.OriginalIndex]; var isExpanded = (bool)originalItem.GetType().GetProperty("IsExpanded").GetValue(originalItem); if (!isExpanded) { selection.SetHidden(true); } } for (var j = 0; j < childGrid.Columns.Count; j++) { worksheet.Columns[j].AutoFitWidth(); } return(workbook); }