Comparison of Shadow Blade RPA Commands with Python Code

Shadow Blade RPA Commands

Shadow Blade RPA is a software that can simulate human operations on a computer, such as mouse clicks and keyboard inputs, to achieve office process automation.Shadow Blade RPA commands are a set of instructions for these operations, which can be programmed and configured to perform specific tasks across different applications.These commands can be managed and used through the “My Commands” option in the top menu bar of the Shadow Blade client.

Python Code

Python code is a general-purpose high-level programming language known for its simplicity, readability, and ease of learning. It is widely used in web development, data analysis, artificial intelligence, and more. Python code can implement complex functionalities through various libraries and frameworks, offering high flexibility and scalability.

Conditional Statements

• 【Shadow Blade RPA】IF Condition

• 【Shadow Blade RPA】IF Multiple Conditions

• IF Web Page Contains (to be supplemented)

• IF Element is Visible (web) (to be supplemented)

• IF Window Exists (to be supplemented)

• IF Window Contains (to be supplemented)

• 【Shadow Blade RPA】IF File Exists

• 【Shadow Blade RPA】IF Folder Exists

• 【Shadow Blade RPA】Else IF
• 【Shadow Blade RPA】Else IF Multiple Conditions
• 【Shadow Blade RPA】Else

• 【Shadow Blade RPA】End IF

Conditional statements are a control structure in programming used to execute different code segments based on specific conditions.Conditional statements play the role of decision-makers in programming development. They allow the program to choose execution paths based on the specific conditions met, adapting to different scenarios and needs.

Loops

• 【Shadow Blade RPA】For Loop
• 【Shadow Blade RPA】While Loop

• 【Shadow Blade RPA】ForEach List Loop

• 【Shadow Blade RPA】ForEach Dictionary Loop

• 【Shadow Blade RPA】Infinite Loop

• 【Shadow Blade RPA】Continue to Next Loop

• 【Shadow Blade RPA】Exit Loop

• 【Shadow Blade RPA】Loop End Marker

In computer programming, a loop is a control structure that repeatedly executes a block of code until a given condition is no longer met. Loops are very useful for reducing code duplication, automating repetitive tasks, and processing data collections (such as lists, arrays, database records, etc.).

There are mainly two types of loop structures: pre-test loops (check the condition before executing the loop body) and post-test loops (execute the loop body before checking the condition). Each type of loop has its specific uses and advantages.

Wait

• 【Shadow Blade RPA】Wait

In programming languages, “wait” typically refers to pausing the execution of a program for a certain period until a specific condition is met or a certain time period has elapsed.

Files

• 【Shadow Blade RPA】Get File List

• 【Shadow Blade RPA】Copy File

• 【Shadow Blade RPA】Move File

• 【Shadow Blade RPA】Rename File

• 【Shadow Blade RPA】Delete File

• 【Shadow Blade RPA】Read File

• 【Shadow Blade RPA】Write to File

• 【Shadow Blade RPA】Get File Path Information

• 【Shadow Blade RPA】Wait for File

File operations mainly target individual files, including creating, reading, writing, renaming, deleting, etc., with common modules being os and the built-in open function.

Folders

• 【Shadow Blade RPA】Get Folder List
• 【Shadow Blade RPA】Get Selected File(s) List
• 【Shadow Blade RPA】Open Folder
• 【Shadow Blade RPA】Create Folder
• 【Shadow Blade RPA】Delete Folder
• 【Shadow Blade RPA】Empty Folder
• 【Shadow Blade RPA】Copy Folder
• 【Shadow Blade RPA】Move Folder
• 【Shadow Blade RPA】Rename Folder
• 【Shadow Blade RPA】Get System Folder Path

Folder operations involve creating, traversing, deleting directories, etc., mainly relying on the os and shutil modules.

Clipboard

• Add File to Clipboard (to be supplemented)

• 【Shadow Blade RPA】Set Clipboard Content
• 【Shadow Blade RPA】Get Clipboard Text
• 【Shadow Blade RPA】Clear Clipboard

The clipboard is a built-in tool in Windows systems for temporarily storing and exchanging information, located in the computer’s memory.

The main function of the clipboard is to transfer and share information between applications. It is a region in memory that can store information saved by the user through copy or cut commands. This information can take various forms, including text, images, files, etc. The clipboard works by using the system’s internal resources RAM (Random Access Memory) or virtual memory to temporarily store this information.

