title: Validate Data jQuery Handsontable input
body: <p>Q1:What is the best way to validate the data entered by user in jQuery Handsontable before sending to Server?</p>
  
  <p>I have read this article
  <a href="https://stackoverflow.com/questions/10831969/upload-jquery-handsontable-input">Upload jQuery Handsontable input</a></p>
  
  <p>Is there any integrate solution? etc integrating to the jquery validation plugin,if not, how about using the onbeforechange() method?</p>
  
  <p>Q2:What's more, I have initiated a 100 rows table , but it's probably the user would input only 50 rows, if I use the code below:</p>
  
  <pre><code>$('#btnGo').click(function() { 
    var rowList = $("#example9grid").handsontable("getData"); 
    $('#simple').val(JSON.stringify(rowList)); 
    console.log(rowList); 
  });​ 
  </code></pre>
  
  <p>the <strong>rowList</strong> would return 50 data rows and 50 empty rows.</p>
  
  <p>How to remove all the empty rows?</p>