ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I generate excel file from c# & want to display image in it (https://www.excelbanter.com/excel-programming/422200-i-generate-excel-file-c-want-display-image.html)

dd12345

I generate excel file from c# & want to display image in it
 
We have a C# application that generates Excel files and includes data in the
files based upon the "account" that the user selects. It has worked fine,
but now we want to insert an image (PNG file) into one of the cells. I am
able to create a hyperlink to the picture, but the image itself does not
appear on the Excel file (if I click on the cell it opens a browser window
and displays the image by itself, but it does not appear in the Excel file).
To create the Excel file, we create a large XML string formatted for Excel,
then write it to Excel using System.Web.HttpContext (setting the ContentType
= "application/vnd.ms-excel").






NA_AB[_2_]

I generate excel file from c# & want to display image in it
 

how about using this?!

myApplication.Rows.Worksheet.SetBackgroundPicture( @"C:\Documents and
Settings\All Users\Documents\My Pictures\Sample Pictures\blue hills.jpg");


dd12345

I generate excel file from c# & want to display image in it
 

Thanks for the post, but we want to insert a small logo into one cell, not
create a watermark on the sheet.



"NA_AB" wrote:


how about using this?!

myApplication.Rows.Worksheet.SetBackgroundPicture( @"C:\Documents and
Settings\All Users\Documents\My Pictures\Sample Pictures\blue hills.jpg");



All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com