NPOI插入图片到Excel

最新推荐文章于 2021-07-03 17:10:46 发布

a845179011

最新推荐文章于 2021-07-03 17:10:46 发布

阅读量1k

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/a845179011/article/details/105292837

版权

C# 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

//插入图片
string picPath = @"C:\Users\537\Desktop\Test\图片1.png";
FileStream picFs = File.OpenRead(picPath); //OpenRead
int filelength = 0;
filelength = (int)picFs.Length; //获得文件长度 
Byte[] image = new Byte[filelength]; //建立一个字节数组 
picFs.Read(image, 0, filelength); //按字节流读
int pictureIdx = workbook.AddPicture(image, PictureType.PNG);
HSSFPatriarch patriarch = (HSSFPatriarch)sheet1.CreateDrawingPatriarch();
// 插图片的位置  HSSFClientAnchor（dx1,dy1,dx2,dy2,col1,row1,col2,row2) 
//参数表示图片的位置.具体含义参考另一篇博文"NPOI获得图片信息"
HSSFClientAnchor anchor = new HSSFClientAnchor(70, 10, 0, 0, 1, 0, 2, 0 + 1);
//把图片插到相应的位置
HSSFPicture pict = (HSSFPicture)patriarch.CreatePicture(anchor, pictureIdx);
HSSFShapeGroup hSSFShapeGroup = patriarch.CreateGroup(anchor);
hSSFShapeGroup.AddShape(pict);
//hSSFShapeGroup.CreateShape()
using (Stream stream = File.OpenWrite("d:\\aaa.xls"))
{
    workbook.Write(stream);
}