DeleteColumn

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

Overload	Description
`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
)