get active spreadsheet rows code example

Example 1: sql count duplicate rows

SELECT _column, COUNT(*) 
FROM _table
GROUP BY _column
HAVING COUNT(*) > 1

Example 2: datatables get all rows

var table = $('#example').DataTable(); 

table.rows().data().map((row) => {
  // each row is an array where each column is an element in the array
  // as a string
}