Read Excel xlsx file without Excel Installed

Help Studio
,
1

Hi All,

Thank you very much for any help you can provide.

I would like to read excel sheets without having excel installed. I’ve been searching the Forum for answers but came up short. The Excel Activities Scope is well documented. The alternative suggested on the forum when excel is not installed is the System Activities WorkBook Read Range. This approach was suggested as recently as 6/2019. But is also suggested in https://forum.uipath.com/t/read-excel-cells-without-excel-app/1988. I’m not seeing this option in my system activities. I have Uipath.Systems.Activities 19.8.0 installed. I see the following when looking for WorkBook

image

I’m not a programmer and new to Uipath as well. Trying to create some automation for my medical office. Any help is much appreciated!

Warm Regards,
James

2

The System activity for writing and reading Excel files is in the Excel activities package, but will be listed under System.File, as you have above. Make sure you have this package.

3

Thanks for your reply Anthony_Humphries. I really appreciate it! I have and had Uipath.Excel.Activities 2.7.2 installed. I still can’t seem to find the WorkBook activities that allow one to read xlsx (excel) files without having excel installed.

image
image714×460 128 KB

One work around I could use involves converting in excel the xlsx files to csv and then using the Read CSV file. It works, but involves an extra step in excel that I’d like to avoid if possible.

Thanks for any help!

4

If you search for “Read Range” in your activities, it should be somewhere toward the bottom of the list.

1 Like
5

You are 100% correct. Very AWESOME! Thank you so much for helping me.

If I try to find “Read Range” by browsing into it, it doesn’t show up. If I search for it, there it is.

Thanks So much!

Searching …

image

vs

Browsing …

image
image224×577 30.7 KB

Seems odd to me, but I assume it’s user error, as usual.

Thanks again,
James

6

There are more activities in ‘Workbook’.
If you click it, there will be more activities including ‘Read range’
‘Append line’ ~ ‘Write text file’ are included in ‘File’, not ‘Workbook’

screenshot
screenshot350×662 23.4 KB

1 Like
7

It was in App Integration tree not in System that you were browsing

8

Yep, you are correct. I can’t believe I didn’t find it because I didn’t click on it. Thanks for your reply!

Best,
James

9

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