title: How to get the first row that is data free in Excel using Node js?
body: <p>I need to get the first row that is free of data of an Excel worksheet, in order to write on it from the code.</p>
  <p>I have this example:
  <a href="https://i.stack.imgur.com/fSEtI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fSEtI.png" alt="enter image description here" /></a></p>
  <p>The code should output the numbers 6 or 8 (does not matter, they are both fine), because each of them represent the row that is free of data, and is able to be written.</p>
  <p>I tried this code:</p>
  <pre><code>for (let i = 1; i &lt; 100; i++){
      if (xlsx.utils.sheet_to_json(shoopingWorksheet[&quot;!rows&quot;] === &quot; &quot;)){
          console.log(i);
      }
  }
  </code></pre>
  <p>but it is not really the proper way to do this, nor it is working...</p>
  <p>So the steps are: [in Node.js]</p>
  <ol>
  <li>Iterate through all the rows (first column is enough).</li>
  <li>Verify whether that each A[i] is empty.</li>
  <li>If it empty, then print it (console.log(i)).</li>
  </ol>
  <p>So, how do I iterate through all the rows, on their first column, and verify if that tab is free of data?</p>