其中引用到的命名空间:
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;
using System;
using System.Data;
using System.IO;
下面是插入 图片的方法
public static void InsertToPicture(string picPath,string fileExt)
{
FileStream fs = new FileStream("C:\\Users\\win 10\\Desktop\\导入图片.xls", FileMode.OpenOrCreate, FileAccess.ReadWrite);
//create sheet
HSSFWorkbook hssfworkbook = new NPOI.HSSF.UserModel.HSSFWorkbook();
ISheet sheet = hssfworkbook.CreateSheet("Sheet1");
IDrawing patriarch = sheet.CreateDrawingPatriarch();
//将图片文件读入一个字符串
byte[] bytes = File.ReadAllBytes(picPath);
int pictureIdx = sheet.Workbook.AddPicture(bytes, PictureType.JPEG);
IClientAnchor anchor = null;
IPicture pict = null;