Activities
latest
false
Productivity Activities
Last updated Jun 3, 2024

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

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?

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