hssfrow 单元格样式_用NPOI创建Excel、合并单元格、设置单元格样式、边框的方法...

(1).创建单元格字体的样式及大小

///

/// 获取字体样式

///

/// Excel操作类

/// 字体名

/// 字体颜色

/// 字体大小

///

public static IFont GetFontStyle(HSSFWorkbook hssfworkbook, string fontfamily, HSSFColor fontcolor, int fontsize)

{

IFont font1 = hssfworkbook.CreateFont();

if (string.IsNullOrEmpty(fontfamily))

{

font1.FontName = fontfamily;

}

if (fontcolor != null)

{

font1.Color = fontcolor.GetIndex();

}

font1.IsItalic = true;

font1.FontHeightInPoints = (short)fontsize;

return font1;

}

(2).设置单元格内显示数据的格式

ICell cell = row.CreateCell(1);

ICellStyle cellStyleNum = Excel.GetICellStyle(book);

IDataFormat formatNum = book.CreateDataFormat();

cellStyleNum.DataFormat = formatNum.GetF