{{user.name}}
The UiPath StudioX Guide
Release Notes
2022.10.3
2022.10.4
2022.10.5
Getting Started
Introduction
Install Studio
Install the Excel Add-in
The User Interface
Keyboard Shortcuts
Signing in to Your Account
Creating Your First Automation Project
Project Templates
Configuring StudioX Settings
Frequently Asked Questions
Tutorials
Tutorials
Automation Projects
About Automation Projects
About Publishing Automation Projects
Managing Activities Packages
About Workflow Analyzer
Governance and Auditing
Governance
Audit Logging
Managing Projects with GIT
Using the Data Manager
Creating Automations
Automation Basics
Common Scenarios
Tips and Tricks
Object Repository
Automation Best Practices
UI Automation
App/Web Recorder
Project Settings
Tutorial: Working with UI Automation
Tutorial: Extracting Table Data from a Web Page and Editing It in Excel
Tutorial: Filling Out PDF Forms in Acrobat Reader with Data from Excel
Tutorial: Iterating through Rows in a Table
Use Application/Browser
Check App State
Check/Uncheck
Click
Extract Table Data
Get Text
Go to URL
Highlight
Hover
Keyboard Shortcuts
Maximize Window
Minimize Window
Move Window
Navigate Browser
Restore Window
Select Item
Take Screenshot
Type Into
Excel Automation
Tutorial: Creating a Pivot Table
Tutorial: Iterating through Rows in a Table
Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
Tutorial: Extracting Data from Automated Emails and Moving It to a Desktop Application
Tutorial: Filtering Data in Excel
Tutorial: Formatting Cells
Tutorial: Adding Information about the Files in a Folder to an Excel File
Tutorial: Adding Your Own Formulas to the Project Notebook
Tutorial: Filling Out PDF Forms in Acrobat Reader with Data from Excel
Use Excel File
Append Range
Auto Fill
Autofit Range
Change Pivot Data Source
Clear Sheet/Range/Table
Create Pivot Table
Copy/Paste Range
Delete Rows
Delete Column
Delete Sheet
Duplicate Sheet
Export to CSV
Filter
Fill Range
Find First/Last Data Row
Find/Replace Value
Format as Table
For Each Excel Row
For Each Excel Sheet
Format Cells
Get Excel Chart
Insert Column
Insert Chart
Insert Rows
Insert Sheet
Match Function
Protect Sheet
Read Cell Formula
Read Cell Value
Read Range
Refresh Pivot Table
Refresh Excel Data Connections
Remove Duplicates
Rename Sheet
Run Spreadsheet Macro
Save Excel File
Save Excel File As
Save Excel File As PDF
Sort Range
Text to Columns
Unprotect Sheet
Update Excel Chart
VLookup
Write Cell
Write DataTable to Excel
CSV Automation
Tutorial: Copying from CSV to Excel and Emailing the File
Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
Append To CSV
Read CSV
Write CSV
Mail Automation
Tutorial: Iterating through Outlook Mails and Saving Attachments
Tutorial: Saving, Renaming, and Moving Attachments
Tutorial: Extracting Data from Automated Emails and Moving It to a Desktop Application
Tutorial: Working with Files and Folders
Use Exchange 365 Account
Use Gmail
Use Desktop Outlook App
Archive Email
Delete Email
For Each Email
Forward Email
Get Email by Id
Mark Email as Read/Unread
Move Email
Reply to Email
Save Email
Save Email Attachments
Send Calendar Invite
Send Email
Word Automation
Tutorial: Working with Word Automation
Use Word File
Add Hyperlink to Document
Add Picture
Append Text
Insert DataTable in Document
Paste Chart/Picture into Document
Read Text
Replace Picture
Replace Text
Save Document As
Save Document as PDF
Set Bookmark Content
PowerPoint Automation
Use PowerPoint Presentation
Add Data Table to Slide
Add File to Slide
Add Image or Video to Slide
Add New Slide
Add Text to Slide
Copy Paste Slide
Delete Slide
Format Slide Content
Paste Item into Slide
Replace Text in Presentation
Run Presentation Macro
Save PowerPoint File As
Save Presentation as PDF
File Automation
Tutorial: Working with Files and Folders
Append Line
Browse for Folder
Compress/Zip Files
Create File
Create Folder
Copy File
Copy Folder
Delete File
Delete Folder
Extract/Unzip Files
File Exists
Folder Exists
For Each File In Folder
For Each Folder in Folder
Get File Info
Get Folder Info
Move Folder
Move File
Read Text File
Rename File
Rename Folder
Browse for file
Write Text File
Data Automation
Add Data Row
Append Item to List
Create List
Filter Data Table
For Each
For Each Row in Data Table
Generate Data Table From Text
Get Row Item
Read List Item
Remove Data Row
Update List Item
Update Row Item
Common Activities
Tutorial: Working with Files and Folders
Change type
Delay
Exit Loop
Get Orchestrator Asset
Get Username/Password
Group
Else If
If
Message Box
Modify Date
Modify Text
Repeat Number of Times
Save for Later
Skip Current
Switch
Text to Left/Right
Wait for Download
Write Line
SAP Automation
Google Workspace Automation
OneDrive & SharePoint Automation
Troubleshooting
About Troubleshooting
Outlook Troubleshooting
Troubleshooting Microsoft Office Issues
Release Notes
2022.10.3
2022.10.4
2022.10.5
Getting Started
Introduction
Install Studio
Install the Excel Add-in
The User Interface
Keyboard Shortcuts
Signing in to Your Account
Creating Your First Automation Project
Project Templates
Configuring StudioX Settings
Frequently Asked Questions
Tutorials
Tutorials
Automation Projects
About Automation Projects
About Publishing Automation Projects
Managing Activities Packages
About Workflow Analyzer
Governance and Auditing
Governance
Audit Logging
Managing Projects with GIT
Using the Data Manager
Creating Automations
Automation Basics
Common Scenarios
Tips and Tricks
Object Repository
Automation Best Practices
UI Automation
App/Web Recorder
Project Settings
Tutorial: Working with UI Automation
Tutorial: Extracting Table Data from a Web Page and Editing It in Excel
Tutorial: Filling Out PDF Forms in Acrobat Reader with Data from Excel
Tutorial: Iterating through Rows in a Table
Use Application/Browser
Check App State
Check/Uncheck
Click
Extract Table Data
Get Text
Go to URL
Highlight
Hover
Keyboard Shortcuts
Maximize Window
Minimize Window
Move Window
Navigate Browser
Restore Window
Select Item
Take Screenshot
Type Into
Excel Automation
Tutorial: Creating a Pivot Table
Tutorial: Iterating through Rows in a Table
Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
Tutorial: Extracting Data from Automated Emails and Moving It to a Desktop Application
Tutorial: Filtering Data in Excel
Tutorial: Formatting Cells
Tutorial: Adding Information about the Files in a Folder to an Excel File
Tutorial: Adding Your Own Formulas to the Project Notebook
Tutorial: Filling Out PDF Forms in Acrobat Reader with Data from Excel
Use Excel File
Append Range
Auto Fill
Autofit Range
Change Pivot Data Source
Clear Sheet/Range/Table
Create Pivot Table
Copy/Paste Range
Delete Rows
Delete Column
Delete Sheet
Duplicate Sheet
Export to CSV
Filter
Fill Range
Find First/Last Data Row
Find/Replace Value
Format as Table
For Each Excel Row
For Each Excel Sheet
Format Cells
Get Excel Chart
Insert Column
Insert Chart
Insert Rows
Insert Sheet
Match Function
Protect Sheet
Read Cell Formula
Read Cell Value
Read Range
Refresh Pivot Table
Refresh Excel Data Connections
Remove Duplicates
Rename Sheet
Run Spreadsheet Macro
Save Excel File
Save Excel File As
Save Excel File As PDF
Sort Range
Text to Columns
Unprotect Sheet
Update Excel Chart
VLookup
Write Cell
Write DataTable to Excel
CSV Automation
Tutorial: Copying from CSV to Excel and Emailing the File
Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
Append To CSV
Read CSV
Write CSV
Mail Automation
Tutorial: Iterating through Outlook Mails and Saving Attachments
Tutorial: Saving, Renaming, and Moving Attachments
Tutorial: Extracting Data from Automated Emails and Moving It to a Desktop Application
Tutorial: Working with Files and Folders
Use Exchange 365 Account
Use Gmail
Use Desktop Outlook App
Archive Email
Delete Email
For Each Email
Forward Email
Get Email by Id
Mark Email as Read/Unread
Move Email
Reply to Email
Save Email
Save Email Attachments
Send Calendar Invite
Send Email
Word Automation
Tutorial: Working with Word Automation
Use Word File
Add Hyperlink to Document
Add Picture
Append Text
Insert DataTable in Document
Paste Chart/Picture into Document
Read Text
Replace Picture
Replace Text
Save Document As
Save Document as PDF
Set Bookmark Content
PowerPoint Automation
Use PowerPoint Presentation
Add Data Table to Slide
Add File to Slide
Add Image or Video to Slide
Add New Slide
Add Text to Slide
Copy Paste Slide
Delete Slide
Format Slide Content
Paste Item into Slide
Replace Text in Presentation
Run Presentation Macro
Save PowerPoint File As
Save Presentation as PDF
File Automation
Tutorial: Working with Files and Folders
Append Line
Browse for Folder
Compress/Zip Files
Create File
Create Folder
Copy File
Copy Folder
Delete File
Delete Folder
Extract/Unzip Files
File Exists
Folder Exists
For Each File In Folder
For Each Folder in Folder
Get File Info
Get Folder Info
Move Folder
Move File
Read Text File
Rename File
Rename Folder
Browse for file
Write Text File
Data Automation
Add Data Row
Append Item to List
Create List
Filter Data Table
For Each
For Each Row in Data Table
Generate Data Table From Text
Get Row Item
Read List Item
Remove Data Row
Update List Item
Update Row Item
Common Activities
Tutorial: Working with Files and Folders
Change type
Delay
Exit Loop
Get Orchestrator Asset
Get Username/Password
Group
Else If
If
Message Box
Modify Date
Modify Text
Repeat Number of Times
Save for Later
Skip Current
Switch
Text to Left/Right
Wait for Download
Write Line
SAP Automation
Google Workspace Automation
OneDrive & SharePoint Automation
Troubleshooting
About Troubleshooting
Outlook Troubleshooting
Troubleshooting Microsoft Office Issues
Only admins can see this
Enable it for everyone
Oh no! It seems that you've reached a dead end.
Visit the
homepage
or try using the search.
