I have watched all of your videos.....great work......very very thankful to you....could you explain about a complex project involving pdfs, excel email, error handling techniques and all
I created a process to execute on multiple excel rows using “for each row”. It works fine except that it doesn’t repeat for the next rows. The process involves submitting one form and then it loads another page after which I’m done with one row. I added an activity to go back to the first page after the first row tasks are done. However, it still doesn’t repeat. When I remove the form submission on page one, the process repeats for all rows (form filling of all rows on single page minus submission and second page activities). What do you think I’m missing here?
Using Read Range activity, you can read the data from a worksheet and store them in data table. Please checkout this video for a quick reference- th-cam.com/video/XmQlvzaHgIw/w-d-xo.html
In Incur the below error when I Remove "message box" above the "invoke method". But when there is "message box" above the "invoke method", its working fine. I am confused why error occurs when message box is removed. Please help me on this..
Hi, (we still do not know your name :) ) thank you for this tutorial. You really trying to cover everything with nice and easy examples and in the end we have small project. Feels really nice! I have question - Ui Path provides so many possibilities to work with data tables and I get impression that excel package can satisfy all our needs. When or in what cases are each package (activity like Data table, excel, workbook) is better to use and have advantages working with tables? P.s could you make some examples with time and date manipulations. In business it is quite often and handy to know how to manipulate with date and time. Many thanks again!
Hello there, thanks again for such nice words, means a lot to me! First lets discuss the scenarios where to work with excel or Workbook package - To work with Excel package, Excel should be installed on the system . And, Excel Activities require excel to be open to perform any action Whereas, to work with Workbook package, Excel need not be installed on the system . Workbook Activities do not require excel to be open to perform any action . So, in case Excel Application is not installed on the system , or, you don't want to open up excel during execution, go with workbook package, otherwise, go with excel package. Now the Data table package - Data table package has activities to work on Data Table Variables. Using Data table package, You can manipulate rows and columns of a datatable variable , filter the data and get the required data from a data table variable, merge 2 or more data table variables and so on. Once the data manipulation of the data table variable is done using Data table Activities, you acn write the data table variable in the excel using Excel or workbook package. Hope this helps, please let me know for any further query. I will plan for the video to manipulate with date and time.
Hi, could you please let me know what text you added inside the message box? If the project flow same as shown in the video, and at the end (after for each loop) you added a message box?
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!
Very nice explained, useful....👌😊👏👏
Hi madam, now im studying uipath in RPA. Also watching your uipath video. Really very useful to learn more. Thanks.
after listing the class iam easily able to do uipath process using activites
thanks mam
Loved your instructional video, it's crystal clear and builds a strong foundation for newbies. Thank you, madam
Thanks. Simple to understand. Please make more videos on UiPath.
Thank you so much ma'am for this amazing content
very informative and explanatory...thanks for the video
U r classes are very easy to mingle...
Mam.. Thanks for uipath series.. Learning material like this needed especially during lockdown.. Starting Uipath from today :)
You are welcome, All the best for UiPath, let me know if you face any issue.
@@qualityassurancelab7764 sure, thanks.
Super video mam! Clear Explanation
Thank you, keep learning!
Thank you! Good explanation
I have watched all of your videos.....great work......very very thankful to you....could you explain about a complex project involving pdfs, excel email, error handling techniques and all
I am glad that the videos are helpful to you, I will plan for the videos on complex projects
Good Explanation and Easy to understand. :)
Thank you so much!
Hello Mam,
I am not getting row option in uipath studio.
Please guide me for that.
Thanks
Not getting excel application scope for excel in ui path any specific reason
Hi how to add row to data table without adding columns in build data table... If we don't know the columns.
If you are trying to build a data table using Build Data table activity, you must know about the columns
I created a process to execute on multiple excel rows using “for each row”.
It works fine except that it doesn’t repeat for the next rows.
The process involves submitting one form and then it loads another page after which I’m done with one row. I added an activity to go back to the first page after the first row tasks are done.
However, it still doesn’t repeat. When I remove the form submission on page one, the process repeats for all rows (form filling of all rows on single page minus submission and second page activities).
What do you think I’m missing here?
instead of generating a data table, how to generate data table in existing worksheet.?
Using Read Range activity, you can read the data from a worksheet and store them in data table. Please checkout this video for a quick reference- th-cam.com/video/XmQlvzaHgIw/w-d-xo.html
In Incur the below error when I Remove "message box" above the "invoke method". But when there is "message box" above the "invoke method", its working fine. I am confused why error occurs when message box is removed. Please help me on this..
Could you please share your project at labqualityassurance@gmail.com?
Hi mam,
Iam getting error as "empname doesn't belong to table table name"
Can you please check this and give the solution
Sry I have made a mistake and I fixed 👍
@@reddy4568 Thanks for confirming
How to delete the connection between activities in flowchat?
Hi, (we still do not know your name :) ) thank you for this tutorial. You really trying to cover everything with nice and easy examples and in the end we have small project. Feels really nice!
I have question - Ui Path provides so many possibilities to work with data tables and I get impression that excel package can satisfy all our needs. When or in what cases are each package (activity like Data table, excel, workbook) is better to use and have advantages working with tables?
P.s could you make some examples with time and date manipulations. In business it is quite often and handy to know how to manipulate with date and time.
Many thanks again!
Hello there, thanks again for such nice words, means a lot to me!
First lets discuss the scenarios where to work with excel or Workbook package -
To work with Excel package, Excel should be installed on the system
. And, Excel Activities require excel to be open to perform any action
Whereas, to work with Workbook package, Excel need not be installed on the system
. Workbook Activities do not require excel to be open to perform any action
.
So, in case Excel Application is not installed on the system , or, you don't want to open up excel during execution, go with workbook package, otherwise, go with excel package.
Now the Data table package -
Data table package has activities to work on Data Table Variables. Using Data table package, You can manipulate rows and columns of a datatable variable , filter the data and get the required data from a data table variable, merge 2 or more data table variables and so on.
Once the data manipulation of the data table variable is done using Data table Activities, you acn write the data table variable in the excel using Excel or workbook package.
Hope this helps, please let me know for any further query.
I will plan for the video to manipulate with date and time.
HI ,
After for each row, I had inserted message box and it is only displaying the last row in the data table , Can u please help.
Hi, could you please let me know what text you added inside the message box?
If the project flow same as shown in the video, and at the end (after for each loop) you added a message box?
For new version to add data row use new object[]{"kim",29,7000}
it display only.. ok as output not show empname age and salary
Have you added in the message box the string variable which was used in output datatable Activity?
Hi, i'm getting the error get row item int32 cannot convert from system double. Please help.
Please let me know at what activity you got this error and what input you provided in that activity
Mam r u provide paid classes?