- Overview
- Excel
- Release Notes
- About the Excel activity package
- Project Compatibility
- Supported character encoding
- Project Settings
- Add or Update Excel Sensitivity Label
- Append Range
- Auto Fill
- Autofit Range
- Change Pivot Data Source
- Clear Sheet/Range/Table
- Copy/Paste Range
- Create Pivot Table
- Delete Column
- Delete Rows
- Delete Sheet
- Duplicate Sheet
- Export to CSV
- Fill Range
- Filter
- Filter Pivot Table
- Find First/Last Data Row
- Find/Replace Value
- For Each Excel Row
- For Each Excel Sheet
- Format As Table
- Format Cells
- Get Cell Color
- Get Excel Chart
- Get Excel Sensitivity Label
- Get Selected Range
- Insert Column
- Insert Chart
- Insert Rows
- Insert Sheet
- Invoke VBA
- Lookup
- Match Function
- Protect Sheet
- Read Cell Formula
- Read Cell Value
- Read Range
- Refresh Excel Data Connections
- Refresh Pivot Table
- Remove Duplicates
- Rename Sheet
- Run Spreadsheet Macro
- Save Excel File
- Save Excel File As
- Save Excel File As PDF
- Select Range
- Sort Range
- Text to Columns
- Unprotect Sheet
- Update Excel Chart
- Use Excel File
- VLookup
- Write Cell
- Write CSV
- Write DataTable to Excel
- Excel Application Scope
- Append To CSV
- Read CSV
- Write CSV
- Delete Column
- Filter Table
- Get Table Range
- Insert Column
- Sort Table
- Append Range
- Close Workbook
- Get Cell Color
- Read Cell
- Read Cell Formula
- Read Column
- Read Range
- Read Row
- Select Range
- Set Range Color
- Write Cell
- Write Range
- Save Workbook
- Create Table
- Get Workbook Sheet
- Get Workbook Sheets
- Refresh Pivot Table
- Create Pivot Table
- Get Selected Range
- Copy Sheet
- Delete Range
- Auto Fill Range
- Copy Paste Range
- Execute Macro
- Insert/Delete Columns
- Insert/Delete Rows
- Invoke VBA
- LookUp Range
- Remove Duplicates Range
- Excel Process Scope
- Manage CSV Files
- Filter CSV Files
- Verify CSV Files
- Table Functions
- Manage Multiple Excel Files
- Interpret Excel Results
- Manage Pivot Tables
- Manage Range Selection
- Read From Excel Files
- Manage Databases in Excel
- Compare CSV Files
- Compare Numeric Values
- Sort Data in Excel Files
- Filter and Delete Rows in Excel Files
- Manipulate Range Selections
- Verify Excel Workbook Data
- Read, Write, and Append Data in Excel
- Google Workspace
- Release notes
- About the Google Workspace activities package
- Project compatibility
- Add Attendee
- Create Event
- Delete Event
- Modify Event
- Search Events
- Use Google Drive
- Share File
- Delete File Permission
- Get File Permissions
- Update File Permission
- Copy File
- Create Folder
- Delete File
- Download File
- Find Files and Folders
- Get File Info
- Move File
- Upload File
- Create Document
- Create New Spreadsheet
- Get Mail Messages
- Send Mail Messages
- Change Labels
- Use Google Spreadsheet
- Add Delete Columns
- Add Delete Rows
- Auto Fill Range
- Add New Sheet
- Append Row
- Batch Spreadsheet Updates
- Copy Sheet
- Copy Paste Range
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Clear Range
- Download Spreadsheet
- Use Google Document
- Batch Document Updates
- Get Document
- Get Text Index
- Insert Text
- Replace Text
- Read All Text
- Create Script Project
- Get Project Content
- Upload Script File
- Create Deployment
- Run Script
- Mail
- Microsoft 365
- Release notes
- About the Microsoft 365 activity package
- Project compatibility
- Connections
- AddEmailCategories
- ArchiveEmail
- DeleteEmail
- DownloadEmail
- DownloadEmailAttachment
- DownloadEmailAttachments
- ForwardEmail
- GetEmail
- GetEmailAttachmentsInfo
- GetEmails
- GetMailFolders
- GetNewestEmail
- MarkEmailAsRead
- MarkEmailAsUnread
- MoveEmail
- RemoveEmailCategories
- ReplyToEmail
- SendEmail
- TurnOffAutomaticReplies
- TurnOnAutomaticReplies
- Merge multiple sheets into a new summary Excel sheet
- Automatically accept calendar invites from your manager
- Move files to dedicated folders by type
- Verify if new employment documents (I9 and ID) match
- Add new customers to a SharePoint List
- Delete SharePoint List items newer than yesterday
- Notify me on Slack when an important Outlook Email is received
- Include creation date in new OneDrive file names
- Notify me by email when a new file is created
- Microsoft 365 Scope
- Add Sheet
- Append Range
- Clear Range
- Copy Range
- Copy Sheet
- Create Workbook
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Set Range Color
- Create Table
- Get Table Range
- Insert Column
- Delete Column
- Insert Rows
- Delete Rows
- VLookup Range
- Use OneDrive & SharePoint
- Copy File/Folder
- Create Folder
- Delete File/Folder
- Download File
- Export File as PDF
- Find Files And Folders
- Get File/Folder
- Move File/Folder
- Upload File
- Share File/Folder
- For Each File/Folder
- Forward Mail
- Get Mail
- Move Mail
- Send Mail
- Reply to Mail
- Delete Mail
- Set Mail Categories
- Add Attachment
- Add Attendee
- Add Location
- Create Event
- Delete Event
- Find Meeting Times
- Get Calendars
- Modify Event
- RSVP
- Search Events
- Create Group
- Delete Group
- Get Group
- List Groups
- Create Bucket
- Delete Bucket
- List Buckets
- List Bucket Tasks
- Create Plan
- Get Plan
- List Plans
- Create Task
- Delete Task
- Get Task
- List Tasks
- Update Task
- For Each List
- Get List Info
- For Each List Item
- Delete List Item
- Add List Items
- Update List Item
- Get List Items
- Presentations
- Release Notes
- About the Presentations activity package
- Project Compatibility
- Add or Update Powerpoint Sensitivity Label
- 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
- Get Powerpoint Sensitivity Label
- Replace Text in Presentation
- Paste Item Into Slide
- Run Presentation Macro
- Save PowerPoint File As
- Save Presentation as PDF
- Use PowerPoint Presentation
- Word
- Release Notes
- About the Word Activities Package
- Project Compatibility
- Word Application Scope / Use Word File
- Add or Update Word Sensitivity Label
- Add Hyperlink to Document
- Add Picture
- Append Text
- Get Word Sensitivity Label
- Insert DataTable in Document
- Paste Chart/Picture Into Document
- Read Text
- Replace Picture
- Replace Text in Document
- Save Document As
- Save Document as PDF
- Set Bookmark Content
Project compatibility
Here you can check the availability of the package and its activities with the different project compatibilities in UiPath Studio.
Activity |
Windows - Legacy |
Windows |
Cross-platform |
---|---|---|---|
Microsoft 365 Scope UiPath.MicrosoftOffice365.Activities.Office365ApplicationScope
|
|
|
|
Add Sheet UiPath.MicrosoftOffice365.Activities.Excel.AddSheet
|
|
|
|
Add Sheet 2 UiPath.MicrosoftOffice365.Activities.Excel.AddSheetConnections
|
|
| |
Append Range UiPath.MicrosoftOffice365.Activities.Excel.AppendRange
|
|
|
|
Clear Range UiPath.MicrosoftOffice365.Activities.Excel.ClearRange
|
|
|
|
Copy Range UiPath.MicrosoftOffice365.Activities.Excel.CopyRange
|
|
|
|
Copy Sheet UiPath.MicrosoftOffice365.Activities.Excel.CopySheet
|
|
|
|
Create Workbook UiPath.MicrosoftOffice365.Activities.Excel.CreateWorkbook
|
|
|
|
Create Workbook 2 UiPath.MicrosoftOffice365.Activities.Excel.CreateWorkbookConnections
|
|
| |
Delete Range UiPath.MicrosoftOffice365.Activities.Excel.DeleteRange
|
|
|
|
Delete Range 2 UiPath.MicrosoftOffice365.Activities.Excel.DeleteRangeConnections
|
|
| |
Delete Sheet UiPath.MicrosoftOffice365.Activities.Excel.DeleteSheet
|
|
|
|
Delete Sheet 2 UiPath.MicrosoftOffice365.Activities.Excel.DeleteSheetConnections
|
|
| |
Get Cell Color UiPath.MicrosoftOffice365.Activities.Excel.GetCellColor
|
|
|
|
Get Sheets UiPath.MicrosoftOffice365.Activities.Excel.GetSheets
|
|
|
|
Read Cell UiPath.MicrosoftOffice365.Activities.Excel.ReadCell
|
|
|
|
Read Cell 2 UiPath.MicrosoftOffice365.Activities.Excel.ReadCellConnections
|
|
| |
Read Column UiPath.MicrosoftOffice365.Activities.Excel.ReadColumn
|
|
|
|
Read Range UiPath.MicrosoftOffice365.Activities.Excel.ReadRange
|
|
|
|
Read Range 2 UiPath.MicrosoftOffice365.Activities.Excel.ReadRangeConnections
|
|
| |
Read Row UiPath.MicrosoftOffice365.Activities.Excel.ReadRow
|
|
|
|
Rename Sheet UiPath.MicrosoftOffice365.Activities.Excel.RenameSheet
|
|
|
|
Rename Sheet 2 UiPath.MicrosoftOffice365.Activities.Excel.RenameSheetConnections
|
|
| |
Write Cell UiPath.MicrosoftOffice365.Activities.Excel.WriteCell
|
|
|
|
Write Cell 2 UiPath.MicrosoftOffice365.Activities.Excel.WriteCellConnections
|
|
| |
Write Range UiPath.MicrosoftOffice365.Activities.Excel.WriteRange
|
|
|
|
Write Range 2 UiPath.MicrosoftOffice365.Activities.Excel.WriteRangeConnections
|
|
| |
Set Range Color UiPath.MicrosoftOffice365.Activities.Excel.SetRangeColor
|
|
|
|
Create Table UiPath.MicrosoftOffice365.Activities.Excel.CreateTable
|
|
|
|
Get Table Range UiPath.MicrosoftOffice365.Activities.Excel.GetTableRange
|
|
|
|
Insert Column UiPath.MicrosoftOffice365.Activities.Excel.InsertColumn
|
|
|
|
Delete Column UiPath.MicrosoftOffice365.Activities.Excel.DeleteColumn
|
|
|
|
Insert Rows UiPath.MicrosoftOffice365.Activities.Excel.InsertRows
|
|
|
|
Delete Rows UiPath.MicrosoftOffice365.Activities.Excel.DeleteRows
|
|
|
|
VLookup Range UiPath.MicrosoftOffice365.Activities.Excel.VLookupRange
|
|
|
|
Use OneDrive & SharePoint UiPath.MicrosoftOffice365.Activities.Files.UseDriveCard
|
|
|
|
Copy File/Folder UiPath.MicrosoftOffice365.Activities.Files.CopyItem
|
|
|
|
Copy File/Folder 1 UiPath.MicrosoftOffice365.Activities.Files.CopyItemConnections
|
|
| |
Create Folder UiPath.MicrosoftOffice365.Activities.Files.CreateFolder
|
|
|
|
Create Folder 1 UiPath.MicrosoftOffice365.Activities.Files.CreateFolderConnections
|
|
| |
Delete File/Folder UiPath.MicrosoftOffice365.Activities.Files.DeleteItem
|
|
|
|
Delete File/Folder 1 UiPath.MicrosoftOffice365.Activities.Files.DeleteItemConnections
|
|
| |
Download File UiPath.MicrosoftOffice365.Activities.Files.DownloadFile
|
|
| |
Download File 1 UiPath.MicrosoftOffice365.Activities.Files.DownloadFileConnections
|
|
| |
Export File as PDF UiPath.MicrosoftOffice365.Activities.Files.ExportAsPdf
|
|
|
|
Find Files And Folders UiPath.MicrosoftOffice365.Activities.Files.FindFilesAndFolders
|
|
|
|
Get File/Folder UiPath.MicrosoftOffice365.Activities.Files.GetItem
|
|
|
|
Get File/Folder 1 UiPath.MicrosoftOffice365.Activities.Files.GetFileFolderConnections
|
|
| |
Move File/Folder UiPath.MicrosoftOffice365.Activities.Files.MoveItem
|
|
|
|
Move File/Folder 1 UiPath.MicrosoftOffice365.Activities.Files.MoveItemConnections
|
|
| |
Upload File UiPath.MicrosoftOffice365.Activities.Files.UploadFile
|
|
|
|
Upload Files 1 UiPath.MicrosoftOffice365.Activities.Files.UploadFilesConnections
|
|
| |
Share File/Folder UiPath.MicrosoftOffice365.Activities.Files.ShareItem
|
|
|
|
Share File/Folder 1 UiPath.MicrosoftOffice365.Activities.Files.ShareItemConnections
|
|
| |
For Each File/Folder UiPath.MicrosoftOffice365.Activities.Files.ForEachFileFolder
|
|
|
|
For Each File/Folder 1 UiPath.MicrosoftOffice365.Activities.Files.ForEachFileFolderConnections
|
|
| |
Forward Mail UiPath.MicrosoftOffice365.Activities.Mail.ForwardMail
|
|
|
|
Get Mail UiPath.MicrosoftOffice365.Activities.Mail.GetMail
|
|
|
|
Move Mail UiPath.MicrosoftOffice365.Activities.Mail.MoveMail
|
|
|
|
Send Mail UiPath.MicrosoftOffice365.Activities.Mail.SendMail
|
|
|
|
Reply to Mail UiPath.MicrosoftOffice365.Activities.Mail.ReplyToMail
|
|
|
|
Delete Mail UiPath.MicrosoftOffice365.Activities.Mail.DeleteMail
|
|
|
|
Set Mail Categories UiPath.MicrosoftOffice365.Activities.Mail.SetMailCategories
|
|
|
|
Add Attachment UiPath.MicrosoftOffice365.Activities.Calendar.AddAttachment
|
|
|
|
Add Attendee UiPath.MicrosoftOffice365.Activities.Calendar.AddAttendee
|
|
|
|
Add Location UiPath.MicrosoftOffice365.Activities.Calendar.AddLocation
|
|
|
|
Create Event UiPath.MicrosoftOffice365.Activities.Calendar.CreateEvent
|
|
|
|
Create Event 2 UiPath.MicrosoftOffice365.Activities.Calendar.CreateEventConnections
|
|
| |
Delete Event UiPath.MicrosoftOffice365.Activities.Calendar.DeleteEvent
|
|
|
|
Delete Event 2 UiPath.MicrosoftOffice365.Activities.Calendar.DeleteEventConnections
|
|
| |
Find Meeting Times UiPath.MicrosoftOffice365.Activities.Calendar.FindMeetingTimes
|
|
|
|
Get Calendars4 UiPath.MicrosoftOffice365.Activities.Calendar.GetCalendars
|
|
|
|
Get Calendars UiPath.MicrosoftOffice365.Activities.CalendarGetCalendarsConnections
|
|
| |
Modify Event UiPath.MicrosoftOffice365.Activities.Calendar.ModifyEvent
|
|
|
|
RSVP UiPath.MicrosoftOffice365.Activities.Calendar.Rsvp
|
|
|
|
Search Events UiPath.MicrosoftOffice365.Activities.Calendar.SearchEvents
|
|
|
|
Create Group UiPath.MicrosoftOffice365.Activities.Groups.CreateGroup
|
|
|
|
Delete Group UiPath.MicrosoftOffice365.Activities.Groups.DeleteGroup
|
|
|
|
Get Group UiPath.MicrosoftOffice365.Activities.Groups.GetGroup
|
|
|
|
List Groups UiPath.MicrosoftOffice365.Activities.ListGroups
|
|
|
|
Create Bucket UiPath.MicrosoftOffice365.Activities.Planner.Buckets.CreateBucket
|
|
|
|
Delete Bucket UiPath.MicrosoftOffice365.Activities.Planner.Buckets.DeleteBucket
|
|
|
|
List Buckets UiPath.MicrosoftOffice365.Activities.Planner.Buckets.ListBuckets
|
|
|
|
List Bucket Tasks UiPath.MicrosoftOffice365.Activities.Planner.Buckets.ListBucketTasks
|
|
|
|
Create Plan UiPath.MicrosoftOffice365.Activities.Planner.Plans.CreatePlan
|
|
|
|
Get Plan UiPath.MicrosoftOffice365.Activities.Planner.Plans.GetPlan
|
|
|
|
List Plans UiPath.MicrosoftOffice365.Activities.Planner.Plans.ListPlans
|
|
|
|
Create Task UiPath.MicrosoftOffice365.Activities.Planner.Tasks.CreateTask
|
|
|
|
Delete Task UiPath.MicrosoftOffice365.Activities.Planner.Tasks.DeleteTask
|
|
|
|
Get Task UiPath.MicrosoftOffice365.Activities.Planner.Tasks.GetTask
|
|
|
|
List Tasks UiPath.MicrosoftOffice365.Activities.Planner.Tasks.ListTasks
|
|
|
|
Update Task UiPath.MicrosoftOffice365.Activities.Planner.Tasks.UpdateTask
|
|
|
|
For Each List UiPath.MicrosoftOffice365.Activities.SharePoint.ForEachList
|
|
|
|
Get List Info UiPath.MicrosoftOffice365.Activities.SharePoint.GetListInfo
|
|
|
|
For Each List Item UiPath.MicrosoftOffice365.Activities.SharePoint.ForEachListItem
|
|
|
|
Delete List Item UiPath.MicrosoftOffice365.Activities.SharePoint.DeleteListItem
|
|
|
|
Add List Items UiPath.MicrosoftOffice365.Activities.SharePoint.AddListItems
|
|
|
|
Update List Item UiPath.MicrosoftOffice365.Activities.SharePoint.UpdateListItem
|
|
|
|
For Each Event 2 UiPath.MicrosoftOffice365.Activities.Calendar.ForEachEventConnections
|
| ||
Forward Event 2 UiPath.MicrosoftOffice365.Activities.Calendar.ForwardEventConnections
|
|
| |
Respond To Event Invitation 2 UiPath.MicrosoftOffice365.Activities.Calendar.RsvpConnections
|
|
| |
Update Event 2 UiPath.MicrosoftOffice365.Activities.Calendar.ModifyEventConnections
|
|
| |
Get Event List
2
UiPath.MicrosoftOffice365.Activities.Calendar.GetEventListConnections
| |||
Get Event by ID
4
UiPath.MicrosoftOffice365.Activities.Calendar.GetEventbyIDConnections
| |||
Calendar Event Created 2 UiPath.MicrosoftOffice365.Activities.Files.Triggers.NewEventCreated
|
|
| |
Calendar Event Received2
UiPath.MicrosoftOffice365.Activities.Files.Triggers.NewEventInvitationReceived
|
|
| |
Calendar Event Replied
2
UiPath.MicrosoftOffice365.Activities.Calendar.Triggers.EventReplied
|
|
| |
Calendar Event Updated
2
UiPath.MicrosoftOffice365.Activities.Calendar.Triggers.EventUpdated
|
|
| |
File Created 2 UiPath.MicrosoftOffice365.Activities.Files.Triggers.NewFileCreated
|
|
| |
File Updated
2
|
|
| |
For Each Row in Workbook 2 UiPath.MicrosoftOffice365.Activities.Excel.ForEachRowConnections
|
|
| |
For Each Sheet in Workbook
UiPath.MicrosoftOffice365.Activities.ForEachSheetConnections
| |||
Write Column
4
UiPath.MicrosoftOffice365.Activities.Excel.WriteColumnConnections
| |||
Write Row
4
UiPath.MicrosoftOffice365.Activities.Excel.WriteRowConnections
| |||
Get File/Folder List 1 UiPath.MicrosoftOffice365.Activities.Files.GetFileListConnections
|
|
| |
Email Sent 2 UiPath.MicrosoftOffice365.Activities.Mail.Triggers.EmailSent
|
|
| |
Email Received 2 UiPath.MicrosoftOffice365.Activities.Mail.Triggers.NewEmailReceived
|
|
| |
Get Email List
UiPath.MicrosoftOffice365.Activities.GetEmailListConnections
| |||
Archive Email 1 UiPath.MicrosoftOffice365.Activities.Mail.ArchiveEmailConnections
|
|
| |
Delete Email 1 UiPath.MicrosoftOffice365.Activities.Mail.DeleteEmailConnections
|
|
| |
Download Email 1 UiPath.MicrosoftOffice365.Activities.Mail.DownloadEmailConnections
|
|
| |
Download Email Attachments 1 UiPath.MicrosoftOffice365.Activities.Mail.DownloadEmailAttachments
|
|
| |
For Each Email 1 UiPath.MicrosoftOffice365.Activities.Mail.ForEachEmailConnections
|
|
| |
Forward Email 1 UiPath.MicrosoftOffice365.Activities.Mail.ForwardEmailConnections
|
|
| |
Get Email By Id 1 UiPath.MicrosoftOffice365.Activities.Mail.GetEmailByIdConnections
|
|
| |
Get Newest Email 1 UiPath.MicrosoftOffice365.Activities.Mail.GetNewestEmail
|
|
| |
Mark Email as Read/Unread 1 UiPath.MicrosoftOffice365.Activities.Mail.MarkAsReadUnreadConnections
|
|
| |
Move Email 1 UiPath.MicrosoftOffice365.Activities.Mail.MoveEmailConnections
|
|
| |
Reply to Email 1 UiPath.MicrosoftOffice365.Activities.Mail.ReplyToEmailConnections
|
|
| |
Send Email 1 UiPath.MicrosoftOffice365.Activities.Mail.SendMailConnections
|
|
| |
Set Email Categories 1 UiPath.MicrosoftOffice365.Activities.Mail.SetEmailCategoriesConnections
|
|
| |
Turn On Automatic Replies 4 UiPath.MicrosoftOffice365.Activities.Mail.TurnOnAutomaticRepliesConnections
|
|
| |
Turn Off Automatic Replies
4
UiPath.MicrosoftOffice365.Activities.Mail.TurnOffAutomaticRepliesConnections
|
|
| |
Add List Items
3
UiPath.MicrosoftOffice365.Activities.Sharepoint.AddListItemsConnections
|
|
| |
Get List Items
3
UiPath.MicrosoftOffice365.Activities.Sharepoint.GetListItemsConnections
|
|
| |
Get Single List Item
3
UiPath.MicrosoftOffice365.Activities.Sharepoint.GetSingleSharepointListItemConnections
|
|
| |
Delete List Items
3
UiPath.MicrosoftOffice365.Activities.Sharepoint.DeleteSharepointListItemsConnections
|
|
| |
Update Single List Item
3
UiPath.MicrosoftOffice365.Activities.Sharepoint.UpdatetListItemConnections
|
|
| |
List Item Added
3
UiPath.MicrosoftOffice365.Activities.SharePoint.Triggers.ListItemCreated
| |||
For Each List Item
3
UiPath.MicrosoftOffice365.Activities.Sharepoint.ForEachListItemConnections
| |||
List Item Updated
3
UiPath.MicrosoftOffice365.Activities.SharePoint.Triggers.ListItemUpdated
| |||
Cell in Worksheet Updated
4
UiPath.MicrosoftOffice365.Activities.Excel.Trigger.WorksheetCellUpdated
| |||
Worksheet Created
4
UiPath.MicrosoftOffice365.Activities.Excel.Trigger.WorksheetCreated
| |||
Row Added to the Bottom of a Table
4
UiPath.MicrosoftOffice365.Activities.Excel.Trigger.RowAddedToTableBottom
| |||
Delete Rows
4
UiPath.MicrosoftOffice365.Activities.ExcelDeleteRowConnections
| |||
Delete Column
4
UiPath.MicrosoftOffice365.Activities.ExcelDeleteColumnConnections
|
1 - This activity is available in cross-platform projects in Studio versions prior to 2022.10.
2 - This activity is available in cross-platform projects in Studio versions starting with 2022.10.
3 - This activity is available in cross-platform projects in Studio versions starting with 2023.4.
4 - This activity is available in cross-platform projects in Studio versions starting with 2023.10.