Use Excel File: Microsoft Office 2010 or newer is required

Help Studio
, ,
1

Hi, I am trying to automate data entry and using WPS to read the data but getting an error. Am I doing anything wrong here?

Use Excel File: Microsoft Office 2010 or newer is requiredUse Excel File: Microsoft Office 2010 or newer is required

The image shows an automation workflow in UiPath Studio designed to read and display rows from an Excel sheet, with an error message indicating that Microsoft Office 2010 or newer is required. (Captioned by AI)
The image shows an automation workflow in UiPath Studio designed to read and display rows from an Excel sheet, with an error message indicating that Microsoft Office 2010 or newer is required. (Captioned by AI)1157×775 43.2 KB

2

These are modern activities you can check excel package and see the pre requisition required
Alternative approach you can use now is you can use workbook activities
Try using that thanks
@Adarsh_mamidi

1 Like
3

@Adarsh_mamidi,

Excel activity works only when there is Microsoft office is installed on the system and you are having WPS which can’t be automated through this.

You can use Workbook activities which don’t require office to be installed.

1 Like
4

The image shows a UIPath workflow with an error message in the output panel, indicating that the user does not have permissions to open the "challenge.xlsx" file from OneDrive in the browser. (Captioned by AI)
The image shows a UIPath workflow with an error message in the output panel, indicating that the user does not have permissions to open the "challenge.xlsx" file from OneDrive in the browser. (Captioned by AI)1147×778 50 KB

Thank you. It seems to be working until I get this error 11/10/2024 00:25:04 For Each Row in Workbook: You do not have permission to open this file in the browser.

I have given the editor access and access to anyone with the link options, but still I get this error.

5

@Adarsh_mamidi,

Select the Sheet name from the Plus icon at the end of the Range text box. The Sheet name should be like this without ""

The image shows a configuration for iterating through rows in an Excel workbook using Microsoft Power Automate, including a step to log messages for each row. (Captioned by AI)
The image shows a configuration for iterating through rows in an Excel workbook using Microsoft Power Automate, including a step to log messages for each row. (Captioned by AI)831×939 31.6 KB

6

The image shows a workflow in an automation tool where a range is read from an Excel workbook and then a loop iterates through each row displaying a message box with the "FirstName" column value; however, the range value in the loop is not specified and creates an error. (Captioned by AI)
The image shows a workflow in an automation tool where a range is read from an Excel workbook and then a loop iterates through each row displaying a message box with the "FirstName" column value; however, the range value in the loop is not specified and creates an error. (Captioned by AI)915×682 32.5 KB

Thank you. I am not able to see the sheets automatically to directly select the sheet

7

@Adarsh_mamidi,

Clear the value first

This image shows a Microsoft Power Automate Desktop flow configuration step where an action is set to iterate through each row in a specified Excel workbook and log a message for each row, with a context menu option to "Clear Value" circled in red. (Captioned by AI)
This image shows a Microsoft Power Automate Desktop flow configuration step where an action is set to iterate through each row in a specified Excel workbook and log a message for each row, with a context menu option to "Clear Value" circled in red. (Captioned by AI)1025×936 37.9 KB

Click on that dropdown button and see the sheet name available there. Select that.

This image shows a "For Each Row in Workbook" activity in Microsoft Power Automate Desktop, configured to loop through rows of the Excel file "Test Workbook.xlsx" and log each row's first column value. (Captioned by AI)
This image shows a "For Each Row in Workbook" activity in Microsoft Power Automate Desktop, configured to loop through rows of the Excel file "Test Workbook.xlsx" and log each row's first column value. (Captioned by AI)813×932 31.7 KB

8

The image shows an automated task in progress using UiPath to iterate through rows of an Excel workbook named "challenge.xlsx" stored in Microsoft OneDrive & SharePoint, displaying each row's "FirstName" in a message box. (Captioned by AI)
The image shows an automated task in progress using UiPath to iterate through rows of an Excel workbook named "challenge.xlsx" stored in Microsoft OneDrive & SharePoint, displaying each row's "FirstName" in a message box. (Captioned by AI)785×544 21.6 KB

Thank you. Tried it, but for the last 10 minutes, it has been loading. Any alternatives in this situation

9

@Adarsh_mamidi

Can you please tell what you want to acheive

Read range workbook worked because it does not need excel installed in anyway

If you want to manipulate something then use for each row in datatable and manipulate the data and then use write range workbook to write back

The for each you are using is a sharepoint or onedrive one for which you need to have a sp or one drive and all permissions are to be provided

Cheers

10

@Adarsh_mamidi,

Try typing the sheet name directly.

11

Hi @Adarsh_mamidi , instead of using ‘For each row in workbook’', try to use ‘For each row in data table’ activity

12

Try yank bf using work book activity and for each row in data table

Also add kill excel activity before this excel scope activities started
Also if possible store everting into variable excel path and sheet name and assign the variables there @Adarsh_mamidi