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.

Namespace: UiPath.MicrosoftOffice365.Activities.Api

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

Overloads​

OverloadDescription
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
)
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
)
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.

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