protected void ugrdEEP_EndExport(object sender, EndExportEventArgs e) { for (int i = 0; i < ugrdMBO.Rows.Count; i++) { e.CurrentWorksheet.Rows[i + 5].Cells[0].Value = ugrdMBO.Rows[i].Cells.FromKey("STATUS_NAME").Value.ToString(); } }
protected void ugrdEEP_EndExport(object sender, EndExportEventArgs e) { e.CurrentWorksheet.Columns[0].Width = 3000; e.CurrentWorksheet.Columns[0].CellFormat.Alignment = HorizontalCellAlignment.Center; e.CurrentWorksheet.Columns[1].Width = 6000; e.CurrentWorksheet.Columns[2].Width = 2500; e.CurrentWorksheet.Columns[2].CellFormat.Alignment = HorizontalCellAlignment.Center; e.CurrentWorksheet.Columns[3].Width = 3000; e.CurrentWorksheet.Columns[3].CellFormat.Alignment = HorizontalCellAlignment.Center; e.CurrentWorksheet.Columns[4].Width = 2500; e.CurrentWorksheet.Columns[4].CellFormat.Alignment = HorizontalCellAlignment.Center; e.CurrentWorksheet.Columns[5].Width = 2500; e.CurrentWorksheet.Columns[5].CellFormat.Alignment = HorizontalCellAlignment.Center; for (int i = 7; i < 19; i++) { e.CurrentWorksheet.Columns[i].Width = 6000; } }
protected void ugrdEEP_EndExport(object sender, EndExportEventArgs e) { int j = ugrdMScore.Columns.Count; for (int i = 0; i < ugrdMScore.Columns.Count; i = i + 3) { e.CurrentWorksheet.Rows[5].Cells[i].Value = ugrdMScore.Bands[0].HeaderLayout[j].Caption; e.CurrentWorksheet.MergedCellsRegions.Add(5, i, 5, i + 2); e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.Alignment = Infragistics.Documents.Excel.HorizontalCellAlignment.Center; e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.FillPattern = Infragistics.Documents.Excel.FillPatternStyle.Solid; e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.FillPatternForegroundColor = System.Drawing.ColorTranslator.FromHtml("#94BAC9"); e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.Font.Color = System.Drawing.Color.White; e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.BottomBorderColor = e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.TopBorderColor = e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.RightBorderColor = e.CurrentWorksheet.Rows[5].Cells[i].CellFormat.LeftBorderColor = System.Drawing.ColorTranslator.FromHtml("#C7C7C7"); j++; e.CurrentWorksheet.Columns[i + 2].Width = 2000; } }