Excelactivitesin uipath

Help Activities
1

While using excel if we are having some data like Delhi, Bangalore in one column can we replace comma with or in Excel sheet

2

You can do it in multiple ways
in excel you can go to data tab on ribbon and select Text to column, then you can choose the delimiter as “,” ans then you’ll get the values splitted

in UiPath →

You can read the data using Read Range
Loop it using For Each Data Row

then for that column you can take the value in a variable, using row(“columnName”).tostring

row is the for each data row variable, can be different for you

then you can use split function
yourTxtVariable.Split(“,”)

This will give you an array, that array element csn be accessed using their index
arrData(0).toString
arrData(1).toString
and so on

3

Hi @Jyothi1

Welcome to Community!

I have created a sample work flow based on your use case!

Refer below!

ColumnValue_Replace.xaml (6.5 KB)

Regards

4

IMG_20211021_003202
IMG_20211021_0032021549×511 312 KB

There how can we replace comma with or

5

actually that file is not opening

6

how can i refer plz give the solution

7

i did this with bala reva there we can find and replace the text but its not giving the output and also there were no errors just executing the bot but in the excel there were no changes

8

Hi @Jyothi1

Refer the steps below.

Read Range the Excel using Read range Activity.

For Each row in datatable of read range DT

Use Assign

Currentrow(“YourColumnwithComma Separted Value”)=if(CurrentRow(“YourColumnwithComma Separted Value”).ToString.contains(“,”),CurrentRow(“YourColumnwithComma Separted Value”).ToString.Replace(“,”," or"),CurrentRow(“YourColumnwithComma Separted Value”).ToString)

Then Write Range with Read range path and read range Dt.

image
image842×630 27.4 KB

Regards

9

thank you so much for ur efforts about this doubt.i will work on it if i get the answer i will intimate

10

Hi @Jyothi1

Does its helps for you?

Regards

11

yeah ,will u please help me regarding my doubts can u share ur knowledge

12

may i know ur contact details to communicate

13

@Jyothi1

Please mark solution to the post which you find useful and close this thread so it may helpful for others!

Regards
Calvin

14

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