How to read an excel file?

Help Activities
, ,
1

Good Day.

May I know how to read an excel file? What is the activity that should be used?

Best regards,
John Mark

2

Hi @John_Mark

You can use Read Range Workbook or Excel activities to read the excel.

If you are reading the excel from Google Drive or SharePoint you can download the package UiPath.GSuite.Acticities or UiPath.MicrosoftOffice365.Acticities

Hope it helps!!

1 Like
3

Hi @John_Mark

Use Read Range Workbook activity

Regards,

1 Like
4

Hi @John_Mark

You can use the Read range workbook activity to read the excel and store in a datatable.

Or else If you want to use the excel activities you can use the Read Excel.
For using this activity you have to encapsulate this activity with use excel file activity.

Hope it helps!!

1 Like
5

Hi Mahesh, I’m following this and attempting to grab data from my excel file. When using the Read Range add-in on my UiPath, I do not have the ability to select which Tab I am wanting to get my range of data from. Any ideas here on how to set that up correctly? I originally tried to plug the tab name and cell in the “Range*” area, like a formula reference, but got the error: BC30512: Option Struct On disallows implicit conversions from ‘String’ to ‘IReadRangeRef’. The selected value is incompatible with the property type.

I’m running 2.23.4 excel.activities.

Thanks!
Max

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.