NPOI 在指定单元格导入导出图片

雨点打透心脏的1/2处 2022-09-07 14:56 192阅读 0赞

public static Dictionary<CellPosition, IPictureData> GetPicturesAndPosition(this ISheet sheet)
    {
        var dictionary = new Dictionary<CellPosition, IPictureData>();
        if (sheet.Workbook is HSSFWorkbook)
        {
            foreach (var shape in ((HSSFPatriarch)sheet.DrawingPatriarch).Children)
            {
                if (shape is HSSFPicture picture)
                {
                    var position = new CellPosition(picture.ClientAnchor.Row1, picture.ClientAnchor.Col1);
                    dictionary[position] = picture.PictureData;
                }
            }
        }
        else if (sheet.Workbook is XSSFWorkbook)
        {
            foreach (var shape in ((XSSFDrawing)sheet.DrawingPatriarch).GetShapes())
            {
                if (shape is XSSFPicture picture)
                {
                    var position = new CellPosition(picture.ClientAnchor.Row1, picture.ClientAnchor.Col1);
                    dictionary[position] = picture.PictureData;
                }
            }
        }
        return dictionary;
    }

if (dic.TryGetValue(posion, out var pictureData))
                                    {
                                        var pic = "jpg";
                                        switch (pictureData.PictureType)
                                        {
                                            case PictureType.PNG: { pic = "png"; } break;
                                            case PictureType.JPEG: { pic = "jpg"; } break;
                                        }
                                        var saveName = $"{huohao}.{pic}";
                                        var filepath = Path.Combine(fileSaveFloder, saveName);
                                        if (File.Exists(filepath))
                                        {
                                            File.Delete(filepath);
                                        }
                                        File.WriteAllBytes(Path.Combine(fileSaveFloder, saveName), pictureData.Data);
                                      
                                    }

/// <summary>
        /// CellPosition 是一个自定义的结构体，表示当前单元格的位置
        /// </summary>
        public readonly struct CellPosition : IEquatable<CellPosition>
        {
            public CellPosition(int row, int col)
            {
                Row = row;
                Column = col;
            }
    
            public int Row { get; }
            public int Column { get; }
    
            public bool Equals(CellPosition other)
            {
                return Row == other.Row && Column == other.Column;
            }
    
            public override bool Equals(object? obj) => obj is CellPosition other && Equals(other);
    
            public override int GetHashCode() => $"{Row}_{Column}".GetHashCode();
        }