UiPath Documentation
activities
latest
false
Productivity activities

DeleteColumn

Delete a specified column from a sheet or range.

Delete a specified column from a sheet or range. The column on the right of the deleted column is then shifted to the left.

Namespace: UiPath.Gsuite.Activities.API

Assembly: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

Overloads​

OverloadDescription
DeleteColumn(ISpreadsheet, IRange, Int32, Boolean, ColumnDeleteMode)Delete a specified column from a sheet or range. The column on the right of the deleted column is then shifted to the left.
DeleteColumn(ISpreadsheet, IRange, String, Boolean, ColumnDeleteMode)Delete a specified column from a sheet or range. The column on the right of the deleted column is then shifted to the left.

DeleteColumn(ISpreadsheet, IRange, Int32, Boolean, ColumnDeleteMode)​

Delete a specified column from a sheet or range. The column on the right of the deleted column is then shifted to the left.

public void DeleteColumn(
	ISpreadsheet spreadsheet,
	IRange range,
	int columnIndex,
	bool hasHeaders = true,
	ColumnDeleteMode deleteMode = ColumnDeleteMode.Delete
)
public void DeleteColumn(
	ISpreadsheet spreadsheet,
	IRange range,
	int columnIndex,
	bool hasHeaders = true,
	ColumnDeleteMode deleteMode = ColumnDeleteMode.Delete
)

spreadsheet ISpreadsheet : The target spreadsheet to delete columns from.

range IRange : The range where to delete the column.

columnIndex Int32 : Specify a column position to delete. The first position is 0.

hasHeaders Boolean (Optional) : If selected, the column headers are generated by reading the range header.

deleteMode ColumnDeleteMode (Optional) : Indicates the delete mode.

DeleteColumn(ISpreadsheet, IRange, String, Boolean, ColumnDeleteMode)​

Delete a specified column from a sheet or range. The column on the right of the deleted column is then shifted to the left.

public void DeleteColumn(
	ISpreadsheet spreadsheet,
	IRange range,
	string columnName,
	bool hasHeaders = true,
	ColumnDeleteMode deleteMode = ColumnDeleteMode.Delete
)
public void DeleteColumn(
	ISpreadsheet spreadsheet,
	IRange range,
	string columnName,
	bool hasHeaders = true,
	ColumnDeleteMode deleteMode = ColumnDeleteMode.Delete
)

spreadsheet ISpreadsheet : The target spreadsheet to delete columns from.

range IRange : The range where to delete the column.

columnName String : Specify a column to delete.

hasHeaders Boolean (Optional) : If selected, the column headers are generated by reading the range header.

deleteMode ColumnDeleteMode (Optional) : Indicates the delete mode.

Was this page helpful?

Connect

Need help? Support(opens in new window)

Want to learn? UiPath Academy(opens in new window)

Have questions? UiPath Forum(opens in new window)

Stay updated