Excel APIs

Office 365 Excel service.

Namespace: UiPath.MicrosoftOffice365.Activities.Api

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

Constructors

Constructor	Description	Syntax
IExcelService	Initializes a new instance of the IExcelService class	public interface IExcelService

Methods

Name	Description
AddSheet	Adds a sheet to the specified Excel workbook.
AddWorkbook	Creates a new Excel workbook.
DeleteColumn	Delete a specified column.
DeleteRange	Deletes a cell range from the specified Excel workbook.
DeleteRows	Delete one or several rows from a specified position in a workbook range.
DeleteSheet	Deletes a sheet from the specified Excel workbook.
GetNamedRanges	Gets the list of named ranges within a workbook.
GetRanges	Gets the list of named ranges and worksheets within a workbook.
GetSheets	Gets the list of sheets within a workbook.
GetWorkbooks	Retrieves a list of workbooks from the specified OneDrive or SharePoint location.
ReadCell	Reads information from the indicated Excel workbook cell.
ReadRange	Reads and saves the information from a specified Excel workbook range.
RenameSheet	Renames a sheet from the specified Excel workbook.
WriteCell	Writes information in the indicated Excel workbook cell.
WriteColumn	Write a column in a selected Excel workbook.
WriteRange	Writes a DataTable variable to a specified Excel workbook cell range.
WriteRow	Write a row in a selected file.