我的Coding之路

	//NPOI詳細的使用方式，就請看官網吧。
            HSSFWorkbook workbook = new HSSFWorkbook();
            MemoryStream ms = new MemoryStream();
            Sheet sheet = workbook.CreateSheet();

            //找到NPOI放置顏色的Type
            Type colorType = typeof(NPOI.HSSF.Util.HSSFColor);

            //找出此Type下公用的class
            var colorInstance = colorType.GetNestedTypes(BindingFlags.Public);

            int count = 0;
            foreach (var item in colorInstance)
            {
                //找出class下的靜態名為index的欄位
                var shortColor = item.GetField("index").GetValue(null);

                Row row = sheet.CreateRow(count);

                //第一種style，設字型的顏色
                CellStyle cellStyleFontColor = workbook.CreateCellStyle();
                Font font1 = workbook.CreateFont();
                font1.Color = (short)shortColor;
                cellStyleFontColor.SetFont(font1);

                //第二種style，設儲存格的前景色
                CellStyle cellStyleBg = workbook.CreateCellStyle();
                cellStyleBg.FillForegroundColor = (short)shortColor;
                cellStyleBg.FillPattern = FillPatternType.SOLID_FOREGROUND;



                row.CreateCell(0).CellStyle = cellStyleBg;

                Cell cell1 = row.CreateCell(1);
                cell1.CellStyle = cellStyleFontColor;
                cell1.SetCellValue("Test顏色");

                row.CreateCell(2).SetCellValue(item.Name);
                row.CreateCell(3).SetCellValue(shortColor.ToString());

                count++;
            }

            workbook.Write(ms);
            var file = File.Open(@"test.xls", FileMode.OpenOrCreate);
            file.Write(ms.ToArray(), 0, (int)ms.Length);
            
            workbook = null;
            ms.Close();
            ms.Dispose();
            file.Close();
            file.Dispose();