Table of Contents.
Version … 15
Update History … 15
Features and Benefits of Utilization. … 15
Features and Advantages of Utilization … 15
Download/Install. … 24
Easy flow create and execute. … 25
Steps … 25
Save Flow and Save As (Copy). … 32
Variables and Test … 34
What is a variable. … 34
Usage Steps … 35
List … 50
Tool for Generate … 50
Create … 50
Operations on already existing List … 55
Match the two Lists … 65
Clear list … 70
Examples of Use … 71
Data table … 73
Tool for Generate … 73
Create … 73
Set variable action. … 77
Operations on already existing data table. … 82
Examples of Use … 100
Conditional Branch.If and Switch. … 102
Use of If and Switch … 102
How to use … 102
Formulas and Operators.How to specify multiple condition designations. … 109
Loop … 113
Loop Actions … 113
Loop control Actions … 119
How to deal with infinite loops … 122
Examples of Use … 122
Subflow … 125
Create … 125
Execution of subflow … 126
Exit Subflow … 128
Install extensions required for Browser automation. … 130
Recorder … 130
Comment … 135
How to use … 135
Situations where comments are effective … 136
Region … 138
How to use … 138
Error (Exception) handling. … 142
Description … 142
What to do when you get into an infinite loop. … 157
How to use line breaks in expressions. … 158
How to use … 158
Launch with administrative privileges. … 161
Steps … 161
Uninstall … 164
Simple example. … 166
Automated basic text file operations. … 166
Transcribing from one Excel book to another. … 173
Example of simple web browser auto-operation: auto-filling a web form. … 183
Variables Actions. … 197
Truncate number. Importance: High. … 197
Generate random number. Importance: Middle. … 201
Increase variable. Importance: High. … 204
Decrease variable. Importance: High. … 207
Flow control Actions. … 209
End. Importance: Middle. … 209
Wait. Importance: Middle. … 211
Stop flow. Importance: High. … 213
Get last error. Importance: Middle. … 215
Label / Go to. Importance: Low. … 218
Run flow Actions. … 223
Run desktop flow. Importance: High. … 223
System Actions. … 229
If process. Importance: Low. … 229
Wait for process. Importance: Middle. … 232
Run application. Importance: High. … 235
Terminate process. Importance: Low. … 240
Ping. Importance: Low. … 243
Set Windows environment variable. Importance: Low. … 247
Get Windows environment variable. Importance: Low. … 250
Delete Windows environment variable. Importance: Low. … 254
Workstation Actions. … 257
Print document. Importance: Low. … 257
Get default printer. Importance: Middle. … 260
Set default printer. Importance: Middle. … 263
Show desktop. Importance: High. … 265
Lock workstation. Importance: Middle. … 267
Play sound. Importance: Middle. … 269
Empty recycle bin. Importance: Middle. … 272
Take screenshot. Importance: Middle. … 274
Get screen resolution. Importance: Low. … 279
Set screen resolution. Importance: Low. … 283
Log off user. Importance: Middle. … 286
Shutdown computer. Importance: Middle. … 289
Scripting Actions. … 292
Run DOS Command. Importance: Middle. … 292
Run VBScript. Importance: Middle. … 297
Run JavaScript. Importance: Middle. … 303
Run PowerShell script. Importance: Middle. … 309
Run Python script. Importance: Middle. … 315
Run .NET script. Importance: Low. … 320
File Actions. … 327
If file exists. Importance: High. … 327
Wait for file. Importance: High. … 330
Copy file(s) . Importance: High. … 333
Move file(s) . Importance: High. … 336
Delete file(s) . Importance: High. … 339
Rename file(s) . Importance: High. … 342
Read text from file. Importance: High. … 352
Write text to file. Importance: High. … 355
Read from CSV file. Importance: High. … 359
Write to CSV file. Importance: High. … 364
Get file path part. Importance: Middle. … 368
Get temporary file. Importance: Low. … 371
Convert file to Base64. Importance: Low. … 374
Convert Base64 to file. Importance: Low. … 376
Folder Actions. … 379
If folder exists. Importance: High. … 379
Get files in folder. Importance: High. … 381
Get subfolders in folder. Importance: High. … 385
Create folder. Importance: High. … 389
Delete folder. Importance: High. … 392
Empty folder. Importance: High. … 394
Copy folder. Importance: High. … 395
Move folder. Importance: High. … 397
Rename folder. Importance: High. … 399
Get special folder. Importance: Middle. … 401
Compression Actions. … 404
Zip files. Importance: High. … 404
Unzip files. Importance: High. … 408
UI automation Actions. … 411
If window contains. Importance: Middle. … 411
Wait for window content. Importance: High. … 417
If image. Importance: Middle. … 422
Use desktop. Importance: High. … 427
Select tab in window. Importance: Middle. … 431
Wait for image. Importance: High. … 435
Hover mouse over UI element in window. Importance: Middle. … 440
Click UI element in window. Importance: High. … 444
Select menu option in window. Importance: High. … 452
Drag and drop UI element in window. Importance: Middle. … 456
Expand/collapse tree node in window. Importance: Low. … 461
If window. Importance: High. … 466
Wait for window. Importance: High. … 473
Get details of window(Data extraction) . Importance: Middle. … 480
Get details of a UI element in window(Data extraction) . Importance: High. … 489
Get selected checkboxes in window(Data extraction) . Importance: High. … 497
Get selected radio button in window(Data extraction) . Importance: High. … 502
Extract data from window(Data extraction) . Importance: High. … 507
Take screenshot of UI element(Data extraction) . Importance: Middle. … 512
Focus text field in window(Form filling) . Importance: Middle. … 517
Populate text field in window(Form filling) . Importance: High. … 520
Press button in window(Form filling) . Importance: High. … 525
Select radio button in window(Form filling) . Importance: High. … 529
Set checkbox state in window(Form filling) . Importance: High. … 533
Set drop-down list value in window(Form filling) . Importance: High. … 538
Get window(Windows) . Importance: High. … 543
Focus window(Windows) . Importance: High. … 548
Set window state(Windows) . Importance: High. … 554
Set window visibility(Windows) . Importance: High. … 560
Move window(Windows) . Importance: Middle. … 565
Resize window(Windows). Importance: Middle. … 570
Close window(Windows). Importance: High. … 575
HTTP Actions. … 580
Download from web. Importance: High. … 580
Browser automation Actions. … 587
If web page contains. Importance: Middle. … 587
Wait for web page content. Importance: Low. … 593
Launch new Internet Explorer. Importance: High. … 598
Launch new Firefox. Importance: Middle. … 604
Launch new Chrome. Importance: Middle. … 609
Launch new Microsoft Edge. Importance: Middle. … 614
Create new tab. Importance: Low. … 619
Go to web page. Importance: Middle. … 622
Click link on web page. Importance: High. … 627
Click download link on web page. Importance: High. … 635
Run JavaScript function on web page. Importance: High. … 640
Hover mouse over element on web page. Importance: Middle. … 643
Close web browser. Importance: High. … 648
Extract data from web page(Web data extraction) . Importance: High. … 650
Get details of web page(Web data extraction) . Importance: Middle. … 656
Get details of element on web page(Web data extraction) . Importance: High. … 660
Take screenshot of web page(Web data extraction) . Importance: Middle. … 666
Focus text field on web pageWeb form filling). Importance: Low. … 672
Populate text field on web page(Web form filling) . Importance: High. … 677
Set check box state on web page(Web form filling) . Importance: High. … 684
Select radio button on web page(Web form filling) . Importance: High. … 689
Set drop-down list value on web page(Web form filling) . Importance: High. … 695
Press button on web page(Web form filling) . Importance: High. … 700
Excel Actions. … 706
Basics … 706
Launch Excel. Importance: High. … 709
Attach to running Excel. Importance: Middle. … 715
Read from Excel worksheet. Importance: High. … 718
Get active cell on Excel worksheet. Importance: Middle. … 724
Save Excel. Importance: Middle. … 727
Write to Excel worksheet. Importance: High. … 731
Close Excel. Importance: High. … 735
Set active Excel worksheet. Importance: High. … 740
Add new worksheet. Importance: Middle. … 743
Get first free column/row from Excel worksheet. Importance: High. … 745
Get column name on Excel worksheet. Importance: High. … 749
Resize columns/rows in Excel worksheet(Advanced) . Importance: Middle. … 751
Run Excel macro(Advanced) . Importance: High. … 755
Get Active Excel worksheet(Advanced) . Importance: Low. … 758
Get all Excel worksheets(Advanced) . Importance: Middle. … 760
Delete Excel worksheet(Advanced) . Importance: Middle. … 762
Rename Excel worksheet(Advanced) . Importance: Middle. … 765
Activate cell in Excel worksheet(Advanced) . Importance: Low. … 768
Select cells in Excel worksheet(Advanced) . Importance: Low. … 771
Get selected cell range from Excel worksheet(Advanced) . Importance: Low. … 776
Copy cells from Excel worksheet(Advanced) . Importance: Middle. … 779
Paste cells to Excel worksheet(Advanced) . Importance: Middle. … 782
Delete from Excel worksheet(Advanced) . Importance: High. … 784
Insert row to Excel worksheet(Advanced) . Importance: High. … 788
Delete row from Excel worksheet(Advanced) . Importance: High. … 790
Insert column to Excel worksheet(Advanced) . Importance: Middle. … 792
Delete column from Excel worksheet(Advanced) . Importance: Middle. … 795
Find and replace cells in Excel worksheet(Advanced) . Importance: High. … 798
Get first free row on column from worksheet(Advanced) . Importance: Middle. … 802
Word Actions. … 805
Launch Word. Importance: High. … 806
Attach to running Word. Importance: Middle. … 810
Save Word. Importance: Middle. … 813
Close Word. Importance: High. … 817
Read from Word document. Importance: High. … 821
Write to Word document. Importance: High. … 824
Insert image in Word document. Importance: Middle. … 827
Find and replace words in Word document. Importance: High. … 831
Database Actions. … 834
Open SQL connection. Importance: High. … 834
Execute SQL Statement. Importance: High. … 837
Close SQL connection. Importance: High. … 841
Email Actions. … 843
Retrieve email messages. Importance: High. … 843
Process email messages. Importance: High. … 848
Send email. Importance: High. … 851
Outlook Actions. … 856
Launch Outlook … 856
Retrieve email messages from Outlook … 858
Send email message through Outlook … 863
Process email messages in Outlook … 867
Save Outlook email messages … 870
Respond to Outlook email message … 874
Close Outlook … 877
Message boxes Actions. … 879
Display message. Importance: High. … 879
Display input dialog. Importance: High. … 885
Display select date dialog. Importance: High. … 890
Display from list dialog. Importance: High. … 898
Display select file dialog. Importance: High. … 903
Display select folder dialog. Importance: High. … 907
Mouse and Keyboard … 909
Block Input. Importance: Low. … 909
Get mouse position. Importance: Middle. … 912
Mouse move. Importance: High. … 915
Move mouse to image. Importance: Middle. … 918
Move mouse to text on screen (OCR) . Importance: High. … 925
Send Mouse Click. Importance: High. … 935
Send Keys. Importance: High. … 939
Press/release key. Importance: High. … 946
Set key state. Importance: High. … 949
Wait for mouse. Importance: Middle. … 952
Wait for shortcut key. Importance: High. … 956
Text Actions. … 959
Append line to text. Importance: High. … 959
Get subtext. Importance: High. … 962
Pad Text. Importance: High. … 965
Trim Text. Importance: High. … 968
Reverse text. Importance: Middle. … 970
Change text case. Importance: High. … 972
Convert text to number. Importance: Low. … 975
Convert number to text. Importance: High. … 978
Convert text to datetime. Importance: Middle. … 981
Convert datetime to text. Importance: High. … 984
Create random text. Importance: Middle. … 988
Join Text. Importance: High. … 991
Split text. Importance: High. … 994
Parse text. Importance: High. … 999
Replace text. Importance: Middle. … 1003
Escape text for regular expression. Importance: Middle. … 1007
Date time Actions. … 1010
Add to datetime. Importance: High. … 1010
Subtract dates. Importance: High. … 1013
Get current date and time. Importance: High. … 1016
Create HTML content … 1020
PDF Actions. … 1026
Extract text from PDF. Importance: High. … 1026
Extract tables from PDF. Importance: High. … 1030
Extract images from PDF. Importance: Middle. … 1033
Extract PDF file pages to new PDF. Importance: Middle. … 1036
Merge PDF files. Importance: Middle. … 1039
OCR Actions. … 1042
If text on screen (OCR) . Importance: Middle. … 1042
Wait for text on screen (OCR) . Importance: High. … 1049
Extract text with OCR. Importance: Middle. … 1056
Windows services Actions. … 1062
If service. Importance: Low. … 1062
Wait for service. Importance: Low. … 1066
Start service. Importance: Low. … 1069
Stop service. Importance: Low. … 1071
Pause service. Importance: Low. … 1073
Resume service. Importance: Low. … 1075
Tips - Text … 1077
How to use line breaks in expressions. … 1077
How to use tab characters. … 1079
How to extract only numbers from text (keep only numbers). … 1081
How to remove numbers from text. … 1083
How to remove text, from the left or right, by specifying the number of characters. … 1085
How to leave text with a specified number of characters from the left or right. … 1089
How to extract characters before, after, or between specific text. … 1093
Tips - Numeric … 1102
Obtain the number, total, average, maximum, and minimum of the numbers in the list. … 1102
Methods for round down, round up, and round off small number values. … 1115
How to judge even/odd numbers. … 1117
How to get absolute values. … 1119
How to get the quotient and remainder of a division. … 1121
Tips - Conditional branch … 1123
How to set IF conditions in Or and And. … 1123
How to get the earlier or later date.Date and time comparison. … 1124
Tips - Date and Time … 1125
How to truncate the time portion from the date and time … 1125
How to get the Previous day, First day of month, End of month, and Number of days in month. … 1126
How to get the day of the week from a date. … 1133
Tips - Microsoft Excel … 1135
How to value paste value in Excel. … 1135
How to get the last row and last column of an Excel book. … 1138
Create a table of contents for sheet names in an Excel book. … 1141
Move to the specified cell in the Excel book. … 1150
Delete rows of Excel with specific conditions. … 1156
Insert empty rows in Excel worksheet, one row at a time. … 1165
How to open Excel in the background. … 1171
How to delete multiple rows/columns in Excel. … 1172
Excel cell format. … 1185
Excel Filter … 1189
How to read an Excel file and process it line by line in a loop. … 1198
Tips - Microsoft Excel - Use Excel to perform calculations efficiently – Text … 1203
How to convert between Roman numerals and Arabic numerals. … 1203
Tips - Microsoft Excel - Use Excel to perform calculations efficiently – Numeric … 1208
How to rank a list of numbers. … 1208
How to get the median. … 1218
How to get the mode. … 1225
How to get the deviation. … 1232
How to get the standard deviation. … 1242
How to get the least common multiple and greatest common divisor. … 1249
Tips - Microsoft Excel - Use Excel to perform calculations efficiently - Date and Time … 1260
How to get the last business day of the specified month. … 1260
How to get the number of business days for a specify month. … 1266
How to get the number of business days within a specified period. … 1271
Tips - File / Folder … 1278
What to do if the specified file does not exist. … 1278
How to deal with the case where the specified file already exists. … 1283
How to convert CSV files to Excel files. … 1289
How to convert Excel files to CSV files. … 1293
How to put today’s date in a folder name or file name. … 1300
How to save the contents of a PDF to a text file. … 1304
How to convert Excel and PDF files to each other. … 1305
Tips – E-mail … 1314
Sending and receiving Gmail … 1314
Send newsletter. Email one line at a time from an Excel book. … 1319
How to record the contents of an incoming email line by line in an Excel book. … 1325
Specify date range to retrieve mail. … 1331
How to save email attachments to a specific folder. … 1335
Tips – URL … 1347
URL encode/decode. … 1347
How to send e-mail to multiple addressees. … 1350
How to leave only the GET parameter from the URL. … 1351
How to convert URL parameters (GET parameters) into Data table. … 1360
How to remove URL parameters. … 1374
Tips - Other … 1378
How to use ChatGPT. … 1378
How to get the number of items in a List (array). … 1383
Data type … 1384
Data type:Datatime … 1384
Data type:Mail Message … 1386
Data type:Outlook Mail Message … 1387
Data type:File … 1387
Data type:Folder … 1390
Others … 1392
How to get an API key (secret key) for ChatGPT. … 1392
General URL rules. … 1396