how to display image in Excel using open xml in c#

Question

I want multiple Images display in Excel but this Excel file is open xml in C#

Kalyani Shevale · Answer

I am using Spreadsheet Document

Andra Chahar · Answer

I used Spire.Xls to do it. It can open Excel files which are created by open xml. Workbook workbook = new Workbook(); workbook.LoadFromFile("D:\sample.xlsx"); Worksheet sheet = workbook.Worksheets[0]; sheet.Pictures.Add(1, 1, @"D:\images\cat01.png"); sheet.Pictures.Add(14, 5, @"D:\images\cat02.png"); sheet = workbook.Worksheets[0]; sheet.Pictures.Add(1, 2, @"D:\images\cat03.png"); workbook.SaveToFile("D:\result.xlsx",ExcelVersion.Version2013);

Madan Shekar · Answer

using OfficeOpenXml; using System.IO; //add two new namespace using OfficeOpenXml.Drawing; using System.Drawing; class Program { static void Main( string [] args) { ExcelPackage ExcelPkg = new ExcelPackage(); ExcelWorksheet wsSheet1 = ExcelPkg.Workbook.Worksheets.Add( "Sheet1" ); using (ExcelRange Rng = wsSheet1.Cells[2, 2, 2, 2]) { Rng.Value = "Welcome to Everyday be coding - tutorials for beginners" ; //Rng.Merge = true; Rng.Style.Font.Size = 16; Rng.Style.Font.Bold = true ; Rng.Style.Font.Italic = true ; } int rowIndex = 4; int colIndex = 2; int PixelTop = 88; int PixelLeft = 129; int Height = 320; int Width = 200; Image img = Image.FromFile(@ "D:\Sample.png" ); ExcelPicture pic = wsSheet1.Drawings.AddPicture( "Sample" , img); pic.SetPosition(rowIndex, 0, colIndex, 0); //pic.SetPosition(PixelTop, PixelLeft); pic.SetSize(Height, Width); //pic.SetSize(40); wsSheet1.Protection.IsProtected = false ; wsSheet1.Protection.AllowSelectLockedCells = false ; ExcelPkg.SaveAs( new FileInfo(@ "D:\New.xlsx" )); } }