Manipulating Rows and Columns

Working with Columns

Hiding/showing columns

You can hide and show a column on the sheet, using the hideColumn method. It takes two parameters:

  • columnId - (number) the column id
  • state - (boolean) true - to hide the column, false - to show it
$$("ssheet").hideColumn(2, true);

Inserting a new column

To insert a new column to left of the specified one, use the insertColumn method. The method takes the id of the column before which a new column will be inserted as a parameter.

$$("ssheet").insertColumn(3);

If the column id isn't specified, a new column will be inserted before the selected one.

Deleting a column

You can also delete a particular column by passing its id to the deleteColumn method.

$$("ssheet").deleteColumn(3);

Without the parameter, the method deletes the selected column.

Getting the column's config

It's possible to get the configuration object of a column by using the getColumn. You need to pass the column id as a parameter.

var config = $$("ssheet").getColumn(5);

The method returns the column's configuration object.

Checking the column's visibility

You can check the visibility of a column by using the isColumnVisible method. The method takes the id of a column as a parameter:

var isVisible = $$("ssheet").isColumnVisible(2);

The method returns true, if the column is visible and false if it's hidden.

Working with Rows

Hiding/showing rows

You can hide and show a row in the sheet, using the hideRow method. It takes two parameters:

  • rowId - (number) the row id
  • state - (boolean) true - to hide the row, false - to show it
$$("ssheet").hideRow(2, true);

Inserting a new row

To insert a new row above the specified one, use the insertRow method. The method takes the id of the row above which a new row will be inserted as a parameter.

$$("ssheet").insertRow(3);

If the row id isn't specified, a new row will be inserted above the selected one.

Deleting a row

You can also delete a particular row by passing its id to the deleteRow method.

$$("ssheet").deleteRow(3);

Without the parameter, the method deletes the selected row.

Getting the row's data

It's possible to get the data of a row by using the getRow. You need to pass the row id as a parameter.

var data = $$("ssheet").getRow(5);

The method returns an object with the row's data.

Checking the row's visibility

You can check the visibility of a row by using the isRowVisible method. The method takes the id of a column as a parameter:

var isVisible = $$("ssheet").isRowVisible(2);

The method returns true, if the row is visible and false if it's hidden.

Back to top
If you have not checked yet, be sure to visit site of our main product Webix ui component library
and page of javascript spreadshee product.