//創建一個工作簿                XSSFWorkbook workbook = new XSSFWorkbook();                //創建一個頁                ISheet sheet = workbook.CreateSheet("sheet1");                //創建一行                IRow row = sheet.CreateRow(0);                //創建一列                ICell cell = row.CreateCell(0);

          ICellStyle style = workbook.CreateCellStyle();//創建樣式對象                IFont font = workbook.CreateFont(); //創建一個字體樣式對象                font.FontName = "方正舒體"; //和excel里面的字體對應                font.Color = new HSSFColor.PINK().GetIndex();//顏色參考NPOI的顏色對照表(替換掉PINK())                font.IsItalic = true; //斜體                font.FontHeightInPoints = 16;//字體大小                font.Boldweight = short.MaxValue;//字體加粗                style.SetFont(font); //將字體樣式賦給樣式對象
                cell.CellStyle = style; //把樣式賦給單元格

 ICellStyle style=workbook.CreateCellStyle(); style.FillForegroundColor = 14;  //具體數字代表的顏色看NPOI顏色對照表 style.FillPattern = FillPatternType.SOLID_FOREGROUND;