DUCK，Fearless！

顯示有逗號區分的數值資料

HSSFCellStyle styleNumeric = (HSSFCellStyle)workbook.CreateCellStyle();

HSSFDataFormat format = (HSSFDataFormat)workbook.CreateDataFormat();

styleNumeric.DataFormat =format.GetFormat("###,##0");

cell.CellStyle = styleNumeric;

顯示百分比符號 

HSSFCellStyle stylePercent = (HSSFCellStyle)workbook.CreateCellStyle();

HSSFDataFormat format = (HSSFDataFormat)workbook.CreateDataFormat();

stylePercent.DataFormat = format.GetFormat("#0.00%");

cell.CellStyle = stylePercent;

顯示日期格式

HSSFCellStyle styleDate = (HSSFCellStyle)workbook.CreateCellStyle();

HSSFDataFormat format = (HSSFDataFormat)workbook.CreateDataFormat();

styleDate.DataFormat = format.GetFormat("yyyy-mm-dd");

cell.CellStyle = styleDate;

對儲存格做合併,
假如我們要合併儲存格A0:B0,
並設定一個style參數給合併後的儲存格,需注意每個儲存格(如A0與B0)皆需設定style參數,否則不會有作用.如下設定:

sheetA.AddMergedRegion(new NPOI.HSSF.Util.Region(0, 0, 0, 1));
sheetA.GetRow(0).GetCell(0).CellStyle = styleTitle;
sheetA.GetRow(0).GetCell(1).CellStyle = styleTitle;

參考來源
http://horacerobot.blogspot.com/2010/07/npoi-create-excel-advice.html