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
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
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?
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
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
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!
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.
may i contact you using email or whatsapp so you can help me folowing your tutorial
Your videos always help me! They are not that easy neither that difficult - ideal combination for someone that is looking for real life scenarios :))
compare edureka your explanation great super... thank u madam
Awesome video!!!! Thanks for info is very useful and clear!
Very Useful video....👌👌👍👍😊😊
very good and useful video.
Thanks Madam for great explanation
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!
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
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?
Thanks, Madam, for great explanation. I have a question can we use directly write range activity if condition met? without using the second datatable.
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
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?
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
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
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?
How can i write the If Condition if it is not an integer
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
i have a doubt what should we do to seperate by a status(complete/incomplete) instead of slary
How to create
these row() functions
These row() function is not available.
I have a doubt why we used read range for result datatable and cleared it again by using clear data table
Please add subtitle to your videos. Thank you so much for the great content!
Olá, poderia explicar por que usamos CInt (Row ("Salary"). ToString)> = 10000 para a função de string
Muito obrigado senhor
Hi mam unable to get active "row" in if activity for cint(row("Salary").tostring) >10000
How to add column with condition, for example Colom A dan B Not equal then "Not Ok" else " Ok" ?
I am getting error in IF condition I don't know why???? It's saying here that "compile error encountered processing expression"
excellent
thanks a lot
thanks