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