/// <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);//这句话一定不要,这是用图片原始大小来显示
}
}