UiPath for Kids Episode 8 - Excel formulas for school
ฝัง
- เผยแพร่เมื่อ 5 ก.ค. 2024
- This video is about working with excel files from UiPath. It shows how to read excel files and write excel formulas from UiPath bots. It also uses conditions to select certain information from a table in excel and showcases a few string formulas to get the job done.
00:01 Topic and summary of the video
00:26 UiPath Hacks for Kids intro theme
00:53 Exploring the excel file and the problem to be solved
02:25 Building the bot to work with excel formulas
03.28 The CountIF excel formula
04:10 The Write Cell activity
06:36 The Read Range activity
08:04 The For Each Row activity
13:24 The Substring function
14:29 Wrap-up and conclusion
Let us keep in touch:
/ gabrielverzea - วิทยาศาสตร์และเทคโนโลยี
The fraction numbers up to one thousand are not typed properly in the excel sheet using the select item activity in the drop down menu, some numbers are missed please help
Hi. I am not sure I understand the problem. Which menu entry are you trying to access ? Do you have one example ? Thx !