Hello Everyone,
I need an urgent support to solve problem below:
I have 1 excel file. I took a screenshot. Then, I add new slide includes excel sheet image.
Now, I try to automate when new excel file added, 2nd slide should be created. And, when 3rd excel file added 3rd slide should be created.
My plan is to create a specific folder.
And in excel application scope, I need to write dynamic path but how?
Then in save image activity, I need to give dynamic image file name but how?
Then, insert slide and picture, I need to add slide below previous one but how?
now compare the slide count and excel sheet count,
if slide count<excel sheet count
take the screenshot of new excel sheet
then create a new slide using the insert slide activity and add add the screenshot in it.
All excel files are the same. And there is one sheet which I get screenshot.
First I need to create a folder. When I put 2nd excel file, I need to do same operations to new excel file. Then, it will be added next slide.
I can recommend the following path to create the workflow
Create two folders input & output folders for storing the excel files.
Place the excel files u need to add in slide in input folder, once the details in slide are added, we can make the bot to move the excel file to output folder
for developing purposes, u can approach the follwoing way
use the assign activity to get the file paths present in input folder and store in array
now loop through each excel file using for each loop,
inside the loop do the following:
a. Open the excel file and take the screenshot of sheet
b. Insert a new slide and then place the screenshot to it
c. once done, move the excel file to output folder
This is the logic u can try
let me know if u had any questions
It is worked. But now there is one problem. It writes on 2nd slide. Now I am trying to solve dynamic slide index. I try to increase slide number with respect to number of excel file.
If any suggestions to fix it, I will complete my flow in one day. Then, I will work on slide design.
Thank you very much.
Take Number of Files in Input as Array of Strings each time and take count of files using var_arrstring.Length and pass as dynamic value for Slide Index.
