Microsoft Excel - Delete a row

Use the Microsoft Excel - Delete a row action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to delete a specific row from a table in a workbook.

For more information about the Microsoft Excel connector, go to Microsoft Excel.

Before you begin:

Understand Variables
Learn about Handling files in your workflow

Jump to:

Configure the Microsoft Excel - Delete a row action
Microsoft Excel - Delete a row action fields, buttons, and settings

Configure the Microsoft Excel - Delete a row action

Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.
Select a Connection. If you do not have a connection, see Add a connection.

Select the Workbook the table belongs to.
Select the Table you want to delete a row from.
Specify the Row index to identify the row you want to delete.

Microsoft Excel - Delete a row action fields, buttons, and settings

Section	Field	Description	Variable types
(unlabeled)	Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.	The Microsoft Excel connection to use to delete a row from a table in a workbook. To refresh the available connections, click .	(n/a)
	Workbook	The workbook containing the table you want to delete a row from. When you specify the Microsoft Excel connection, all the workbooks in the selected connection are available to select from in the drop-down list. When using a variable, use the workbook ID.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Table	The table you want to delete a row from. When you specify the Workbook, all the tables in the selected workbook are available to select from in the drop-down list. If you want to select a table that is not in the list, you can insert a variable in the Table field. When using a variable, use the table ID or table name.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Row index	Position identifying the row to delete. Type the value of the row number (these values are zero based, so Row 1 = 0, Row 2 = 1, etc.). For example if you type a value of 2, row number 3 will be deleted.	Text, Decimal, Integer, Boolean, DateTime, Collection