Read Data From Excel using the sheet name

Hi Partha ,

There is some workaround available. You can Fetch the Sheet Name through RPA.

• Create a Robotic Task.
• Pass the File in the RPA Task to read the sheet Name.
• The sheet name will be passed in the same order as the Excel document.
• Create an Index for the same Name.
• Use the Excel Plugin to read with the index constructed by sheetName.

****This is not the optimal solution*****

Below are some screenshots of configuring these actions in the Robotic Task.

Note:

• This will take some time around 10 to 15 sec to complete, depends how you configured the Wait time in Robotic Task.
• Check with the project team they are okay with the RPA approach.

Hi Partha ,

There is some workaround available. You can Fetch the Sheet Name through RPA.

• Create a Robotic Task.
• Pass the File in the RPA Task to read the sheet Name.
• The sheet name will be passed in the same order as the Excel document.
• Create an Index for the same Name.
• Use the Excel Plugin to read with the index constructed by sheetName.

****This is not the optimal solution*****

Below are some screenshots of configuring these actions in the Robotic Task.

Note:

• This will take some time around 10 to 15 sec to complete, depends how you configured the Wait time in Robotic Task.
• Check with the project team they are okay with the RPA approach.

HI Ranjith,

Can we pass the document directly to the RPA or if we able to pass only the file path. How to pass the file path of the document in the knowledge centre to the RPA.

Our requirement is to extract the sheet name once user upload the document through the site page. 

You can't directly refer KC file path, you need to push the file to RPA system 1st.

Below are the steps:

1. From the Process Model you need to pass the document into RPA task.
2. 1st step is to push the document into the RPA system, its output will be the file path(Please refer ScreenShort Setup section).
3. From the file path, you can check if the file exists and do other actions like opening and reading sheet name,etc.