/// <summary>
/// 获取工作表中指定区域包含图片的信息列表
/// </summary>
/// <param name="sheet">NPOI工作表</param>
/// <param name="minRow">最小行索引</param>
/// <param name="maxRow">最大行索引</param>
/// <param name="minCol">最小列索引</param>
/// <param name="maxCol">最大列索引</param>
/// <param name="onlyInternal">是否仅在内部</param>
public static List <PictureInfo> GetAllPictureInfos(this NPOI.SS.UserModel.ISheet sheet, int?minRow,
int?maxRow, int?minCol, int?maxCol, bool onlyInternal = true)
{
switch (sheet)
{
case HSSFSheet hssfSheet:
return(GetAllPictureInfos(hssfSheet, minRow, maxRow, minCol, maxCol, onlyInternal));
case XSSFSheet xssfSheet:
return(GetAllPictureInfos(xssfSheet, minRow, maxRow, minCol, maxCol, onlyInternal));
}
throw new NotImplementedException($"尚未实现该[{sheet.GetType()}]类型的[{nameof(GetAllPictureInfos)}]扩展方法");
}
/// <summary>
/// 移除工作表中指定区域的图片
/// </summary>
/// <param name="sheet">NPOI工作表</param>
/// <param name="minRow">最小行索引</param>
/// <param name="maxRow">最大行索引</param>
/// <param name="minCol">最小列索引</param>
/// <param name="maxCol">最大列索引</param>
/// <param name="onlyInternal">是否仅在内部</param>
public static void RemovePictures(this NPOI.SS.UserModel.ISheet sheet, int?minRow, int?maxRow, int?minCol,
int?maxCol, bool onlyInternal = true)
{
switch (sheet)
{
case HSSFSheet hssfSheet:
RemovePictures(hssfSheet, minRow, maxRow, minCol, maxCol, onlyInternal);
break;
case XSSFSheet xssfSheet:
RemovePictures(xssfSheet, minRow, maxRow, minCol, maxCol, onlyInternal);
break;
}
throw new NotImplementedException($"尚未实现该[{sheet.GetType()}]类型的[{nameof(RemovePictures)}]扩展方法");
}
