NPOI导出excel，插入图片

最新推荐文章于 2024-06-27 14:33:55 发布

zhenzhenzhao12

最新推荐文章于 2024-06-27 14:33:55 发布

阅读量8.8k

点赞数 2

分类专栏： NPOI

本文链接：https://blog.csdn.net/zhenzhenzhao12/article/details/22170027

版权

NPOI 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

//add picture data to this workbook.

byte[] bytes = System.IO.File.ReadAllBytes(@"D:\MyProject\NPOIDemo\ShapeImage\image1.jpg");

int pictureIdx = hssfworkbook.AddPicture(bytes, HSSFWorkbook.PICTURE_TYPE_JPEG);



//create sheet

HSSFSheet sheet = hssfworkbook.CreateSheet("Sheet1");



// Create the drawing patriarch.  This is the top level container for all shapes. 

HSSFPatriarch patriarch = sheet.CreateDrawingPatriarch();



//add a picture

HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 0, 0, 0, 1, 3);

HSSFPicture pict = patriarch.CreatePicture(anchor, pictureIdx);

有时并不需要拉伸的效果

在结尾加上pict.Resize();即可使图片自动伸缩到原始大小了