Display Row Counts

Tags: #<Tag:0x00007f0b091fb178>

How to Display Row Counts Excluding Empty Cell in Handsontable

Hi @kunal

So if I understand - you are planning to count only rows with all the data in the row filled?

If so, you’d need to call a loop to check if that value if null using indexOf on getDataAtRow method. Here’s an example https://jsfiddle.net/handsoncode/m3qg4w68/

thank you for your answer. i want count row data column wise like this
Screenshot%202021-01-27%20144621

So here is an example from the columns https://jsfiddle.net/handsoncode/w8maupkn/
I am just using countCols() instead of countRows() and getDataAtCol() instead of getDataAtRows().

If i select A column i want know only the counts filled rows of A column excluding empty cell of A column .
Screenshot%202021-01-27%20144621
In above image i want show A contains 6 rows like that.

This task is similar to the one above. You just need to use the afterOnCellMouseDown hook if you want to get this information when clicking a header. Example https://jsfiddle.net/handsoncode/v3ya7r10/

how to count only selected cells .
test
in above image i want count only selected column data excluding empty data . i want show like A contains 4 data

Hi @kunal

you can use getSelectedLast method. It return the coordinates of a selected area. You just need to loop over that coordinates with getDataAtCell() method.