ce icon indicating copy to clipboard operation
ce copied to clipboard

Event - How to get Row and Column Number

Open azrulharis opened this issue 4 years ago • 1 comments

Hello,

anyone can explain how to get the row and column number?

Ie: onkeyup on some column, it will return A8

Thank you in advance

azrulharis avatar Jan 11 '21 08:01 azrulharis

for transform A8 to 0,7 (x, y) use : jexcel.getIdFromColumnName(cellName, returnArrayFormat)

from cell you can read x,y position with read attribute.

var x = parseInt(cell.getAttribute("data-x"));
var y = parseInt(cell.getAttribute("data-y"));

GBonnaire avatar Jan 19 '21 10:01 GBonnaire