The Office 365 Excel package contains actions that you can use to automate tasks related to column and row operations such as autofit, delete, insert, and read.
The Office 365 Excel package includes the following actions:
|Autofit columns||Adjusts the width of the columns in the worksheet in the specified session. Use Enter the name of the session used to open the workbook with the Open action.|
|Autofit rows||Adjusts the height of the rows in the worksheet in the specified session. Use Enter the name of the session used to open the workbook with the Open action.|
|Delete row/column||See Using Delete action for rows or columns.|
|Get row count||Retrieves the number of rows that contain data in the worksheet.|
|Insert row/column||See Using Insert action for rows or columns.|
|Read column||Extracts data from a column and stores it in a List variable.
|Read row||Extracts data from a row and stores it in a Record variable.