Display Row Counts
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
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 .
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 .
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.