NPOI向Excel文件插入图片

最新推荐文章于 2022-03-08 18:12:32 发布

weixin_30251587

最新推荐文章于 2022-03-08 18:12:32 发布

阅读量164

点赞数

原文链接：http://www.cnblogs.com/kingangWang/archive/2012/02/06/2339498.html

版权

 byte[] Content = new byte[Convert.ToInt32(fs.Length)];
 fs.Read(Content, 0, Convert.ToInt32(fs.Length));
int pictureIdx = hssfworkbookDown.AddPicture(Content,NPOI.SS.UserModel.PictureType.JPEG);
 HSSFPatriarch patriarch = (HSSFPatriarch)sheet1.CreateDrawingPatriarch();
//##处理照片位置，【图片左上角为（6, 2）第2+1行6+1列，右下角为（8, 6）第6+1行8+1列】
 HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0,0, 6, 2, 8, 6);
 HSSFPicture pict = (HSSFPicture)patriarch.CreatePicture(anchor, pictureIdx);