Conditions

Help Studio
, , , ,
1

HI Community!
I’m Having doubt,

Read data from Excel If conditions are met, paste the value into Word.

Please can any one help me with snapshots

2

Hi @Rohith_Shastri

Can you elaborate you query little bit?

For my understanding

  1. Use Read Range activity → Store it as DtBuild

  2. Use For each Row in DataTable activity

  3. Use If activity → CurrentRow("Column Name").ToString.Contains("Your Input String")

Then → Update the docs
Else → Left it as empty

Check out the reference Image

image

Regards
Gokul

3

Thank you for quick response,

Fr your better understand ill give the example like

Marks Data is there in the Excel so If the student marks above 60% that data should be written in the Word documents.

for this can you share me with the snapshots please

4 
CInt(CurrentRow("Column Name").ToString)>60

image

@Rohith_Shastri

6

If the condition met then data should entered in the word document
In your flow I’m not able to find word document flow
directly you’re given the message box to display

Actually what i need if the condition met that data should be entered in the word document

7

Hi @Rohith_Shastri

Check out these docs and video to update or Insert the data in the Word document

https://docs.uipath.com/activities/docs/manage-word-documents

Regards
Gokul

8

Thank you buddy

9

Thank You Buddy

10

Have you issue resolved @Rohith_Shastri , If yes kindly close the topic by mark as solved. It will helps other too.

Regards
Gokul

11

Hello @Rohith_Shastri

Are you trying to write some table to the Word document?

You can do as below.

Read range and get the data to datatable variable
Use Filter datatable and filter based on condition.
Use Word activities to write to word du=ocument.

Thanks

12

Thank yu buddy

13

I did it

once again thank you for your support

14

Kindly close this topic by mark as solved. It will help for others too. @Rohith_Shastri

15

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