I am trying to connect an Excel file (this file is downloaded from a website using another workflow) to input tool but it is not reading the sheet name. Refer to image 1.
But, when I Open, Save and Close the Excel file and connect to input tool, I am able to get the sheet name. Refer to image 2. This is after the excel file was just opened, save (CTRL+S) and Closed.
I need help to figure a way to Open, Save and Close the excel file using a workflow may be using a Run command or something.
Any help in the form of a workflow would be highly appreciated.