Excel插入图片（C#）

最新推荐文章于 2023-06-09 11:29:30 发布

摸摸小鱼

最新推荐文章于 2023-06-09 11:29:30 发布

阅读量3k

点赞数

分类专栏： C# .NET 文章标签： c#

本文链接：https://blog.csdn.net/qq_18913129/article/details/124139500

版权

C# 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

.NET

5 篇文章 0 订阅

订阅专栏

NPOI实现：

/// <summary>
        /// .xls后缀的Excel文件添加图片
        /// </summary>
        /// <param name="book"></param>
        /// <param name="sheet1"></param>
        /// <param name="rowindex"></param>
        /// <param name="imgPath"></param>
        private static void InsertImageToExcel(HSSFWorkbook book, ISheet sheet1, int rowindex, string imgPath)
        {
            byte[] bytes = System.IO.File.ReadAllBytes(imgPath);
            int pictureIdx = book.AddPicture(bytes, PictureType.JPEG);
            HSSFPatriarch patriarch = (HSSFPatriarch)sheet1.CreateDrawingPatriarch();
            HSSFClientAnchor anchor = new HSSFClientAnchor(30, 25, 0, 0, 4, rowindex, 5, rowindex);
            HSSFPicture pict = (HSSFPicture)patriarch.CreatePicture(anchor, pictureIdx);
            pict.Resize();//自动调节图片大小
        }