Skip to main content
parthasarathym6661
parthasarathym6661
December 20, 2024
Question

Read Data From Excel using the sheet name

  • December 20, 2024
  • 6 replies
  • 0 views

Currently in the functions we have to pass the sheet number to extract the information from excel. Is there is any other excel plugin or function to get the data using the sheet name.

6 replies

jayaprakashr0001
jayaprakashr0001
December 23, 2024

AFAIK there is no plugin to extract details based on sheet name.

rakshitha0003
rakshitha0003
December 23, 2024

[mention:0230b2676df9491980744e7e3357c35a:e9ed411860ed4f2ba0265705b8793d05] 

Please use the plugin 

readexcelsheetwithfilter(
excelDocument: document ,
sheetNumber: 1,
startRow: 2,
endRow: 4,
startColumn: 1,
endColumn: 2
)

community.appian.com/.../excel-utility

parthasarathym6661
parthasarathym6661Author
December 23, 2024

As i mentioned, I want to extract using the sheet name.

ranjiths050336
ranjiths050336
December 24, 2024

Hi [mention:0230b2676df9491980744e7e3357c35a:e9ed411860ed4f2ba0265705b8793d05] ,

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.

/resized-image/__size/640x480/__key/communityserver-discussions-components-files/19/Screenshot-2024_2D00_12_2D00_24-at-12.54.38_2F20_PM.png

/resized-image/__size/640x480/__key/communityserver-discussions-components-files/19/Screenshot-2024_2D00_12_2D00_24-at-12.50.57_2F20_PM.png

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.

parthasarathym6661
parthasarathym6661Author
December 24, 2024

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. 

ranjiths050336
ranjiths050336
December 24, 2024

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.

/resized-image/__size/640x480/__key/communityserver-discussions-components-files/19/Screenshot-2024_2D00_12_2D00_24-at-6.26.48_2F20_PM.png

Terms & ConditionsAccessibility statement