Breaking News: Grepper is joining You.com. Read the official announcement!

Getting the cell values for a selected row

answered on September 2, 2022 Popularity 3/10 Helpfulness 1/10

answer Getting the cell values for a selected row

Getting the cell values for a selected row

Comment

var data = [
  ["", "Ford", "Volvo", "Toyota", "Honda"],
  ["2014", 10, 11, 12, 13],
  ["2015", 20, 11, 14, 13],
  ["2016", 30, 15, 12, 13]
];

var container = document.getElementById('example');
var hot = new Handsontable(container, {
  data: data,
  minSpareRows: 1,
  rowHeaders: true,
  colHeaders: true,
  contextMenu: true
});


// create a hook with an event from Handstable core events 
hot.addHook('afterSelection', function(row,column){
  const selectedCell = hot.getDataAtCell(row,column); 
  const selectedCol = hot.getDataAtCol(column);
  const selectedRow = hot.getDataAtRow(row);
  
  console.log(`selected cell [${row}][${column}] with value [${selectedCell}]`)
  console.log(`column values: ${JSON.stringify(selectedCol)}`);
  console.log(`row values: ${JSON.stringify(selectedRow)}`)
});

Popularity 3/10 Helpfulness 1/10 Language javascript

Source: stackoverflow.com

Tags: cell javascript row selected

Link to this answer
Share Copy Link

Contributed on Sep 02 2022

0 Answers Avg Quality 2/10

Getting the cell values for a selected row

Contents

More Related Answers

Getting the cell values for a selected row

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.