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