How to export images from asp.net to excel using c#?

Question

Hi,

I have the image details stored in the Sql server Database and the corresponding image files inside the application - 'UploadFiles' folder.

When i click on a button(Export to Excel) , I want to export image from asp.net application to Excel.

Answer 1

Hello,

Please take a look at the Considerations for server-side Automation of Office article which states the following:

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

As a workaround you can use the Open XML SDK or any commercial components.

Answer 2

Hi Latha,

In addition, you can check whether threads below is helpful:

Insert images into specific excel cells using OpenXML

Best regards

Fei

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.