protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평가기간 : " + ddlEstTerm.SelectedItem.Text + " / " + ddlEstTermSubID.SelectedItem.Text;
e.CurrentWorksheet.Rows[1].Cells[0].Value = "피평가부서 : " + ddlComDept.SelectedItem.Text;
e.CurrentWorksheet.Rows[2].Cells[0].Value = "평가차수 : " + ddlEstTermStepID.SelectedItem.Text;
e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Crimson;
}
protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평가기간 : " + ddlEstTermInfo.SelectedItem.Text;
e.CurrentWorksheet.Rows[1].Cells[0].Value = "평가조직 : " + txtDeptName.Text;
e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Crimson;
}
//导出前，设置导出的Excel样式等
public override void BeginExport(object sender, BeginExportEventArgs e)
{
//命名sheet，，现在只允许添加一个sheet，添加两个会报错
e.AddSheet("评论管理");
//设置列的宽度
//e.SetColumnWidth("评论时间", 150);
base.BeginExport(sender, e);
}
protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
Biz_EstInfos bizEstInfo = new Biz_EstInfos(this.ICOMP_ID, this.IEST_ID);
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평가기간 : " + ddlEstTermRefID.SelectedItem.Text;
e.CurrentWorksheet.Rows[1].Cells[0].Value = "평가명 : " + bizEstInfo.Est_Name;
//e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Crimson;
}
protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평 가 기 간 : " + (ddlEstTermInfo.SelectedItem.Text + " / " + ddlMonthInfo.SelectedItem.Text);
e.CurrentWorksheet.Rows[1].Cells[0].Value = "전 체 평 균 : " + dblAvg.ToString();
e.CurrentWorksheet.Rows[2].Cells[0].Value = "전체표준편차 : " + dblStd.ToString();
//e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Crimson;
//e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Height = 400;
// Add a caption with some more information
}
protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평가기간 : " + (ddlEstTermInfo.SelectedItem.Text + " / " + ddlEstTermMonth.SelectedItem.Text);
e.CurrentWorksheet.Rows[1].Cells[0].Value = "평가조직 : " + ltEstDeptName.Text;
e.CurrentWorksheet.Rows[2].Cells[0].Value = "조직비젼 : " + lblSTGMapName.Text;
e.CurrentWorksheet.Rows[3].Cells[0].Value = "BSC Champion : " + lblChampName.Text;
e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Crimson;
//e.CurrentWorksheet.Rows[0].Cells[0].CellFormat.Font.Height = 400;
// Add a caption with some more information
}
protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평가기간 : " + ddlEstTermInfo.SelectedItem.Text;
e.CurrentWorksheet.Rows[1].Cells[0].Value = "평가년월 : " + ddlMonthInfo.SelectedItem.Text;
//e.CurrentWorksheet.Rows[2].Cells[0].Value = "평가조직 : " + lblDeptName.Text;
//e.CurrentWorksheet.Rows[3].Cells[0].Value = "평가점수 : " + lblTotalScore.Text;
//e.CurrentWorksheet.Rows[4].Cells[0].Value = "조직비젼 : " + lblDeptVision.Text;
//e.CurrentWorksheet.Rows[5].Cells[0].Value = "BSC Champion : " + lblBSCChampion.Text;
for (int i = 0; i < 6; i++)
{
e.CurrentWorksheet.Rows[i].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Navy;
e.CurrentWorksheet.Rows[i].Cells[0].CellFormat.Font.Height = 250;
e.CurrentWorksheet.Rows[i].Height = 400;
}
}
protected void ugrdEEP_Rank_BeginExport(object sender, BeginExportEventArgs e)
{
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평가기간 : " + ddlEstTermInfo.SelectedItem.Text;
e.CurrentWorksheet.Rows[1].Cells[0].Value = "평가년월 : " + ddlMonthInfo.SelectedItem.Text;
e.CurrentWorksheet.Rows[2].Cells[0].Value = "조직유형 : " + PageUtility.GetByTextDropDownList(ddlComTypeInfo);
e.CurrentWorksheet.Columns[0].Width = 200;
e.CurrentWorksheet.Columns[1].Width = 600;
e.CurrentWorksheet.Columns[2].Width = 300;
e.CurrentWorksheet.Columns[3].Width = 200;
for (int i = 0; i < 3; i++)
{
e.CurrentWorksheet.Rows[i].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Navy;
e.CurrentWorksheet.Rows[i].Cells[0].CellFormat.Font.Height = 250;
e.CurrentWorksheet.Rows[i].Height = 400;
}
}
protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
e.CurrentWorksheet.Rows[0].Cells[0].Value = "평가기간 : " + ddlEstTermInfo.SelectedItem.Text;
e.CurrentWorksheet.Rows[1].Cells[0].Value = "평가년월 : " + ddlMonthInfo.SelectedItem.Text;
e.CurrentWorksheet.Rows[2].Cells[0].Value = "평가조직 : " + lblDeptName.Text;
e.CurrentWorksheet.Rows[3].Cells[0].Value = "평가점수 : " + lblTotalScore.Text;
e.CurrentWorksheet.Rows[4].Cells[0].Value = "순 위 : " + lblRank.Text + "/" + lblRankAll.Text;
e.CurrentWorksheet.Rows[5].Cells[0].Value = "등 급 : " + lblGrade.Text;
e.CurrentWorksheet.Rows[6].Cells[0].Value = "조직비젼 : " + lblDeptVision.Text;
e.CurrentWorksheet.Rows[7].Cells[0].Value = "BSC Champion : " + lblBSCChampion.Text;
for (int i = 0; i < 8; i++)
{
e.CurrentWorksheet.Rows[i].Cells[0].CellFormat.Font.Color = System.Drawing.Color.Navy;
e.CurrentWorksheet.Rows[i].Cells[0].CellFormat.Font.Height = 250;
e.CurrentWorksheet.Rows[i].Height = 400;
}
for (int i = 0; i < 12; i++)
{
int width = e.CurrentWorksheet.Columns[i].Width + 5;
e.CurrentWorksheet.Columns[i].Width = width * 900;
}
}
protected void ugrdEEP_BeginExport(object sender, BeginExportEventArgs e)
{
this.CommonDataPrint();
}
/// <summary>
/// 数据导出前事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public virtual void BeginExport(object sender, BeginExportEventArgs e)
{
}
