private void CreateHeader()
        {
            int           columnNumber   = 0;
            var           orderedColumns = columns.OrderBy(x => x.ColumnOrder);
            var           row            = currentSheet.CreateRow(currentRowNumber);
            ExportToExcel exportToExcel  = new ExportToExcel();

            foreach (var column in orderedColumns)
            {
                row.CreateCell(columnNumber, NPOI.SS.UserModel.CellType.String);
                var cellt = GetColumnCellType(column.PropType);
                row.Cells[columnNumber].SetCellValue(column.ColumnName);
                currentSheet.SetColumnWidth(columnNumber, (int)((column.ColumnName.Length * 1.5) * 256));
                SetHeaderOptions(column, row, columnNumber, exportToExcel);
                ++columnNumber;
            }
        }
        private void SetHeaderOptions(SimpleExcelExport.Column column, NPOI.SS.UserModel.IRow row, int columnNumber, ExportToExcel exportToExcel)
        {
            HSSFCellStyle style = (HSSFCellStyle)document.CreateCellStyle();
            var           font  = document.CreateFont();

            if (column.HFontBold)
            {
                font.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;
            }
            if (!string.IsNullOrEmpty(column.HFontColor))
            {
                System.Drawing.Color fontColor = exportToExcel.GetColor(column.ColumnName, column.HFontColor, typeof(string));
                if (!fontColor.IsEmpty)
                {
                    font.Color = GetXLColour(fontColor);
                }
            }
            if (!string.IsNullOrEmpty(column.HBackColor))
            {
                System.Drawing.Color backgroundColor = exportToExcel.GetColor(column.ColumnName, column.HBackColor, typeof(string));
                if (!backgroundColor.IsEmpty)
                {
                    style.FillForegroundColor = GetXLColour(backgroundColor);
                    style.FillPattern         = NPOI.SS.UserModel.FillPattern.SolidForeground;
                }
            }
            style.SetFont(font);
            row.Cells[columnNumber].CellStyle = style;
        }