Activities
latest
false
Productivity Activities
Last updated Jul 1, 2024

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

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?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.