NPOI技术导出Excel表格示例代码

记录ASP.NET系统，使用NPOI技术导出Excel表格的代码

记得项目导入NPOI的依赖喔，具体可问ChatGPT，这里我就不赘述了。

IWorkbook workbook = new HSSFWorkbook();   xls
IWorkbook workbook = new XSSFWorkbook();   xlsx

这里记录一个使用NPOI技术，导出并渲染Excel格式的方法，

public static void ExportByNPOI(GridView gridView, string path)
{
   
               
    HSSFWorkbook workbook = new HSSFWorkbook();
    ISheet sheet = workbook.CreateSheet("CostReport");

    try
    {
   
        #region 给Excel填充内容和样式

        #region 设置样式

        // 设置标头的样式
        ICellStyle styleHead = workbook.CreateCellStyle();
        IFont fontHead = workbook.CreateFont();
        fontHead.Boldweight = (short)FontBoldWeight.BOLD;
        fontHead.FontHeightInPoints = 12;
        fontHead.Color = IndexedColors.WHITE.Index;
        styleHead.SetFont(fontHead);
        styleHead.Alignment = HorizontalAlignment.CENTER;
        styleHead.VerticalAlignment = VerticalAlignment.CENTER;
        // 自定义颜色
        HSSFPalette palette = workbook.GetCustomPalette();
        // HSSFWorkbook 中，可以自定义的颜色索引范围通常是 8 到 63
        palette.SetColorAtIndex((short)10, 179, 202, 231);
        HSSFColor myColor = palette.FindColor(179, 202, 231);
        styleHead.FillForegroundColor = myColor.GetIndex();
        styleHead.FillPattern = FillPatternType.SOLID_FOREGROUND;               

        //设置背景间隔颜色，淡蓝色，奇数行
        ICellStyle styleBlue = workbook.CreateCellStyle();
        styleBlue.Alignment = HorizontalAlignment.CENTER;
        styleBlue.VerticalAlignment = VerticalAlignment.CENTER;
        styleBlue.DataFormat = workboo