using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; /// /// HwndExcelMuliHeader의 요약 설명입니다. /// public class HwndExcelMuliHeader { Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs _beginExportevent = null; public HwndExcelMuliHeader(Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs e) { _beginExportevent = e; } public void setExcelFormat_DefaultSet() { setExcelFormat_DefaultSet(_beginExportevent); } public void setExcelFormat_DefaultSet(Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs e) { e.CurrentWorksheet.Rows[1].Cells[0].Value = DateTime.Now.ToString("yyyy-MM-dd"); e.CurrentWorksheet.Rows[2].CellFormat.Alignment = Infragistics.Excel.HorizontalCellAlignment.Center; e.CurrentWorksheet.Rows[2].CellFormat.VerticalAlignment = Infragistics.Excel.VerticalCellAlignment.Center; } public void setExcelFormat_MergedHeaderRow(int[] ColumnList, int StartRow, int EndRow) { setExcelFormat_MergedHeaderRow(ColumnList, StartRow, EndRow, _beginExportevent); } public void setExcelFormat_MergedHeaderRow(int[] ColumnList, int StartRow, int EndRow, Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs e) { foreach (int spanItem in ColumnList) e.CurrentWorksheet.MergedCellsRegions.Add(StartRow, spanItem, EndRow, spanItem); } public void setExcelFormat(int StartIndex, int EndIndex, int RowIndex, string Value) { setExcelFormat(StartIndex, EndIndex, RowIndex, Value, _beginExportevent); } public void setExcelFormat(int StartIndex, int EndIndex, int RowIndex, string Value, Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs e) { e.CurrentWorksheet.MergedCellsRegions.Add(RowIndex, StartIndex, RowIndex, EndIndex); e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.FillPattern = Infragistics.Excel.FillPatternStyle.Solid; e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.FillPatternForegroundColor = System.Drawing.Color.FromArgb(0xCBD6A6); e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.LeftBorderColor = System.Drawing.Color.FromArgb(0xAAB883); e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.LeftBorderStyle = Infragistics.Excel.CellBorderLineStyle.Default; e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.RightBorderColor = System.Drawing.Color.FromArgb(0xAAB883); e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.RightBorderStyle = Infragistics.Excel.CellBorderLineStyle.Default; e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.TopBorderColor = System.Drawing.Color.FromArgb(0xAAB883); e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.TopBorderStyle = Infragistics.Excel.CellBorderLineStyle.Default; e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.BottomBorderColor = System.Drawing.Color.FromArgb(0xAAB883); e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].CellFormat.BottomBorderStyle = Infragistics.Excel.CellBorderLineStyle.Default; e.CurrentWorksheet.Rows[RowIndex].Cells[StartIndex].Value = Value; } }