Compression/Decompression

• 【Shadow Blade RPA】Compress File/Folder
• 【Shadow Blade RPA】Decompress File/Folder

Compression and decompression are common file operations in computers, used to reduce file size and facilitate transmission or storage.

Word/WPS Document

• 【Shadow Blade RPA】Launch Word
• 【Shadow Blade RPA】Export Word to PDF
• 【Shadow Blade RPA】Read Word Text
• 【Shadow Blade RPA】Write Text to Word
• 【Shadow Blade RPA】Position Word Cursor
• 【Shadow Blade RPA】Move Word Cursor
• 【Shadow Blade RPA】Replace Word Text
• 【Shadow Blade RPA】Read Word Table
• 【Shadow Blade RPA】Insert Word Table
• 【Shadow Blade RPA】Insert Image
• 【Shadow Blade RPA】Insert Hyperlink
• 【Shadow Blade RPA】Save Word
• 【Shadow Blade RPA】Close Word

Extended Commands

• 【Shadow Blade RPA】Save Document As

• 【Shadow Blade RPA】Save Document

• 【Shadow Blade RPA】Write Text

• 【Shadow Blade RPA】Select All Content

• 【Shadow Blade RPA】Select Row

• 【Shadow Blade RPA】Find and Set Cursor Position

• 【Shadow Blade RPA】Move Cursor Position

• 【Shadow Blade RPA】Exit Word

• 【Shadow Blade RPA】Set Alignment

• 【Shadow Blade RPA】Set Text Style

• 【Shadow Blade RPA】Set Font Color

• 【Shadow Blade RPA】Set Font Size

• 【Shadow Blade RPA】Set Font

• 【Shadow Blade RPA】Paste

• 【Shadow Blade RPA】Cut

• 【Shadow Blade RPA】Copy

• 【Shadow Blade RPA】Open Word Document

In the field of office automation, Python can be used to handle Word documents, whether in Microsoft Word or the text processing component of WPS Office in China. Python provides several libraries to achieve this functionality, the most famous being the python-docx library, which allows users to create, modify, and extract information from Word documents.

Excel/WPS Spreadsheet

• 【Shadow Blade RPA】Open/New Excel
• 【Shadow Blade RPA】Get Current Active Excel Object
• 【Shadow Blade RPA】Save/Save As Excel
• 【Shadow Blade RPA】Close Excel

• 【Shadow Blade RPA】Export to PDF

• 【Shadow Blade RPA】Loop Through Excel Content

• 【Shadow Blade RPA】Read Excel Content

• 【Shadow Blade RPA】Write Content to Excel Worksheet

Read/Write Operations

• 【Shadow Blade RPA】Read Total Rows in Excel

• 【Shadow Blade RPA】Copy Excel Content

• 【Shadow Blade RPA】Paste Excel Content

• 【Shadow Blade RPA】Get First Available Row

• 【Shadow Blade RPA】Get First Available Row in Column

• 【Shadow Blade RPA】Get First Available Column

• 【Shadow Blade RPA】Get First Available Column in Row

• 【Shadow Blade RPA】Get Last Column

• 【Shadow Blade RPA】Clear Excel Content

• 【Shadow Blade RPA】Delete Excel Row

• 【Shadow Blade RPA】Delete Duplicate Rows

• 【Shadow Blade RPA】Delete All Rows

• 【Shadow Blade RPA】Delete Excel Column

• 【Shadow Blade RPA】Insert Empty Row

• 【Shadow Blade RPA】Insert Empty Column

• 【Shadow Blade RPA】Select Range

• 【Shadow Blade RPA】Get Selected Range

• 【Shadow Blade RPA】Set Row/Column Hidden

Sheet Operations

• 【Shadow Blade RPA】Add Sheet

• 【Shadow Blade RPA】Activate Sheet

• 【Shadow Blade RPA】Copy Sheet

• 【Shadow Blade RPA】Delete Sheet

• 【Shadow Blade RPA】Rename Sheet

• 【Shadow Blade RPA】Get Sheet Name

  Advanced Commands

• Run Excel Macro (to be supplemented)

• Refresh Excel Data (to be supplemented)

• 【Shadow Blade RPA】Set Format

• 【Shadow Blade RPA】Clear Format

• 【Shadow Blade RPA】Set Row Height

• 【Shadow Blade RPA】Set Column Width

• New Pivot Table (to be supplemented)

