Examples of inserting images into an Excel sheet

[Todd J]

Can anyone provide some samples of inserting images into row/cell when the image is coming from some external web location?

Thanks!

[Dilli Babu Nandha Gopal]

Hi Todd, 

Thank you for contacting Syncfusion support. 

Yes, you can able to insert an image from a Web location in a worksheet using XlsIO. The following code example illustrates this behavior. 

Code Example: 

 

IWorksheet worksheet = workbook.Worksheets[0]; 

 

string imgLoc= @"https://cdn.syncfusion.com/content/images/company-logos/Syncfusion_Logo_Image.png"; 

 

//Retrieving from Web 

WebClient webClient = new WebClient(); 

byte[] imageBytes = webClient.DownloadData(imgLoc); 

MemoryStream stream = new MemoryStream(imageBytes); 

 

//Adding a picture 

IPictureShape shape = worksheet.Pictures.AddPicture(1, 1,stream); 

 

We have shared a sample for your reference which can be downloaded from the following link. 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/InsertingWebImage1681946  

Please let us know whether the sample fulfills your requirement. 

Regards, 

Dilli babu. 

[sandra]

Images can’t be inserted into cells, but actually they are present in separate layer and keep floating over the cells. Well you can resize image to get into a specific cell by stretching or squeezing the corners of your image but this results in an untidy looking spreadsheet. 

As the image won’t appears to set in a specific cell. I have done this task of inserting gif image into Excel using VBA code and got perfect result. 

If you also want to try then take help from this post: How To Insert Animated GIF Images In Excel 2007/2010/2013/2016

[Fatima Vieira]

Any way I can inject multiple images, please note these are embedded and not web images into a sheet in specific locations, I am looking for something like this more or less?

Would it be a good direction to use a grid and export to excel in the grid?

[Farveen Sulthana Thameeztheen Basha]

Hi Fatima, 

Query#:- Would it be a good direction to use a grid and export to excel in the grid? 

We have checked your query and we can achieve this requirement using ColumnTemplate Exporting. Using ColumnTemplate Exporting we can export the values given in the JS Render Template. By this way we have Export the images while placing it as Template column. Using ServerExcelColumnTemplateInfo server event we can Export Images into Excel Sheet. 

Refer to the demo and Documentation Link:- 

https://help.syncfusion.com/aspnet/grid/exporting?cs-save-lang=1&cs-lang=html#columntemplate-exporting 

https://asp.syncfusion.com/demos/web/Grid/ColumnTemplateExporting.aspx 

Please get back to us if you need any further assistance. 

Regards, 

Farveen sulthana T 

[Fatima Vieira]

Thanks so much for this Farveen!!!

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Fatima, 

You are Welcome. 

Regards, 

Keerthi.