USE CASE 2: Generate Claim Report using Modern Design Experience in UiPath || Excel Automation
Time Stamp:
00:00 Intro
00:39 Process Flow
09:10 Start Coding
11:40 Previous year using DateTime function
13:07 Current year using DateTime function
14:02 Dynamic Year folder creation
14:51 Current Month variable using DateTime
15:51 Dynamic Month folder creation
16:52 Current date using DateTime function
17:43 Creating Dynamic folder path
24:49 Checking if Dynamic folder exist or not
33:32 Continue the code
34:14 Start with Excel Activity
35:44 Reading data from Master Sheet
37:30 Sort Premium AMT column in Desc
42:55 Adding Colour to column header cell
#uipath #uipathtutorial #moderndesign #automation #rpa #uipathcommunity
#uipath