.net 使用EPPlus将背景图像添加到Excel不工作

hyrbngr7 于 2023-11-20 发布在 .NET

关注(0)|答案(1)|浏览(175)

我正在使用以下代码使用EPPlus向Excel工作表添加背景图像。但是保存的Excel没有任何背景图像。并且在使用在线Excel打开文件时，它说工作簿已损坏。

foreach (var file in Filelist)
{
    // Load workbook
    //var fileInfo = new FileInfo(@file);
    FileStream fs = new FileStream(file, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);

    Bitmap bmp = new Bitmap("image.png");
    //ExcelPackage pkg = new ExcelPackage(fs);

    using (var package = new ExcelPackage(fs))
    {
        // Iterate over workbook sheets
        foreach (var sheet in package.Workbook.Worksheets)
        {
            sheet.BackgroundImage.Image = bmp;
            sheet.Protection.IsProtected = false;
        }
                   
        package.SaveAs(new FileInfo(@"New.xlsx"));
    }

    fs.Close();
}

字符串

.net

来源：https://stackoverflow.com/questions/59889197/adding-background-image-to-excel-using-epplus-not-working

1条答案

按热度按时间

2w2cym1i1#

sheet上的BackgroundImage有一个方法SetFromFile，它可以完成这个任务。
完整代码

var file = @"c:\folder\spreadsheet.xlsx"; // Path to your source spreadsheet file here.
var image = @"c:\folder\background.png"; // Path to your background image here.
var imageFile = new FileInfo(image);

using (var fs = new FileStream(file, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
using (var package = new ExcelPackage(fs))
{
    foreach (var sheet in package.Workbook.Worksheets)
    {
        sheet.BackgroundImage.SetFromFile(imageFile);
    }

    package.SaveAs(new FileInfo(@"c:\folder\new.xlsx")); // Path to destination spreadsheet file here;
}

字符串

赞(0）回复(0）举报 2023-11-20

我来回答

.net 使用EPPlus将背景图像添加到Excel不工作

1条答案

相关问题

热门标签

最新问答