DeleteColumn

Delete a specified column from a sheet or range.

Namespace: UiPath.MicrosoftOffice365.Activities.Api

Assembly: UiPath.MicrosoftOffice365.Activities.Api (in UiPath.MicrosoftOffice365.Activities.Api.dll)

Overloads

Overload	Description
DeleteColumn(IWorkbook, 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(IWorkbook, 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(IWorkbook, 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.

void DeleteColumn(
	IWorkbook workbook,
	IRange range,
	int columnIndex,
	bool hasHeaders = true,
	ColumnDeleteMode deleteMode = ColumnDeleteMode.Delete
)

workbook IWorkbook

The target workbook 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(IWorkbook, 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.

void DeleteColumn(
	IWorkbook workbook,
	IRange range,
	string columnName,
	bool hasHeaders = true,
	ColumnDeleteMode deleteMode = ColumnDeleteMode.Delete
)

workbook IWorkbook

The target workbook to delete columns from.

range IRange

The range from 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.