Exctracting information from Excel DataTable

Hi @CamiCat,
Below I have specified the invoke work flow parameters

Regards
Balamurugan

1 Like

Unfortunately I don’t find the variables that appear in your workflow.


There is the Wrong Excel scraped:

Maybe have you sent me not the latest version?
Thank you so much, :relaxed::relaxed:

Hi @CamiCat,

Here I have attached the source.

File :Camicate.zip (60.7 KB)

Regards
Balamurugan

Hi @CamiCat,
Make this change. In that source I have passed the column value directly instead of the variable.

Regards
Balamurugan

1 Like

Ok @balupad14.
Thank you so much for your kind help.I’ll try and let you know :slight_smile:

1 Like

HI @CamiCat,
I am really very happy to support to your live project.

Thank you
Balamurugan

1 Like

Thank you so much @balupad14.
It’s a real live project; I collected the requirements of the project last week, so this part is only the beginning of the project.
I should then enter in SAP and insert some data.
:blush:

1 Like

Hi @CamiCat,

https://forum.uipath.com/t/type-into-in-citrix/33996

The above the issue. Instead of using SendHotKeys try TypeInto Activity “[k(tab)]”

image
Can you tell me the full name of the namespace.

Regards
Balamurugan

1 Like

Hello @balupad14.
This is the full name of the namespace:


Have you got time to check it?
Thank you so much,
Camilla. :slight_smile:

Hi @CamiCat

Yes a little.

As I under the problem that is not able to get focus of the window. Am i right ?

InvokeCode Activity we can populate data. using it can pass the value to the activity and can get the value from it.

Regards
Balamurugan

1 Like

It finds the correct place where to insert the data but it enters the wrong digits, maybe it inserts them too rapidly.
In InvokeCode activity we pass the Banca and Agenzia string, and als the data strings…adnd it insert the values maybe too rapidly.
Thank you so much,
Camilla :slight_smile:


For example in this case it should have written 21-05-2018.
I don’t know why it doesn’t work.
Thank you so much @balupad14.
Camilla

Hi @CamiCat,
The the 21-05-2018. you will receive directly as a string or you calculate it before assign value.

Regards
Balamurugan

1 Like

Sorry , it is 21-03-2081.
I insert it as a string which I know from the Excel Input File.
It inserts the wrong date :frowning:
Thank you @balupad14

Hi @CamiCat

Sorry to ask this. I Hope you did this.
Have you tested the date by Messagebox activity before insert

Regards
Balamurugan

1 Like

Yes, the date that should be inserted is the correct one.
Can I pass you the workflow so that I can have a watch on it?
Thank you so much,
Camilla :slight_smile:

Hi @CamiCat,

Yes you can. !!

Regards
Balamurugan

1 Like

Hello @balupad14.
I attach here the Workflow I was referring to.
Inserimento Banca e Agenzia.xaml (8.7 KB)
Thank you so much,
Camilla :slight_smile:

Hi @CamiCat ,
You have used the two different way the send keys. In this work flow, I don’t the exact problem.

Are you mean that the problem is in focus ?

in the Send hotkey, It has the property called WaitForReady . Can you try with value “Completed”.

Regards
Balamurugan

1 Like

Thank you @balupad14.
The problem is that sometimes the Data inserted is wrong.
I’ll try with your suggestion and let you know.
Camilla :blush: :slight_smile: