spire和npoi导出图片注释的对比

spire导出注释图片

1.批量导出的图片必需存储在本地，如果是存储在数据库中的二进制数据，会非常不便。

2.使用破解版本的spire4个月后报初始化异常。。不知原因

 /// <summary>
        /// 将图片存放到excel中,并使得进度条实时刷新
        /// </summary>
        /// <param name="filepath">excel地址</param>
        /// <param name="list">数据集合</param>
        /// <param name="count">数据总数</param>//车轮
        void images(string filepath, List<CarriageWheel> list, int count)
        {
            try
            {
                Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();

                //初始化对象
                workbook.LoadFromFile(filepath);

                //获取第一个工作表
                Spire.Xls.Worksheet sheet = workbook.Worksheets[0];


                //创建image对象

                Image image = null;
                //循环遍历
                for (int i = 0; i < list.Count; i++)
                {
                    //为image对象赋值
                    image = Image.FromFile("D:\\" + i + ".jpg");
                    //指定iamge对象和绝对地址
                    sheet.Range["G" + (3 + i)].Comment.Fill.CustomPicture(image, "D:\\" + i + ".jpg");
                    //拿到高度
                    sheet.Range["G" + (3 + i)].Comment.Height = image.Height;
                    //拿到宽度
                    sheet.Range["G" + (3 + i)].Comment.Width = image.Width;
                    SetTextMessage((count * 2 + i + 1) * 100 / (count * 3));
                    //image.Dispose();
                }


                //保存并打开文档
                workbook.SaveToFile(filepath, version: Spire.Xls.ExcelVersion.Version2013);
                sheet.Dispose();
                workbook.Dispose();



                image.Dispose();
                GC.Collect();