The Microsoft Office 365 Excel activities provide methods to create, extract, and insert data into Excel workbooks and worksheets.
Adds a new worksheet to a specified workbook.
Writes a range of cell data to a specified workbook worksheet. If the specified worksheet does not exist in the specified workbook, a new worksheet is created.
Copies an existing worksheet in a specified workbook and then pastes it as a new worksheet into the same or a different workbook.
Creates a new workbook and uploads it to the specified location. After the workbook is uploaded to the specified location, the activity returns a
DriveItem object and a URL
String that you can use as input variables in subsequent activities.
Deletes a range of cell data from a specified workbook worksheet.
Retrieves the color properties of specified cells in a workbook worksheet. After retrieving the color properties, the activity returns the cell color as a hex value (e.g., #FFFFFF).
Retrieves and returns an array of worksheets from a specified workbook.
Retrieves the value of a specified cell in a workbook worksheet. After retrieving the cell value, the activity returns it as a
String according to the selected value type.
Retrieves cell values from a specified column in a workbook worksheet. The activity returns the column value as an array of
Retrieves values from a specified range of cells in a workbook worksheet. After retrieving the range of cell data, the activity outputs the values into a
Retrieves the values of cells from a specified row in a workbook worksheet. After retrieving the data from all cells in the row, the activity outputs the values into an array of
Changes the name of a specified workbook worksheet from its current name to a new name.
Writes a value to a specified cell in a workbook worksheet.
Writes a range of cell data starting from a specific cell in a specified workbook worksheet.
Updated 3 months ago