这个问题研究了不少时间,希望可以帮助到大家
//错误的关键就在这儿,因为模板里的某个单元格有个斜线,这个人斜线就是绘图工具画出来的,所以在这里已经存在DrawingPatriarch,每个文本里只能有
//一个DrawingPatriarch,所以EXCEL不能正常显示了,关于绘图工具是否存在用sheet.DrawingPatriarch 属性是否为null就可以,目前没有找到清空这个的
//方法,我的解决办法就是,把模板里的斜线这种类似图片的元素清空,就没问题了
HSSFPatriarch patr1 = sheet.CreateDrawingPatriarch() as HSSFPatriarch;
HSSFComment comment1 = patr1.CreateCellComment(new HSSFClientAnchor(0, 0, 0, 0, 1, 3, 3, 7)) as HSSFComment;
comment1.String = new HSSFRichTextString("作者:\n0");
HSSFCell hssfcell1 = sheet.CreateRow(5).CreateCell(1) as HSSFCell;
hssfcell1.CellComment=comment1;
HSSFPatriarch patr2 = sheet.CreateDrawingPatriarch() as HSSFPatriarch;
HSSFComment comment2 = patr2.CreateCellComment(new HSSFClientAnchor(5, 0, 5, 0, 2, 3, 4,8)) as HSSFComment;
comment2.String = new HSSFRichTextString("\n1");
comment1.Author = "Wicrosoft";
HSSFCell Hssfcell2 = sheet.CreateRow(5).CreateCell(2) as HSSFCell;
Hssfcell2.CellComment = comment2;