protected void RadGrid1_BiffExporting(object sender, GridBiffExportingEventArgs e) { xls.Table tbl = e.ExportStructure.Tables[0]; //tbl.Rows[1].Height = 30; tbl.Columns[1].Width = 25; tbl.Columns[1].Style.HorizontalAlign = HorizontalAlign.Left; tbl.Columns[2].Width = 25; tbl.Columns[2].Style.HorizontalAlign = HorizontalAlign.Left; tbl.Columns[3].Width = 25; tbl.Columns[3].Style.HorizontalAlign = HorizontalAlign.Left; tbl.Columns[4].Width = 35; tbl.Columns[4].Style.HorizontalAlign = HorizontalAlign.Left; }
private void GenerateTable(RadGrid grid, xls.Table singleTable) { if (ExportingType.SelectedValue == "1") { singleTable = new xls.Table(grid.ID); row = 1; col = 1; } else { if (!isFirstItem) { row++; } else { isFirstItem = false; } } GridHeaderItem headerItem = grid.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem; for (int i = 2; i < headerItem.Cells.Count; i++) { singleTable.Cells[i - 1, row].Value = headerItem.Cells[i].Text; } row++; foreach (GridDataItem item in grid.MasterTableView.Items) { foreach (GridColumn column in grid.Columns) { singleTable.Cells[col, row].Value = item[column.UniqueName].Text; col++; } col = 1; row++; } if (ExportingType.SelectedValue == "1") { structure.Tables.Add(singleTable); } }
private void GenerateTable(RadGrid grid, xls.Table singleTable) { if (ExportingType.SelectedValue == "1") { singleTable = new xls.Table(grid.ID); row = 1; col = 1; } else { if (!isFirstItem) row++; else isFirstItem = false; } GridHeaderItem headerItem = grid.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem; for (int i = 2; i < headerItem.Cells.Count; i++) { singleTable.Cells[i - 1, row].Value = headerItem.Cells[i].Text; } row++; foreach (GridDataItem item in grid.MasterTableView.Items) { foreach (GridColumn column in grid.Columns) { singleTable.Cells[col, row].Value = item[column.UniqueName].Text; col++; } col = 1; row++; } if (ExportingType.SelectedValue == "1") { structure.Tables.Add(singleTable); } }
private void GenerateTable(RadGrid grid, xls.Table singleTable) { if (ExportingType.SelectedValue == "1") { singleTable = new xls.Table(grid.ID); singleTable.Title = grid.ID; row = 2; col = 1; } else { if (!isFirstItem) { row++; } else { row = 2; } isFirstItem = false; } GridHeaderItem headerItem = grid.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem; int[] sizearr = new int[15]; for (int i = 2; i < headerItem.Cells.Count; i++) { //singleTable.InsertImage(new Range("A1", "B2"), "../Images/Company_Logo/ADNOC.png"); singleTable.Cells[2, row - 1].Value = grid.ID; singleTable.Cells[2, row - 1].Style.ForeColor = System.Drawing.Color.GreenYellow; singleTable.Cells[2, row - 1].Style.Font.Size = 18; singleTable.Cells[2, row - 1].Style.Font.Bold = true; singleTable.Rows[row - 1].Height = 30; singleTable.Cells[3, 1].Value = " Date : " + DateTime.Now.ToString("dddd, dd MMMM yyyy h:mm tt"); singleTable.Cells[3, row - 1].Style.ForeColor = System.Drawing.Color.Red; singleTable.Rows[row].Height = 25; singleTable.Cells[i - 1, row].Value = headerItem.Cells[i].Text.Replace("_", " "); singleTable.Cells[i - 1, row].Style.BackColor = System.Drawing.Color.LightGray; singleTable.Cells[i - 1, row].Style.Font.Bold = true; singleTable.Cells[i - 1, row].Style.Font.Size = 10; singleTable.Cells[i - 1, row].Style.BorderLeftStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderRightStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderBottomStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderTopStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderRightColor = System.Drawing.Color.Black; singleTable.Cells[i - 1, row].Style.BorderTopColor = System.Drawing.Color.Black; singleTable.Cells[i - 1, row].Style.BorderLeftColor = System.Drawing.Color.Black; singleTable.Cells[i - 1, row].Style.BorderBottomColor = System.Drawing.Color.Black; } row++; foreach (GridDataItem item in grid.MasterTableView.Items) { foreach (GridColumn column in grid.MasterTableView.AutoGeneratedColumns) { singleTable.Cells[col, row].Value = item[column.UniqueName].Text.Replace(" ", ""); singleTable.Cells[col, row].Style.BorderLeftStyle = BorderStyle.Outset; singleTable.Cells[col, row].Style.BorderRightStyle = BorderStyle.Outset; singleTable.Cells[col, row].Style.BorderBottomStyle = BorderStyle.Outset; singleTable.Cells[col, row].Style.BorderTopStyle = BorderStyle.Outset; singleTable.Cells[col, row].Style.BorderRightColor = System.Drawing.Color.Black; singleTable.Cells[col, row].Style.BorderTopColor = System.Drawing.Color.Black; singleTable.Cells[col, row].Style.BorderLeftColor = System.Drawing.Color.Black; singleTable.Cells[col, row].Style.BorderBottomColor = System.Drawing.Color.Black; col++; } col = 1; row++; } GridFooterItem FooterItem = grid.MasterTableView.GetItems(GridItemType.Footer)[0] as GridFooterItem; for (int i = 2; i < FooterItem.Cells.Count; i++) { singleTable.Rows[row].Height = 25; singleTable.Cells[i - 1, row].Value = FooterItem.Cells[i].Text.Replace("_", " ").Replace(" ", ""); singleTable.Cells[i - 1, row].Style.BackColor = System.Drawing.Color.LightBlue; singleTable.Cells[i - 1, row].Style.Font.Bold = true; singleTable.Cells[i - 1, row].Style.Font.Size = 10; singleTable.Cells[i - 1, row].Style.BorderLeftStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderRightStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderBottomStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderTopStyle = BorderStyle.Outset; singleTable.Cells[i - 1, row].Style.BorderRightColor = System.Drawing.Color.Black; singleTable.Cells[i - 1, row].Style.BorderTopColor = System.Drawing.Color.Black; singleTable.Cells[i - 1, row].Style.BorderLeftColor = System.Drawing.Color.Black; singleTable.Cells[i - 1, row].Style.BorderBottomColor = System.Drawing.Color.Black; } row++; row++; if (ExportingType.SelectedValue == "1") { structure.Tables.Add(singleTable); } }