title: Skip rows while use read_excel or read.excel in R
body: <p>I have a excel file like this:</p>
  <p><a href="https://i.stack.imgur.com/NgDJg.png" rel="noreferrer"><img src="https://i.stack.imgur.com/NgDJg.png" alt="enter image description here" /></a></p>
  <p>I try to read it in <code>read.xlsx</code> or <code>read_excel</code> by skipping the second row:</p>
  <pre><code>library(xlsx)
  df &lt;- read.xlsx('./data.xls', 'Sheet1')
  
  library(readxl)
  df &lt;- read_excel(&quot;./data.xls&quot;, sheet = 'Sheet0', skip = 2, col_names = TRUE)
  </code></pre>
  <p>The first one (<code>read.xlsx</code>), I didn't find parameters for <code>skip</code> rows, the second one give a <code>df</code> without headers.</p>
  <p>Where did I do wrong in the code above and how to read it correctly? Thanks.</p>