How to copy the data from excel and paste into text box one by one

Learning & Development Programs Automation Starter
1

Hi team,

I am new to uipath.

I want to copy the data from excel which contains 10,20,30…etc in one cell and copy to text box.

I have used read range and for each activity and then i used type into activity by adding row(“Number”).Tostring
The problem i am facing is bot entering numbers in a straight manner like 10203040…but i need it to enter one by one (as it is in the cell).

Please help me to solve this issue.

Numbers

Thanks,
Bhagya

1 Like
2

in read range there option for preserve format , make it true and check

3

Hi @Bhagyashree_S

Try this approach

image
image941×555 23.4 KB

Instead of write line activity use the Type Into with text being item variable.

Please refer the xaml

ExcelToTextBox.xaml (7.5 KB)

4

Hi @kumar.varun2

Thanks for your reply.

I tried doing the same but i am getting error below
image

5

Hi @Veera_Raj

I tried the same but still its writing the data in the straight manner

6

can you send me sample excel and expected output ?

7

@Bhagyashree_S

There is a mistake in the assign value

CurrentRow("Numbers").ToString.Split(Environment.NewLine.ToCharArray)

Array should be an array of string

image

Please refer the xaml provided

8

Hi @Veera_Raj

Numbers

Expected output : 10
20
30
40

9

Ok…i have corrected my mistake but if i use writeline activity its executing properly one by one…but when i use type into its executing in a straight manner

10

@Bhagyashree_S

Give it a try

image

11

When i use type into activity …bot is entering one by one…but it has to enter in this way
10
20
30
40

but its entering as 10 and again its removing 10 and again entering 20

12

use append line activity

13

Hi @kumar.varun2

I tried for writing data in notepad…its working perfect

but when i try with my text box where i want to write those numbers its acting differently like entering 10 and next 20 and again deleting 20 and again writing 30…

14

Hi @Bhagyashree_S

Does the text box support the NewLine. Try by pasting the values from notepad into textbox.

15

Hi,

It was working fine when i tried separately but when i am trying to run the entire process…i am getting error as “Type Into ‘Shell shell’: Special keys syntax error. Encountered invalid special key action at text position: 15”

16

Hi @kumar.varun2

Any update on the error?