title: openxlsx having problems with detect dates
body: <p>I'm using the package <code>openxlsx</code> to open a .xlsx file into <code>R</code>. This is a basic example of the data I'm trying to read: </p>
  
  <p><a href="https://i.stack.imgur.com/V9wdv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V9wdv.png" alt="enter image description here"></a></p>
  
  <p>This is the code I use to read the excel:</p>
  
  <p><code>read.xlsx("F:/Test.xlsx",colNames = T,detectDates = T)</code> </p>
  
  <p>but i get the following error:</p>
  
  <pre><code>Error in read.xlsx.default("F:/Test.xlsx", colNames = T, detectDates = T) : 
    basic_string::substr: __pos (which is 8) &gt; this-&gt;size() (which is 2)
  </code></pre>
  
  <p>If I delete the first row of the excel I keep getting the same error. And it's really wired because the last time I run the script (2 weeks ago) the Excel was in the same format and I didn't get this error and I haven't updated R or Rstudio or the package. </p>