Excel Automation_Read Input from Excel

Help Studio
, ,
1

Hi All,

I’m trying to automate a website were the credentials are being read from an excel file.
NOTE:- I don’t have excel installed in my machine. Hence directly using read range activity.
Getting error like below, attaching screenshot for reference.

The image shows an error message in an automated workflow, indicating that the "Read Range Workbook" action failed because the specified package is invalid and the main part is missing. (Captioned by AI)
The image shows an error message in an automated workflow, indicating that the "Read Range Workbook" action failed because the specified package is invalid and the main part is missing. (Captioned by AI)1554×648 41.1 KB

2

@shama93,

Can you try to upgrade the UiPath.System.Activities package to latest possible version and try.

3

@ashokkarale
Yeah already using the latest one only

5

Hi @shama93

  1. Try reinstalling the UiPath.Excel.Activities package
  2. If already tried, update the same package to the latest version and select lowest applicable version option in Runtime Rule dropdown.

Hope it helps!!

6

Excel isn’t installed

7

How to select the lowest run time rule.
Can u pls explain in detail.

8

Check the below image to know how to select the Lowest runtime,

The image shows the "Manage Packages" window of UiPath Studio with focus on the "Project Dependencies" tab, highlighting the "UiPath.Excel.Activities" package, its version, and the "Runtime Rule" dropdown menu set to "Lowest Applicable Version." (Captioned by AI)
The image shows the "Manage Packages" window of UiPath Studio with focus on the "Project Dependencies" tab, highlighting the "UiPath.Excel.Activities" package, its version, and the "Runtime Rule" dropdown menu set to "Lowest Applicable Version." (Captioned by AI)1117×622 150 KB

Hope it helps!!

9

Hello @shama93

Perhaps try to remove unused imports - might be one of those that are conflicting.
But take a backup of the file/project first.

image
image377×247 9.57 KB

Regards
Soren

10

Thanq everyone for the replies, the issue is with the excel file. I have replaced the excel file and it worked.

1 Like