Adding png files images to the excel file into new sheet

Help Activities
, ,
1

Hi Team,

In my project, I have a png files in the folder path (Data\Output)
Code1.png, Code2.png, Code3.png (this will be dynamic. iE there can be 10 images as well in some cases)

In my automation, I am generating the excel file (Result.xlsx) with number of sheets dynamically.

Now, I want to add the png files to the Result.xlsx by creating a new Sheet (Screenshots)

Experts. @Anil_G , @ashokkarale @Yoichi

Please help

2

@hacky,

You can refer this thread for the solution.

3

@ashokkarale Yes I did. I did not understand it.

4

@hacky any specific part you don’t understand? tried downloading the code and test?

5

@hacky

Check this thread

6

You may try attached workflow.
It will add picture to already openned excel (objXLS argument) to given (existing) sheet at given (top/left) position.
Cheers

XlsAddPicture.xaml (11.9 KB)

7

Hi @hacky
In case you’re still looking for more solutions. You can try the following vba methods

Change the extension of the file to .bas
Macros.txt (3.2 KB)

At the end, there is a ‘General’ method that will show how to send the parameters.
All methods, will handle errors properly