Using configuration file and output into excel

[Sonia_012]

Dear Ui Masters.
please help me on below scenario. (No RE- Framework )

Input sheet - Excel A
Configuration xlx - Config File
Output sheet - OutputResult

Problem :- I need to use the config file to display the output file according to the value mentioned in “Display in Output” if in config file “display in output” mentioned as yes then in output sheet that column should appear and if it is no then it should not appear
Config.xlsx (9.5 KB) Excel A.xlsx (10.0 KB) output.xlsx (9.2 KB)

[Manish540 (Manish Shettigar)]

Check this below workflow, @Sonia_012
Uipath_ExcelFileConfiguration.xaml (8.1 KB)
Hope this may help you

[Sonia_012]

Hi Manish,

Thank you so much, however I have one query, where have you used Excel A in that xaml File.
because i need data from Excel A workbook to output sheet, if in config file display output mentioned as yes.

i am sorry but i am not sure if i am able to explain you correctly.

[Sonia_012]

@Manish540 please help

[Manish540 (Manish Shettigar)]

Check this updated workflow, @Sonia_012
Uipath_ExcelFileConfiguration.xaml (8.6 KB) , change the excel filepath’s and sheet names in variable panel.
Hope this may help you

[Rakesh_Sampath]

Hi @Sonia_012
Here you go with your solution!!!
ForumQuery.zip (56.9 KB)

Happy learning!!!

Thanks and regards
Rakesh Sampath