Add Picture in Excel on Particular Cell with C#

Question

I am trying to add an image into Excel cell at row 3 column 1 as specified below. The compiler gave me an error. Did I do something wrong here? Thanks in advance for your suggestions.

Excel.Application xlApp; 
Excel.Workbook wb; 
Excel.Worksheet ws; 
object misValue = System.Reflection.Missing.Value; 
xlApp = new Excel.Application(); 
wb = xlApp.Workbooks.Add(misValue); 
ws = (Excel.Worksheet)wb.Worksheets.get_Item(1); 
ws.Cells[3, 1] = ws.Shapes.AddPicture("C:\\photos\\4a.png", Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 75, 75, 350, 50);

Error occured like this..... System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC — Kuldip Rana, Jun 03 '16 at 04:57
try by creating a `Desktop` folder under `C:\Windows\System32\config\systemprofile` AND `C:\Windows\SysWOW64\config\systemprofile` — Pranav Patel, Jun 03 '16 at 05:17
@Pranav Patel thank you for this, but i have no problem when Excel Generate without picture like , ws.Cells[3, 1] = "Some Text"; When i Insert image on that cell this error come — Kuldip Rana, Jun 03 '16 at 05:26

score 8 · Accepted Answer · answered Jun 03 '16 at 06:49

8

you have to add picture like following

Microsoft.Office.Interop.Excel.Range oRange = (Microsoft.Office.Interop.Excel.Range)ws.Cells[3, 1];
float Left = (float)((double)oRange.Left);
float Top = (float)((double)oRange.Top);
const float ImageSize = 32;
ws.Shapes.AddPicture("C:\\pic.JPG", Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, Left, Top, ImageSize, ImageSize);

answered Jun 03 '16 at 06:49

Pranav Patel

1,541
14
28

In the last line "Left, Top, ImageSize, ImageSize);" first ImageSize corresponds to image width and the next one corresponds to image height. Both of these values are of type float. – BiLaL Aug 23 '17 at 14:37
Does this actually insert an image inside the determined cell? It doesn't seem so. It merely places the image on top of the work sheet so it covers those cells... – trilogy Jul 16 '20 at 20:10

score 0 · Answer 2 · answered Nov 09 '18 at 17:16

Aspose.Cells API can be used to add a picture in Excel on particular cell with C# or with other programming languages e.g. Java, C++ etc.

For demonstration, please see the following C# code and the Snapshot that shows the input Excel file and the output Excel file generated by Aspose.Cells API after the execution of the code. As you can see inside the snapshot, the cell C12 contains the picture.

Please also read the comments inside the code for more help.

C#

// Load input Excel file inside Aspose.Cells Workbook object.
Workbook wb = new Workbook("SampleAddPictureInExcelCell.xlsx");

// Access first worksheet.
Worksheet ws = wb.Worksheets[0];

// Access cell C12 by name.
Cell cell = ws.Cells["C12"];

// Add picture in Excel cell.
int idx = ws.Pictures.Add(cell.Row, cell.Column, "D:/Download/Penguins.jpg");

// Access the picture by index.
Picture pic = ws.Pictures[idx];

// Get the column width and row height of the cell in inches.
double w = ws.Cells.GetColumnWidthInch(cell.Column);
double h = ws.Cells.GetRowHeightInch(cell.Row);

// Adjust the picture width and height as per cell width and height.
pic.WidthInch = w;
pic.HeightInch = h;

// Save the workbook in output Excel file.
wb.Save("OutputAddPictureInExcelCell.xlsx", SaveFormat.Xlsx);

Snapshot showing the input Excel file and output Excel file generated by Aspose.Cells API. Here cell C12 contains the picture.

Add Picture in Excel on Particular Cell with C#

2 Answers2

Linked