/// <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)}]扩展方法"); }