Error indicating in Excel file

Help Studio
1

Hi,
I’m new to UiPath and StuidoX and I have a problem when I want to select a value in a linked Excel table. I click on the plus sign in the “Type into” function under “Type this” and select the Excel file, but as soon as I hover the mouse over the Excel file, the screen switches to the open Excel file, and I can’t select anything there.

If I haven’t opened the Excel file yet, I can hover the mouse over the Excel file and also select “Indicate in Excel,” but then I receive the following error message.

Error indicating in Excel
Error indicating in Excel744×215 29.5 KB

Can someone help me here?

Thank you very much and kind regards.

2

@niklas.blumenthal ,

please kill the excel process as shown in below picture before starting the process!!

kill_process
kill_process942×256 13.1 KB

hope it is helpful!!
cheers!!

3

Hi @niklas.blumenthal

Couple of things

May i know what exactly is your requirement?? Please keep following points to debug your issue

  1. Type into activity is used to type something to a UI Field. For example text field in a web page. To write something into excel - you need to use Write Cell activity which comes under the excel package.

Use Excel Application and then write cell.

  1. regarding the indicate in excel

I would say it is not as stable as other excel functionalities in the StudioX. You can give custom input also. no need to indicate if it is not working

You can refer below screenshots if you are trying to write something to an excel using StudioX

image
image1191×283 29.7 KB

image
image1062×655 71.8 KB

4

Hi,

thanks for your answers but unfortunately none of them could solve my problem.

Maybe I should give you a little bit more context:
The process is part of the RPA Citizen Developer.
I understand the theory of the process but it is frustrating that I am not able to build the process on my own in my StudioX.
It is not possible for me to choose cells of the connected excel file because StudioX is not able to open it.

error opening excel in StudioX
error opening excel in StudioX1680×577 103 KB

It worked in the past but unfortunately just until yesterday.
I would appreciate it if you have any more ideas how to solve this problem.

kind regards

5

You can close excel and try the same OR open the excel and see the indicate in excel is working fine or not

OR

I would suggest - Don’t depend on the Indicate in Excel. Open the excel manually and identify the cell address where you want to write

use Custom Input and do the same manually. Result is same as indicating

6

Unfortunately these two options don’t work for me because as soon as I hover the mouse over the word “Excel”, the screen switches to the open Excel file, and I can’t select anything there.

And if I do not open the Excel File, I get the error message shown in my first message.

7

You shouldn’t be doing UI automation in Excel (clicking and typing). You should be using the Excel activities. I suggest doing the free training at academy.uipath.com

By the way, that error appears when you have your cursor in the value/formula box or have double clicked a cell.

image
image533×106 4.28 KB

8

I have experienced this issue sometimes in StudioX. Its not pretty stable while indicating in excel

What I do normally is close the excel and remove the dependency of Studiox suggestions and input the details manually using Custom Input. If this option is not working - I might need to see to have more insights on the issue

9

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