I have around files, where I need to open all these 20 excel spreadsheets and create a new sheet and paste the image in to this newly created sheet.
@Lakshmikanth_2021
One way to do it is to create an excel template file with the picture in it and then import the data into that template. I guess that will be the easiest way how to do it.
Another option will be using the Reporting Tools
Get the picture imported, then text set into a table and with a layout tool you can get it done, getting it written out with the Render tool