title: Using the XBRL package in R to organize financial statements into dataframes
body: <p>I've been trying to isolate income statements, balance sheets, and cash flow data from the sec website using the XBRL package in R.  Ideally, I would input the three into separate data frames with the hopes of exporting the data to a uniform product in excel.</p>
  
  <p>I am able to print out the statements in the R console with the following commands:</p>
  
  <pre><code>inst &lt;- "http://www.sec.gov/Archives/edgar/data/1223389/000122338914000023/conn-20141031.xml"
  options(stringsAsFactors = FALSE)
  xbrl.vars &lt;- xbrlDoAll(inst)
  xbrl.sec &lt;- xbrlSECdev01(xbrl.vars)
  xbrl.sec$showStatements()
  </code></pre>
  
  <p>but I am unable to create a data frame to hold all this information.</p>
  
  <p>So far, I've tried:</p>
  
  <pre><code>conn.data &lt;- xbrl.sec$showStatements()
  </code></pre>
  
  <p>Unfortunately, this just prints out the data again and leaves <code>conn.data</code> NULL.</p>
  
  <p>Any idea how to store this data?</p>
  
  <p>"<a href="https://stackoverflow.com/questions/22676623/how-to-take-the-lists-created-by-xbrldoall-in-the-xbrl-package-in-r-and-organiz">How to take the lists created by xbrlDoAll in the XBRL package in R, and organize them into dataframes readable in Excel?</a>" was asked last March and was left unanswered.</p>