Reading Config file and navigating to the particular worksheet

Hello There,

I have two excel files, one is a config file containing list of worksheet names, and the other is actual file which has more worksheets than the list mentioned in the config file.

The requirement is to rename few of the columns of each worksheet mentioned in the config file and also read the content of the worksheet in a data table.

I am unable to compare the two files and meet the above requirement. Any help would be appreciated.

Thank you

Hi @rohankulkarni

I have attached the xaml that meets your requirement

Please take a look at it, And Mark it as solution if its applicable.

sample.xaml (14.1 KB)
dataInput.xlsx (14.3 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.