NPOI向sheet页插入图片

 /// <summary>
 /// 向sheet插入图片
 /// </summary>
 /// <param name="workbook">工作辅</param>
 /// <param name="sheet">sheet页</param>
 /// <param name="fileurl">图片地址</param>
 /// <param name="row">当前行</param>
 /// <param name="col">当前列</param>
 /// <param name="RowHeight">行高</param> 
 public virtual void AddPieChart(HSSFWorkbook workbook, ISheet sheet, string fileurl, int row, int col, short RowHeight)
 {
     byte[] bytes = System.IO.File.ReadAllBytes(fileurl);
     if (!string.IsNullOrEmpty(fileurl))
     {
         int pictureIdx = workbook.AddPicture(bytes, CIICUtils.NPOI.SS.UserModel.PictureType.JPEG);
         HSSFPatriarch patriarch = (HSSFPatriarch)sheet.CreateDrawingPatriarch();
         HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 20, 20, col, row, col + 1, row + 1);
         //##处理照片位置，【图片左上角为（col, row）第row+1行col+1列，右下角为（ col +1, row +1）第 col +1+1行row +1+1列，宽为100，高为50

          HSSFPicture pict = (HSSFPicture)patriarch.CreatePicture(anchor, pictureIdx);
          var index = sheet.GetRow(row) ?? sheet.CreateRow(row);
          index.Height = RowHeight;
          //pict.Resize(0);//这句话一定不要，这是用图片原始大小来显示
      }
 }