准备一张图片,替换我代码中的路径。
创建一个方法:
将如下内容copy。
会在你的d盘下创建一个excel 并插入了图片
//1.创建EXCEL中的Workbook
//IWorkbook myworkbook = new HSSFWorkbook();
//2.创建Workbook中的Sheet
//ISheet mysheet = myworkbook.CreateSheet("sheet1");
//第一步:读取图片到byte数组
FileWebRequest request = (FileWebRequest)WebRequest.Create(@"D:\program\BadmintonWebService\BadmintonWebService\SignPicture\21aad64f6-67bb-476e-8527-c89e50216915.jpg");
byte[] bytes;
using (Stream stream = request.GetResponse().GetResponseStream())
{
using (MemoryStream mstream = new MemoryStream())
{
int count = 0;
byte[] buffer = new byte[1024];
int readNum = 0;
while ((readNum = stream.Read(buffer, 0, 1024)) > 0)
{
count = count + readNum;
mstream.Write(buffer, 0, 1024);
}
mstream.Position = 0;
using (BinaryReader br = new BinaryReader(mstream))
{
bytes = br.ReadBytes(count);
}
}
}
//第二步:将图片添加到workbook中 指定图片格式 返回图片所在workbook->Picture数组中的索引地址(从1开始)
int pictureIdx = workbook.AddPicture(bytes, NPOI.SS.UserModel.PictureType.JPEG);
//第三步:在sheet中创建画部
IDrawing patriarch = sheet.CreateDrawingPatriarch();
//第四步:设置锚点 (在起始单元格的X坐标0-1023,Y的坐标0-255,在终止单元格的X坐标0-1023,Y的坐标0-255,起始单元格行数,列数,终止单元格行数,列数)
IClientAnchor anchor = patriarch.CreateAnchor(0, 0, 0, 0, 0, 0, 2, 2);
//第五步:创建图片
IPicture pict = patriarch.CreatePicture(anchor, pictureIdx);
6.保存
//FileStream file = new FileStream(@"D:\myworkbook11.xls", FileMode.Create);
//workbook.Write(file);
//file.Close();