UiPath Tutorial 08 B - Write data to excel if the condition is met| Difference b/w excel & workbook

This video shows a demo on how to write whole data row from one excel to another if a certain condition is met. Parallelly, it also explains the difference b/w excel & workbook activities in UiPath.
Introduction video to read and write data to Excel -
• UiPath Tutorial 08 A -...
Compare two excel sheets and update the cells with Lookup Data -
• UiPathTutorial 29-Comp...
Compare Excel Sheets or Data Tables and Remove/Delete Matching or Duplicate Rows -
• UiPath Tutorial 30- Co...
=========================================================
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A1...
Automation Anywhere A2019 Tutorial Playlist:
• Automation Anywhere A2019
UiPath Tutorial Playlist:
• UiPath Tutorial
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764
Connect with me for some interesting updates here -
LinkedIn - / quality-assurance-lab-...
Facebook - / quality-assurance-lab-...
Twitter - / labassurance
Medium - / labassurance

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@abhimansahoo2211]

Hi, Can you please make more videos of use cases about excel and put those excel and main file in Github. It would be really grateful.

[@3mmarutobloot706]

may i contact you using email or whatsapp so you can help me folowing your tutorial

[@lucietasova2462]

Your videos always help me! They are not that easy neither that difficult - ideal combination for someone that is looking for real life scenarios :))

[@nicoderme99]

Awesome video!!!! Thanks for info is very useful and clear!

[@Alimudin2011]

Thanks Madam for great explanation

[@WhoisNicko1]

Thanks for the video. Is there a way to add data row of all the row without needing to add one by one the column names?

[@waldemarzielinski6958]

thanks a lot

[@rasipogulabhaskar9858]

compare edureka your explanation great super... thank u madam

[@mokindbhosle1909]

Very Useful video....👌👌👍👍😊😊

[@user-em5sk5oe3b]

very good and useful video.

[@athulanand7385]

i have a doubt what should we do to seperate by a status(complete/incomplete) instead of slary

[@VinayKumar-gt9di]

Hi mam unable to get active "row" in if activity for cint(row("Salary").tostring) >10000

[@truptidangra8291]

How to add a column and in rpa challenge after completing every round it should fill completed in excel status column can you plzzz tell?

[@prasadhrv]

Thanks, Madam, for great explanation. I have a question can we use directly write range activity if condition met? without using the second datatable.

[@qualityassurancelab7764]

Write Range activity takes datatable as input, it writes data to excel from the datatable. So, first write in datatable one by one. At the end, use write range activity

[@divya-tg2bn]

By using if condition i need to write for true cell write as valid andfor false cell write as duplicate so in if condition what i should write

[@sruthikolla9217]

The file has run successfully without any error's but the output result excel file is n't created in UI Path folder can anyone help on this pls!

[@qualityassurancelab7764]

Please debug your project by following below process: Add Output Data Table after For each row. In that activity, Provide the result datatable in Input -> Data Table property. Create output string variable under Output -> Text property ;say resultAsString Display the resultAsString in message box Let me know if the datatble values are displayed in message box

[@mohanagrawal216]

One small query. For the second data table variable, whey didn't we create it as a variable rather than assigning data to it and then clear it and then use it?

[@qualityassurancelab7764]

assigning data to datatable and then clear it keeps the column names. If you create the datatable, you will have to manually add the column names. So, I followed the first approach. However, the second one is also correct

[@KunalKumar-tt4bt]

excellent

[@burak3298]

thanks

[@MayurShinde-tv9sp]

I have a doubt why we used read range for result datatable and cleared it again by using clear data table

[@stupidpersona2128]

I am getting error in IF condition I don't know why???? It's saying here that "compile error encountered processing expression"

[@jishnukrishnanbr3822]

How can i write the If Condition if it is not an integer

[@qualityassurancelab7764]

If Condition is not specific to integer, you can write other conditions too in the If activity. Let me know what condition you want to put in If activity

[@maikjunior2811]

Please add subtitle to your videos. Thank you so much for the great content!

[@Vk-gm1ox]

Olá, poderia explicar por que usamos CInt (Row ("Salary"). ToString)> = 10000 para a função de string

[@Vk-gm1ox]

Muito obrigado senhor

[@amit_charjan]

How to create these row() functions These row() function is not available.

[@radenbayuherlambang3898]

How to add column with condition, for example Colom A dan B Not equal then "Not Ok" else " Ok" ?