Skip to main content

deleteColumn()

Description​

Removes a column from the spreadsheet

info

The method finds the specified cell, selects it, removes the column where the cell is located and moves the column on the left to its position.

Usage​

deleteColumn(cell: string): void;

Parameters​

  • cell - (required) the id of a cell that contains the name of the column that should be deleted

Example​

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {});
spreadsheet.parse(data);

// removes the "G" column
spreadsheet.deleteColumn("G2");
note

You can delete several columns by providing a range of cells' ids as a parameter of the method, for example: "A1:C3".

Related article: Work with Spreadsheet