Reading Excel files in web studio

Help Studio
, ,
1

I am able to read an Excel file from my PC in the web studio?.
I am attempting to replicate a robot I have in UiPath Studio. However, it gives me an error when I try to read it.

The image shows a configuration screen for reading a specified range of cells ("A1:A7") from the "Hoja1" sheet in the Excel workbook located at "C:sers00clememgocumentsrueba.xlsx". (Captioned by AI)
The image shows a configuration screen for reading a specified range of cells ("A1:A7") from the "Hoja1" sheet in the Excel workbook located at "C:sers00clememgocumentsrueba.xlsx". (Captioned by AI)800×317 16.2 KB

The image displays a user interface panel with options to enter a password, toggle headers, choose a display format, and specify output settings for a data table and workbook. (Captioned by AI)
The image displays a user interface panel with options to enter a password, toggle headers, choose a display format, and specify output settings for a data table and workbook. (Captioned by AI)683×422 17.9 KB

The image shows a log window with an error message in Spanish stating "Read Range Workbook: El libro no existe," indicating that the workbook could not be found. (Captioned by AI)
The image shows a log window with an error message in Spanish stating "Read Range Workbook: El libro no existe," indicating that the workbook could not be found. (Captioned by AI)472×223 20.1 KB

2

Hey @Matias_Clemente.Arg if you want to read Excel file using UiPath Studio use Excel Application Scope Use Excel File then use Read Range Activity and in read range go to property panel where save their output .so all the data will be stored in a data table variable now to show the output Data table and after that use a log message that will display your input data.
follow the image steps
PS(Here Dt1 is read range variable and stroutput is output data table activity variable)

The image shows an Excel scope activity within UiPath Studio, reading a specified range from an Excel file named "Skip.xlsx" and storing the data into a variable named "dt1". (Captioned by AI)
The image shows an Excel scope activity within UiPath Studio, reading a specified range from an Excel file named "Skip.xlsx" and storing the data into a variable named "dt1". (Captioned by AI)558×460 16.9 KB

The image depicts an automation workflow consisting of three main steps: reading a range from an Excel sheet into a data table (dt1), converting the data table to text, and logging the text output as a message. (Captioned by AI)
The image depicts an automation workflow consisting of three main steps: reading a range from an Excel sheet into a data table (dt1), converting the data table to text, and logging the text output as a message. (Captioned by AI)569×398 15.9 KB

cheers

3

Hi @Matias_Clemente.Arg

You can use the Read range workbook activity to read the excel stored in local. Create a variable in the output, the output variable is datatable datatype.

Hope it helps!!

5

Thank you for your response, but I am referring to the WEB studio. That is, the UiPath that is developed from the web.

A screenshot of the UiPath Studio interface showing a search for activities with options like "Build Collection," "Read Range Workbook," "For Each," "Click," "Use Browser," and "Send Tweet." (Captioned by AI)
A screenshot of the UiPath Studio interface showing a search for activities with options like "Build Collection," "Read Range Workbook," "For Each," "Click," "Use Browser," and "Send Tweet." (Captioned by AI)1299×681 58.9 KB

6

Hello, thank you for your response. I have edited the original post to include more details.

8

Basically you wont be able to access the local drive storage (C:/D:). You need to connect to Microsoft 365 ( Microsoft OneDrive & SharePoint connector ) to access it via OneDrive.

If you still need to access using the excel file methos, then follow the below steps:

  1. Upload your excel file to the storage bucket
  2. Use download storage file activity
  3. Use the output of the download storage file activity as input for read range workbook
9

It is efficiently worked for me, thanks