Skip to main content
added 1 character in body
Source Link
Hadi
  • 1.2k
  • 11
  • 19

You can use a script task to achieve that, you can benefit from the Microsoft.Interop.Excel library to achieve that, you can copy the image from a file using the following code:

Image ExcelImage = Image.FromFile(strFilePath);
System.Windows.Forms.Clipboard.SetDataObject(ExcelImage ,true);

And paste it to excel sheet using the following code:

Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1];
Excel.Range oRange = (Excel.Range)ThisSheet.Cells[10,1];
ThisSheet.Paste(oRange,ExcelImage);

*Detailed code provided in the following link:Detailed code provided in the following link:

You can use a script task to achieve that, you can benefit from the Microsoft.Interop.Excel library to achieve that, you can copy the image from a file using the following code:

Image ExcelImage = Image.FromFile(strFilePath);
System.Windows.Forms.Clipboard.SetDataObject(ExcelImage ,true);

And paste it to excel sheet using the following code:

Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1];
Excel.Range oRange = (Excel.Range)ThisSheet.Cells[10,1];
ThisSheet.Paste(oRange,ExcelImage);

*Detailed code provided in the following link:

You can use a script task to achieve that, you can benefit from the Microsoft.Interop.Excel library to achieve that, you can copy the image from a file using the following code:

Image ExcelImage = Image.FromFile(strFilePath);
System.Windows.Forms.Clipboard.SetDataObject(ExcelImage ,true);

And paste it to excel sheet using the following code:

Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1];
Excel.Range oRange = (Excel.Range)ThisSheet.Cells[10,1];
ThisSheet.Paste(oRange,ExcelImage);

Detailed code provided in the following link:

Source Link
Hadi
  • 1.2k
  • 11
  • 19

You can use a script task to achieve that, you can benefit from the Microsoft.Interop.Excel library to achieve that, you can copy the image from a file using the following code:

Image ExcelImage = Image.FromFile(strFilePath);
System.Windows.Forms.Clipboard.SetDataObject(ExcelImage ,true);

And paste it to excel sheet using the following code:

Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1];
Excel.Range oRange = (Excel.Range)ThisSheet.Cells[10,1];
ThisSheet.Paste(oRange,ExcelImage);

*Detailed code provided in the following link: