Getting an error in my first process using studio

Help Studio
1

image
image1395×751 30.5 KB

Can anybody help me ?? I’m facing this error and I don’t know how to fix it

2

Does cell E8 exist in the Excel file?

3

Does your email have attachments? You could set a check for it by placing an If activity with condition

RetrievedEmail.Attachments.Any
4

yes it does, The attachments are saved as well… I don’t know if when starts the process is need have the attachments in email or just saved in folder…

6

all I have to do is add .any ?

7

Yes, just surround your steps with an “If” or “Else If” activity with the condition. Like this:

image
image651×776 16.7 KB

8

Build My First Process With Studio.7z (77,0,KB)
this is my process .zip with attachments ( excel files) , can anybody check it please? Im not sure if my problem due excel app that I’m have not installed cuz I’m using outlook online with excel or libreOffice.

9

Ok I will try this. Unfortunaly Im beginer and just trying to do the foundation certificate. This is my first time RPA so this course leaves a lot of doubts

10

could you please check my process .zip file? and do the changes ? beacuse I have no idea how to do it =(

11

Unfortunately, some dependencies do not load properly on my system so I can’t edit your project directly. Here’s what you need to do: Add the Else If activity to the Body of the For Each loop and drag the existing activities inside the “Then” branch. Click “Add Else If or Else” → “Else” to add the Else branch, and there add a log message.

12

Hi @Wagner_Macedo

Take a look here at the solution proposal

Read Range Workbook: Sequence contains no matching element - Help / Studio - UiPath Community Forum

Cheers

13

Hey,
maybe one of those files is causing the issue?

image
image821×193 4.63 KB

What is it the ‘~lock.Invoice 1.xlsx#’ ?
It’s looks like temporary file or something.

14

You can also take a look to this example:
Build My First Process With Studio.zip (33.4 KB)
I modified your workflow so that it reads data from cell E8 from saved invoices.

15

I dont know but I’ve deleted and it was created automatically probably like temporary I guess

16

thaks I will check it out

17

I found the problem and it was fixed

now Im facing a new problem : Im using workbook and no excel app scope cuz I havent excel app installed in my pc.
but following the tutorial video where I have to use “write cell” this issue happened :

image
image1246×744 54.4 KB

could anybody tell me wht to do?

18

If you haven’t installed Excel app - instead of ‘write excel’ activity you should use ‘write cell workbook’ option.
image

19

thanks man I was doing this , but now Im trying fill it up property lol

image
image1040×514 37.9 KB

Its hard to be begginer lol

20

Workbook path must be in the quotes “D:\Proces…” :slight_smile:
You can also store this value in variable.
image

21

image
image1241×705 60.4 KB

the fields are differents so it make me confused, I dont know why the course dont explain thats “substitutions and potential errors”