首页 > 解决方案 > c# excel将图片插入单元格

问题描述

插入 Excel 图像时,我想在左侧和顶部留出空间。并且图像将被创建字节并显示。

Microsoft.Office.Interop.Excel.Worksheet oSheet = (Microsoft.Office.Interop.Excel.Worksheet) excelworkbook.ActiveSheet; 

Microsoft.Office.Interop.Excel.Range oRng = null;

    byte[] img;
    MemoryStream ms;
    Bitmap bImage;
    Bitmap bImageSized;
    
    ms = new MemoryStream(img);
    bImage = new Bitmap(ms);
    bImageSized = new Bitmap(bImage, 151, 101);
                                        
    Clipboard.SetImage(bImageSized);
    oSheet.Paste(oRng, false);

标签: c#excelinsertcell

解决方案


推荐阅读