UiPath Documentation
activities
latest
false

Productivity activities

Last updated May 12, 2026

Excel coded automation APIs

Office 365 Excel service.

Namespace: UiPath.MicrosoftOffice365.Activities.Api

Assembly: UiPath.MicrosoftOffice365.Activities.Api (in UiPath.MicrosoftOffice365.Activities.Api.dll)

Constructors

ConstructorDescriptionSyntax
IExcelServiceInitializes a new instance of the IExcelService classpublic interface IExcelService

Methods

NameDescription
AddSheetAdds a sheet to the specified Excel workbook.
AddWorkbookCreates a new Excel workbook.
CopyRangeCopies a range from a source workbook to a destination workbook.
CreateTableCreates a table inside a workbook sheet from a given range.
DeleteColumnDeletes a specified column. Returns RangeInformation.
DeleteRangeDeletes a cell range from the specified Excel workbook.
DeleteRowsDeletes one or several rows from a specified position in a workbook range. Returns RangeInformation.
DeleteSheetDeletes a sheet from the specified Excel workbook.
GetNamedRangesGets the list of named ranges within a workbook.
GetRangesGets the list of named ranges and worksheets within a workbook.
GetSheetsGets the list of sheets within a workbook.
GetWorkbooksRetrieves a list of workbooks from the specified OneDrive or SharePoint location.
GetCellColorGets the background color of a specified cell as a hex string.
ReadCellReads information from the indicated Excel workbook cell.
ReadColumnReads a single column starting from the specified cell.
ReadRangeReads and saves the information from a specified Excel workbook range. Supports an ignoreEmptyRowsColumns parameter to skip empty rows/columns at range boundaries.
ReadRange (overload)Reads range and outputs range information via an out parameter.
ReadRowReads a single row starting from the specified cell.
RenameSheetRenames a sheet from the specified Excel workbook.
SetRangeColorSets the background color of a specified range.
VLookupRangeFinds a value in a range using VLOOKUP.
WriteCellWrites information in the indicated Excel workbook cell.
WriteColumnWrite a column in a selected Excel workbook.
WriteRangeWrites a DataTable variable to a specified Excel workbook cell range.
WriteRowWrites a row in a selected file. Supports a hasHeaders parameter to skip the header row when positioning.
  • Constructors
  • Methods

Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated