From mboxrd@z Thu Jan  1 00:00:00 1970
From: Rob Stewart <robstewart57@gmail.com>
Subject: Re: import R data frame into org-mode table
Date: Mon, 29 Jul 2013 15:42:41 +0100
Message-ID: <CA+ZOasJAKR_BXJuJa1VVdo2MdzGmTa9-zwWDu1zUk9AcRVEtAw@mail.gmail.com>
References: <CA+ZOasK8vN1dT_tVePVzOpTM3VdojoWCsvmhPZCzvV-k1CSjug@mail.gmail.com>
	<87mwpket4b.fsf@med.uni-goettingen.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:36162)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <robstewart57@gmail.com>) id 1V3ofF-0003vf-Fe
	for emacs-orgmode@gnu.org; Mon, 29 Jul 2013 10:43:12 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <robstewart57@gmail.com>) id 1V3of9-0000eh-0T
	for emacs-orgmode@gnu.org; Mon, 29 Jul 2013 10:43:09 -0400
Received: from mail-pa0-x22b.google.com ([2607:f8b0:400e:c03::22b]:50797)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <robstewart57@gmail.com>) id 1V3of8-0000eP-Qj
	for emacs-orgmode@gnu.org; Mon, 29 Jul 2013 10:43:02 -0400
Received: by mail-pa0-f43.google.com with SMTP id hz10so4920433pad.30
	for <emacs-orgmode@gnu.org>; Mon, 29 Jul 2013 07:43:01 -0700 (PDT)
In-Reply-To: <87mwpket4b.fsf@med.uni-goettingen.de>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Andreas Leha <andreas.leha@med.uni-goettingen.de>
Cc: emacs-orgmode@gnu.org

Hi Andreas,

On 17 July 2013 23:09, Andreas Leha <andreas.leha@med.uni-goettingen.de> wrote:

> Definitely there is:
>
> --8<---------------cut here---------------start------------->8---
> #+begin_src R :results table :colnames yes
>   read.csv('test.csv')
> #+end_src
>
> #+results:
> | X | Variant | Xaxis | N |   mean |   sd |   se |
> |---+---------+-------+---+--------+------+------|
> | 1 | line1   |    10 | 5 | 111.11 | 9.33 | 3.11 |
> | 1 | line1   |    20 | 5 | 112.11 | 9.13 | 3.14 |
> | 1 | line1   |    30 | 5 | 113.11 | 9.43 |  3.1 |
> | 1 | line2   |    10 | 5 | 101.11 | 8.33 | 2.11 |
> | 1 | line2   |    20 | 5 | 100.11 | 8.13 | 2.12 |
> | 1 | line2   |    30 | 5 | 108.11 | 8.03 |  2.1 |
>
> --8<---------------cut here---------------end--------------->8---

Great. I've gone ahead and done this. There are two additional requirements:
1) My table needs a caption. Will #+CAPTION: just above the
#+BEGIN_SRC just work? Even better, a label, allowing me to also cross
reference it.
2) My table is too long for 1 page. It spans multiple pages
vertically. According to this StackOverflow answer
http://stackoverflow.com/a/2896850/1526266 , I should instead use
longtable, not tabular. Is there a way to coerce your above snippet to
use longtable, instead of tabular which is the default.

Thanks!

--
Rob