Excel particular column

Help
, ,
1

i need to extract a paticular column in a excel where in that column i need to fetch particular value like if column contains

table
i need to get particular jasmine alone how can put conditions?any suggestions?

2

@priyankavivek

Use below code in try catch and catch invalid operation exception

Try{
Dt =dt.select(ā€œcolumnname= ā€˜jasmineā€™ā€).copytodatatable

Dt = dt.totable.defaultview(false,ā€œcolumnnameā€) (just check dt.totable or dt.table):relaxed:

Catch{
Column dose not contain jasmin
}

Let me know if i can assist you further.

Regards
Aditya

3

can u please explain bit moreā€¦on this or share xml?

4

@priyankavivek

Use assign stage like below

dt = dt.select(ā€œyourcolumnname=ā€˜jasmineā€™ā€).copytodatatable

This will return exception if there is no record (cell in this case) in column.

So if above equation is successful then
Use
dt = dt.totable.defalutview(false, ā€œyourcolumnNameā€)

Above equation will return datatable with single column

This is your answer :relaxed:

2 Likes
5

@priyankavivek Here you go ExcelCondition.zip (24.8 KB)

1 Like
6

@priyankavivek
Have you tried lookup Range which will provide you with the found cell. Pass it to Read Column and take it from there.

1 Like
7

iwasnt able to open them

8

@priyankavivek What error you are getting

9

loads on restoring dependent

10

@priyankavivek Which version of uipath you are using

11

2019.6.0

12

@priyankavivek Try this

  1. Create one project and in the created project delete xaml file.
  2. Copy xaml and excel file from the downloaded folder and paste it into the newly created project folder.
1 Like
13

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