Awesome bro Thank u for ur quick response.we have Uipath learning group. We are referring ur videos. it is very useful for us.keep up the great work. Thanks a lot!!!!!!
Hi Rakesh, please let me know if you have any recorded sessions of expo hub, or you provide classes online because I want to learn UiPath and Python separately from you, if possible for you.
Hi Vikrant pls visit my channel playlist and start your learning journey for uipath th-cam.com/video/mT_sJfhXCeA/w-d-xo.html and for python: th-cam.com/play/PLhTE7-JU1rhYcEwPwQ3iJ_CShL-P0gfd3.html
There is another simple way I can think of : lets say you would like to write in cell D1 the out of (sum(B4:B7)). All you ned to do is use a "write cell" activity and in the "value or formula" field write "=sum(B4:B7)". By writing the excel formual you will be to get the sum of specific values.
Please do visit our video section: th-cam.com/users/UiPathExpoHubvideos To read chapter wise visit our playlist: th-cam.com/users/UiPathExpoHubplaylists
When i tried this, i got error saying "Assign: Conversion from type 'DBNull' to type 'Integer' is not valid."but my excel is not null. what is the solution for this?
Hello, I watch all your videos and got a bunch of knowledge through it.... till now I never done Email automation. As per your guidance I changed all the settings but I'm unable to find the "Less secure apps" in gmail. so I'm unable to move forward. Please help me solve this issue.
Hello, your videos are good! Can you help me with calculating the sum of the columns from different sheets? And with the condition that the excel sheet cannot be edited, but to store the values of each row (their total from the sheets) into google form :)
Hi Sir, i am getting error where i am finding average from webtable if i use average formula i am getting non- invoice function method, row does not exist in current context can you please help me out sir
Awesome bro Thank u for ur quick response.we have Uipath learning group. We are referring ur videos. it is very useful for us.keep up the great work. Thanks a lot!!!!!!
I hope all of you have subscribed to Uipath ExpoHub
How do avoid the rounding error of using CInt() if you have decimal values in your column?
Hi Rakesh, please let me know if you have any recorded sessions of expo hub, or you provide classes online because I want to learn UiPath and Python separately from you, if possible for you.
Hi Vikrant pls visit my channel playlist and start your learning journey for uipath th-cam.com/video/mT_sJfhXCeA/w-d-xo.html and for python: th-cam.com/play/PLhTE7-JU1rhYcEwPwQ3iJ_CShL-P0gfd3.html
thank you Rakesh its very useful.
For example If we need to add , only from B4 to B7 what we have to do in this case
There is another simple way I can think of : lets say you would like to write in cell D1 the out of (sum(B4:B7)). All you ned to do is use a "write cell" activity and in the "value or formula" field write "=sum(B4:B7)". By writing the excel formual you will be to get the sum of specific values.
Please do visit our video section: th-cam.com/users/UiPathExpoHubvideos
To read chapter wise visit our playlist:
th-cam.com/users/UiPathExpoHubplaylists
@@AutomatewithRakesh Thank you
Nice explaination
Sir, may I know how to sum the item of each column in multiple sheet?
for some reason my A = A+Cint(CurrentRow(1)) is not adding up the values. A get back to 0 for the next row
When i tried this, i got error saying "Assign: Conversion from type 'DBNull' to type 'Integer' is not valid."but my excel is not null. what is the solution for this?
May be cell format has an issue. Try to do the same by creating a new excel file or try to change the cell format
@@AutomatewithRakesh Even i had the same issue that is due to Create Table which was created. After changing to other sheet it worked.
Hi there, Can you please share your files in Description so that we can practice with your Uploaded Video.
Thanks.
Sure I am doing it for all the recent uploads. For this one I am missing the input files
@@AutomatewithRakesh Thank you so much!!
Hello, I watch all your videos and got a bunch of knowledge through it.... till now I never done Email automation. As per your guidance I changed all the settings but I'm unable to find the "Less secure apps" in gmail. so I'm unable to move forward. Please help me solve this issue.
Hi RamShiva use this video as the settings have changed for Google: th-cam.com/video/O9dVTI1n3qM/w-d-xo.html
very useful, but the thing is we pause the video and try to understand smoothly, for each expression.... thank you @Rakesh UiPath MVP
Thank you :)
Most welcome
can use for big row or column data such as 50.000 row data
bhai kamal is sai achi video kahi nai mille gi kia baat ha apki this is best of the best
Hello, your videos are good! Can you help me with calculating the sum of the columns from different sheets? And with the condition that the excel sheet cannot be edited, but to store the values of each row (their total from the sheets) into google form :)
Thank you, will try to create one
completedddddddd
Thank you!
Good Job, Conitnue the learning journey!
Thanks a lot sir..
Hi Rakesh as usual you rock! Thanks
Thank you Alfred for writing I am I’m grateful
Keep up the good work, learnt so much from ur videos. With this video how I can get decimal values 2345.56+ 1234.11=3579.67, .67 is not coming.😊
Thank You so much 👍👍
I had sent an email regarding an error, Please give me reply. Thanks In Advance
Thank you . This is very helpful!!
You are welcome
Hi Sir, i am getting error where i am finding average from webtable if i use average formula i am getting non- invoice function method, row does not exist in current context can you please help me out sir
How can we sum figures in a datatable based on criteria in UiPath Studio?
very good explanation
Hi Rakesh can u do one video searching two values from excel say two cities and set color to red and delete frim the excel file
Sure will do
Thank you so much Rakesh
Good Progress, you are making daily! Continue to Learn- Happy Automation Mohd.