110,566
社区成员
发帖
与我相关
我的任务
分享
//创建工作簿
var workbook = new NPOI.HSSF.UserModel.HSSFWorkbook();
//创建工作表
NPOI.HSSF.UserModel.HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet("sheet1");
//创建行
NPOI.HSSF.UserModel.HSSFRow row = (HSSFRow)sheet.CreateRow(0);
//创建单元格
NPOI.HSSF.UserModel.HSSFCell cell = (HSSFCell)row.CreateCell(0);
//给单元格赋值
cell.SetCellValue(Convert.ToDateTime("2008-01-12 18:20:30"));
//cell.DateCellValue = Convert.ToDateTime("2008-01-12 18:20:30");
//设置单元格格式
NPOI.HSSF.UserModel.HSSFCellStyle style = (HSSFCellStyle)workbook.CreateCellStyle();
NPOI.HSSF.UserModel.HSSFDataFormat format = (HSSFDataFormat)workbook.CreateDataFormat();
style.DataFormat = format.GetFormat("yyyy年mm月dd日");
cell.CellStyle = style;
//创建批注
HSSFPatriarch patr = (HSSFPatriarch)sheet.CreateDrawingPatriarch();
HSSFComment comment1 = (HSSFComment)patr.CreateCellComment(new HSSFClientAnchor(0, 0, 0, 0, 1, 2, 4, 8));
comment1.String = new HSSFRichTextString(@"这是一个批注测试!");
comment1.Author = @"DaLiu";
//comment1.Visible = true;
cell.CellComment = comment1;
FileStream fs = new FileStream(@"d:\a.xls", FileMode.OpenOrCreate, FileAccess.ReadWrite);
workbook.Write(fs);
fs.Close();
workbook = null;