title: Importing excel balance sheet into R
body: <p>I am trying to import into R an excel spreadsheet of a balance sheet, I am trying to import it so it would look more or less like the balance sheet does now.</p>
  
  <pre><code>Assets                2011,    2010,   2009
  Non current assets    32.322   3.111   
  intangible assets     12,222
  </code></pre>
  
  <p>something along those lines. I am also trying to import the second tab also which is a different balance sheet. The idea is that I will probably have 50 or more balance sheets. Would this be inefficient for analysis?</p>
  
  <p>I am only interested in a few of the same variables from each of the balance sheet (think, current assets, non current assets for all the years etc.) is it possible to import just specific rows and columns from an excel spead sheet?</p>
  
  <p>For instance just import;</p>
  
  <pre><code>A) Non current assets   32.322      3.111       322
  B) Current assets   345     543     2.233
  </code></pre>
  
  <p>etc? - the row names do not change so could I use a function to do this?</p>