Finance | Project Operations, Human Resources, ...

Manipulate images in Excel through EPPlus

(2) Share

Report

Posted on by 동김-13080324-0

I need one of the following two functions.

1) Delete spesfic image in excel sheet.

using OfficeOpenXml;
using OfficeOpenXml.ExcelWorksheet;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;
using OfficeOpenXml.ExcelRange;
using OfficeOpenXml.ExcelRangeBase;
using System.Drawing;
using System.Drawing.Image;
using OfficeOpenXml.Drawing;
using OfficeOpenXml.Drawing.ExcelPicture;
using OfficeOpenXml.Drawing.ExcelDrawing;
using OfficeOpenXml.ExcelPackage;
using OfficeOpenXml.ExcelWorkbook;
using OfficeOpenXml.ExcelWorksheet;

~~~~~

using (var package = new OfficeOpenXml.ExcelPackage(memoryStream))
{
var worksheet = package.get_Workbook().get_Worksheets().get_item(1); // 첫 번째 시트 선택
var cells = worksheet.get_Cells();

~~~~

// find image "Picture1" that delete image.

2) Get Image in URL and insert Excel sheet

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you explain what EPPLUS is? Can you tell us the functional requirement and the relation with Dynamics 365 Finance?

What URL and/or images are you referring to?

If you can provide more information, we might be able to understand your requirements and then try to help you.

Was this reply helpful? Yes No
동김-13080324-0 16 on at

Like (0)

Report

Hi. andre.

EPPlus is a highly popular spreadsheet/xlsx library for .NET Framework/.NET Core.

We even made it to show the data of ERP to EXCEL using EPPLUS's fuctions.

We have technical issues in the following two.

1) Depending on the conditions, we must remove the images contained in the worksheet of the Excel template.

2) Depending on the conditions, the C.E.O sign image in the container field of the table should be shown in Excel.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,994 Most Valuable Professional on at

Like (1)

Report
Your code worksheet.Drawings.ExcelDrawings("Pic001", image1) is indeed invalid. If you look at ExcelDrawings class, you'll see that it doesn't have any ExcelDrawings() method. You should use AddPicture() instead. For example:
ExcelDrawings drawings = worksheet.Drawings; drawings.AddPicture("Pic001", image1);
Notice that there are several overloads of AddPicture(); you could use the data stream directly.

Was this reply helpful? Yes No