Loop Thru Excel files in a folder. Add a render tool to save data and charts to the file

[kal-tech]

I have two excel files in the folder. The Excel File "Sheet1" contains data. Open each excel file add a bar chart in sheet 1 and save it in the different folder. The File will have data and bar chart. I do not know how to dynamically read through the files in a directory and use the render tools to save the files.

1. Input File  - Catsie.xlsx, Orient.xlsx (Folder - c:\test\input)

2. Output File name - Catsie-chart.xlsx, Orient-chart.xlsx (Folder - c:\test\output)

 I attached the input files and  Bar chart workflow.

[kal-tech]

HI @Qiu : I figured it out and resolved the issue. Thanks again for your help.

[Qiu]

@kal-tech 
Thank you for letting me.
Sorry that I did not reply your query in time, since it appears I was not properly mentioned.
And I am now preparing the document for submitting it as weekly challenge idea.