NPOI向Excel文件插入图片

 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);

posted on 2012-02-06 08:08  kingang  阅读(1864)  评论(1编辑  收藏  举报

导航