title: Reading data from Excel file in r
body: <p>I want to read data from a big excel file like this:</p>
  
  <p>From the fifth column, from first row until 140, but only 1,3,5,7,.....139 (only 70 values):</p>
  
  <pre><code>wb &lt;- loadWorkbook("D:\\MA\\excel_mix_meiningen.xlsx")
  dat &lt;-readWorksheet(wb, sheet=getSheets(wb)[1], startRow=1, endRow=139, startCol=5, endCol=5)
  odds &lt;- function(x) {seq(1, length(x), 2)}
  odds(unlist(dat))
  </code></pre>
  
  <p>but I get this error:</p>
  
  <pre><code>Error: OutOfMemoryError (Java): Java heap space
  </code></pre>
  
  <p>Is there another way to do this job?</p>