NPOI格式设置1

using NPOI.SS.UserModel;

using NPOI.HSSF.UserModel;   

//创建Execl

IWorkbook hssfworkbook =new HSSFWorkbook();   

//创建一个Sheet

hssfworkbook.CreateSheet("Sheet1");   

//HSSFWorkbook实例写入文件

FileStream file = new FileStream(@"test.xls", FileMode.Create);

hssfworkbook.Write(file);

file.Close();   

//要创建单元格首先要创建单元格所在的行，比如，下面的代码创建了第0行：

ISheet sheet1 = hssfworkbook.CreateSheet("Sheet1");

IRow row1=sheet1.CreateRow(0);   

//行建好了，就可以建单元格了，比如创建A1位置的单元格：

row1.CreateCell(0).SetCellValue("This is a Sample");   

//或者sheet1.GetRow(0).CreateCell(0).SetCellValue("This is a Sample");   

//set header text 设置页眉

s1.Header.Center = "This is a test sheet";

//set footer text 设置页脚

s1.Footer.Left = "Copyright NPOI Team";

s1.Footer.Right = "created by 123";   

//set date format 设置单元格格式

ICellStyle cellStyle = hssfworkbook.CreateCellStyle();

IDataFormat format = hssfworkbook.CreateDataFormat();

cellStyle.DataFormat = format.GetFormat("yyyy年m月d日");

//cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("0.00"); 单元格格式为“0.00”来表示,"￥#,##0"美元显示,"0.00%"百分比显示

cell.CellStyle=cellStyle;  

//合并单元格

IRow row = sheet.CreateRow(0);

ICell cell = row.CreateCell(0);

cell.SetCellValue("Sales Report");

ICellStyle style = hssfworkbook.CreateCellStyle();

style.Alignment = HorizontalAlignment.CENTER;

IFont font = hssfworkbook.CreateFont();

font.FontHeight = 20*20;

style.SetFont(font);

cell.CellStyle = style;

sheet.AddMergedRegion(new Region(0, 0, 0, 5));
巴特西

NPOI格式设置1

最新文章

热门文章
