How to Insert Picture to Excel in C#.NET Code

---

The following section shows how to insert a picture / image / icon in an .xlsx spreadsheet file from C# Application .

How to Insert Picture to Spreadsheet in C# language

Support commonly used image format, such as .Jpeg, .Png, .Bmp, .Tiff, .Gif and .ico

Load or Import a Picture

Read picture from local file.

var picture = worksheet.AddPicture("demo-pic.png", "imageFromFile"); 

Read picture from stream (file stream or momery stream).

var picture2 = worksheet.AddPicture(stream, PictureFormat.Jpeg); 

Set Picture Position

Set image position with absolute point.

picture.SetPosition(100, 100); 

Or insert image to target cell.

picture2.SetPosition(worksheet.Cell("A10")); 

Set Picture Size

Allows to change image size to any width and height. If you want to keep the original image size, just not calling the SetSize() method.

picture.SetSize(200, 50); 

Full code for adding Excel picture in C#

var workbook = new Workbook(); var worksheet = workbook.Worksheets.Add("PictureSheet"); ///Insert image from file var picture = worksheet.AddPicture("demo-pic.png", "imageFromFile"); //Set image position with absolute point picture.SetPosition(100, 100); //Set image size, if not set, the image will be shown as original size picture.SetSize(200, 50); ///Insert image from stream using (Stream stream = File.OpenRead("demo-pic2.jpg")) { var picture2 = worksheet.AddPicture(stream, PictureFormat.Jpeg); //Set image position to cell picture2.SetPosition(worksheet.Cell("A10")); //Set image placement picture2.SetPlacement(PicturePlacement.Move); } workbook.Save("Picture.xlsx"); 

What iDiTect .NET Document component can do

We provide powerful & profession document & image controls: How to convert html to pdf in c# Convert any web page to PDF using a powerful tool: iDiTect.Converter Html to Pdf Converter for .NET Convert HTML to Well-Formatted Microsoft Word Convert HTML to / from Word (DOCX) document in C# and VB.NET with iDiTect.Converter component. C# - Generate and save a PDF file you can use a PDF library, load your PDF form, set the values to each field, flatten your file Read and Extract PDF Text from C# / VB.NET applications how to extract all text from PDF file into TXT file (plain text) using PDF Extractor SDK. C#.NET Word to Image Converter SDK Convert Docx Word file into editable images using C# Able to convert multi-page Word document to separate image files by C# programming code. Programmatically convert MS Word DOCX files to PDF in C# A few lines of C# code are all it takes to convert Word to PDF for your .NET application.

More Programming Tutorials

• Python | Join cycle in list
• Overlapping Histograms with Matplotlib in Python
• Python language introduction
• Django REST Framework Installation
• Python - tensorflow.math.igamma()
• Split multiple array columns into rows in Pyspark
• Managed code and Unmanaged code in .NET
• Matplotlib.axes.Axes.get_aspect() in Python
• Hibernate - SQL Dialects
• Pygal Scatter Plot
• Python | Convert Joint Float string to Numbers
• Python program to print current year, month and day
• Spring MVC - Form Checkbox
• Python | Filter even values from a list
• Python | Convert tuple records to single string
• Read content from one file and write it into another file in python
• PyQt5 QSpinBox - Making text Strike Out
• How to normalize an array in NumPy in Python?
• Python program to Concatenate all Elements of a List into a String
• Python - Iterating through a range of dates

More Programming FAQs

• bs4.FeatureNotFound: Couldn't find a tree builder with the features you requested: lxml. Do you need to install a parser library?
• Python db-api: fetchone vs fetchmany vs fetchall
• Dynamic instantiation from string name of a class in dynamically imported module using python?
• First Python list index greater than x?
• “indirect fixture” error using pytest. What is wrong?
• Explicitly use a Func<Task> for asynchronous lambda function when Action overload is available
• Can you return an HTTP response from an AuthorizeAttribute without throwing an exception?
• AutoMapper - Map using the same source and destination object types
• Matplotlib interfering with NumPy (on Windows)
• How to call a derived class method from the base class in C#?
• Rename result columns from Pandas aggregation ("FutureWarning: using a dict with renaming is deprecated")
• How to get X509Certificate from certificate store and generate xml signature data in C#?
• How to check if a function was called in a unit test using pytest-mock?
• Converting Coq term in AST form to polish notation using Python
• HttpClient request throws IOException in C#
• Sqlclient vs EntityClient in C#
• How to disable password request for a Jupyter notebook session?
• Read headers from HttpResponseMessage before Content is 100% complete
• Sort argparse help alphabetically in python
• Do TCP sockets automatically close after some time if no data is sent in C#?
• Xamarin Forms Swipe Left/Swipe Right Gestures
• np.random.choice: probabilities do not sum to 1
• Scikit-learn is returning coefficient of determination (R^2) values less than -1
• Display pydoc's description as part of argparse '--help'
• Django/Python assertRaises with message check
• ItemsControl with horizontal orientation in C#
• Can combine a gRPC and webapi app into a .NET Core 3.0 in C#?
• Volatile variables in C#
• C# Version Of SQL LIKE
• How to convert a Pandas dataframe to a PyTorch tensor?