• Refresh Pivot Table (to be supplemented)

• Filter Pivot Table (to be supplemented)

• Add Data Validation (to be supplemented)

• 【Shadow Blade RPA】Excel Sort

  Excel Extended Command Set

• Filter (to be supplemented)

• Clear Filter (to be supplemented)

• Batch Fill Down (Formula) (to be supplemented)

• Batch Fill Right (Formula) (to be supplemented)

• Auto Fill Down (to be supplemented)

• 【Shadow Blade RPA】Convert Range from Number to Text

• 【Shadow Blade RPA】Convert Range from Text to Number

• Read Filtered Content (to be supplemented)

• Delete Filtered Content (to be supplemented)

• Split Columns (to be supplemented)

• Fill Cell with Image (to be supplemented)

• Generate Dictionary (List Concatenation) (to be supplemented)

• Generate Dictionary (Value Accumulation) (to be supplemented)

• 【Shadow Blade RPA】Capture Screen of Range

• 【Shadow Blade RPA】Find Data Column

• 【Shadow Blade RPA】Find Data Row

• Convert Numeric Column Name (to be supplemented)

• 【Shadow Blade RPA】Replace Content

• 【Shadow Blade RPA】Get Cell Hyperlink

• 【Shadow Blade RPA】Set Cell Hyperlink

• 【Shadow Blade RPA】Merge Cells / Unmerge Cells

• 【Shadow Blade RPA】Hide / Unhide

• Fill Blank Cells (Fill Up) (to be supplemented)

• Filter by Color (to be supplemented)

• Delete All Images (to be supplemented)

• Export Cell Image (to be supplemented)

• Delete Cell Image (to be supplemented)

• 【Shadow Blade RPA】Hide / Unhide Sheet

• 【Shadow Blade RPA】Get Hidden Sheet

• Merge Calculation (to be supplemented)

• 【Shadow Blade RPA】Set/Cancel Password

• 【Shadow Blade RPA】Auto Wrap Text

• Convert Formula to Value (to be supplemented)

• 【Shadow Blade RPA】Create New Comment

In Python, handling Excel and WPS spreadsheets can be done using several libraries such as pandas, openpyxl, xlrd, xlwt, and xlsxwriter. These libraries provide rich APIs that support data reading, writing, processing, and formatting, meeting various data processing needs.

Enterprise Group Notifications

• Enterprise WeChat Group Notification (to be supplemented)

• 【Shadow Blade RPA】DingTalk Group Notification

• 【Shadow Blade RPA】Feishu Group Notification

Enterprise WeChat, Feishu, and DingTalk are efficient enterprise communication and collaboration platforms that provide instant messaging, file sharing, video conferencing, task management, scheduling, and more. They enhance work efficiency through the integration of third-party applications and bot assistants, each with unique security and management features to meet different enterprise needs.

Data Processing

Set Variable

• To be updated

Text Operations

• Extract Content from Text (to be updated)

• 【Shadow Blade RPA】Get Text Length

• 【Shadow Blade RPA】Append New Text

• 【Shadow Blade RPA】Extract Substring

• 【Shadow Blade RPA】Pad Text to Specified Length

• Trim Spaces from Both Ends of Text

• 【Shadow Blade RPA】Change Text Case

• Aggregate List into Text

• 【Shadow Blade RPA】Split Text into List

• 【Shadow Blade RPA】Replace Text

List Operations

• To be updated

Dictionary Extended Command Set

• To be updated

Date and Time

• To be updated

CSV Read/Write

• To be updated

Json Conversion

• To be updated

Base64 Encoding/Decoding

• To be updated

Python is renowned for its simplicity and efficiency in data processing, covering multidimensional needs: flexible variable definitions support dynamic types and complex data structures; text processing provides basic operations such as string splitting, merging, and regular expressions to meet pattern matching and cleaning needs; lists, as ordered containers, support slicing and comprehensions for easy element addition, deletion, and batch processing; dictionaries enable fast queries through key-value mapping and can dynamically expand or merge data relationships; the date and time module supports time parsing, formatting, and difference calculations, suitable for time series analysis scenarios; CSV and JSON modules simplify reading, writing, and converting tabular and structured data, seamlessly connecting to external data sources; Base64 encoding/decoding focuses on text processing of binary data, ensuring compatibility for cross-system transmission. These features, combined with a rich standard library, establish Python’s versatility and practicality in data processing.