title: How to skip blank rows while reading XLSB file to save read time
body: <p><strong>Goal</strong>
  To skip reading the file and insert the read data in dataframe when the column Year hits blank.</p>
  <p><strong>Purpose</strong>
  My input file has 1 million rows for <code>companyName</code> column but the other data is blank as soon as <code>Year</code> column goes blank. If I can ready the xlsb only until the function hits blank in <code>Year</code> column the file read speed will increase drastically.</p>
  <p><strong>My attempt</strong></p>
  <pre><code>
  read_excel &lt;- read_xlsb (&quot;C:/Tempdata/temp.xlsb&quot;, sheet = &quot;tmp&quot;, trim_ws = TRUE, na = &quot;&quot;, range = &quot;tmp!A1:D10000&quot;)
  </code></pre>
  <p>I am using <strong>range</strong> to limit the read but its not the best way to do it as the number of rows with data may change in future files.</p>
  <p><strong>Can someone please suggest a good way to do it?</strong></p>
  <p>I have a table in xlsb (excel binary format):</p>
  <pre><code> companyName   Year   dataname     values
  
   company1      1980   sheetname1     5
   company1      1981   sheetname1     6
   company1      1982   sheetname1     7
   company1      1980    sheetname1     1
   company1      2016   sheetname1     8
   company2      1980   sheetname1     10
   company2      1981   sheetname1     20
   company2      1982   sheetname1     30
   company2      1980    sheetname1     14
   company2      2016   sheetname1     40
   company1      2000    sheetname2     xxx
   company1      2001    Name           yyy
   company1      
   company1      
   company1 
  </code></pre>
  <p>I am using the <code>read_xlsb() </code> from the
  <code>library(readxlsb)</code></p>