On Jan 23, 2009, at 2:37 AM, Eric Schulte wrote:
Dan Davison <address@hidden> writes:
On Mon, Dec 22, 2008 at 12:00:14PM -0500, Eric Schulte wrote:
Hi Dan,
<...>
2) Also interesting is the idea of referencing a table from a
block of R
code elsewhere in the org file. I've worked some on processing
blocks of R code in org files in a manner similar to Sweave.
http://github.com/eschulte/org-contrib/tree/master/org-exp-blocks.el
If we could implement a simple means of referencing tables (either
whole tables, or cells/cols/rows of tables) from these R-code
blocks
then that seems like it may be fairly powerful.
I agree with this. So in the case of my code, I think we would
like to
be able to do something like
#+TBLR: data:<org-table-reference> columns:(1 2) action:tabulate
This would make the output of the analysis/plot of the table pointed
to by <org-table-reference> appear at the location in the file of
the
#+TBLR line. Perhaps one design aim would be to have the same
mechanism work for referencing tables for processing by #TBLFM,
org-plot, org-table-R, org-exp-blocks, etc.
That sounds like a very good idea. A uniform interface for
referencing
table ranges (either globally from outside of the table or locally
from
within the table) that could be used for any table formula be it in
calc, R, elisp, etc... I find the idea of easily accessing and
writing
table data from external tools very intriguing
For what it is worth, here is a function that will grab a field value
or a range from a remote table, be it in the current file or in a
different file. That is not yet a syntax to have such a reference
in a formula, but it is the most important component, and maybe it
will
already be useful for you.
This function uses an entry ID to access the table - obviously
other schemes like table naming could be used.
It is not going to be very fast, and multiple accesses
to the same remote table would each cause the same overhead,
but it sure is working.
- Carsten
(defun org-table-remote-range (id form
&optional replace keep-empty numbers lispp)
"Get a field value or a list of values in a range from table at ID.