emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Thorsten Jolitz <tjolitz@gmail.com>
To: emacs-orgmode@gnu.org
Subject: Re: manipulate org tables using emacs-lisp
Date: Sat, 01 Oct 2016 18:32:45 +0200	[thread overview]
Message-ID: <87intcyqqa.fsf@gmail.com> (raw)
In-Reply-To: m2oa345ugr.fsf@polytechnique.org

Alan Schmitt <alan.schmitt@polytechnique.org> writes:

Hi Alan,

> On 2016-09-30 22:52, Thorsten Jolitz <tjolitz@gmail.com> writes:
>
>>> Are there functions for manipulating org-tables using emacs-lisp? More
>>> precisely, I would like to refer to a table by its name, read some cells
>>> (either by position or by matching some given text with some text in the
>>> first row/column), and write in some cells.
>>
>> ,----[ C-h f org-table-to-lisp RET ]
>> | org-table-to-lisp is an autoloaded compiled Lisp function in
>> | ‘../org-mode/lisp/org-table.el’.
>> | 
>> | (org-table-to-lisp &optional TXT)
>> | 
>> | Convert the table at point to a Lisp structure.
>> | The structure will be a list.  Each item is either the symbol ‘hline’
>> | for a horizontal separator line, or a list of field values as strings.
>> | The table is taken from the parameter TXT, or from the buffer at point.
>> | 
>> | [back]
>> `----
>>
>> returns the table as a nested list you can map with lots of Elisp
>> functions (like mapcar). 
>>
>> Ex.:
>>
>> | my | tab |
>> |  1 |   2 |
>>
>> =>
>>
>> (("my" "tab") ("1" "2"))
>
> This is very useful, thank you. But how do I go to a named table? I
> found org-babel-goto-named-block, but nothing for tables.

you can try

,----[ C-h f org-table-map-tables RET ]
| org-table-map-tables is a compiled Lisp function in
| ‘../org-mode/lisp/org.el’.
| 
| (org-table-map-tables FUNCTION &optional QUIETLY)
| 
| Apply FUNCTION to the start of all tables in the buffer.
| 
| [back]
`----

to go to all tables in the buffer, then inside FUNCTION you would need
to check first if the table is named and is the one your are looking
for. If so, get the table as list, work on the list, and insert the new
table replacing the old one (org-dp-create-table inserts a table when
given a nested list). 
Finally move point to the end of the inserted table, so the mapping
function can continue.

PS
org-element and org-dp allow you to do these things too, maybe even
more comfortably if you are familiar with these libraries. But right now
I'm not really able to give you a working example in reasonable time.

-- 
cheers,
Thorsten

  reply	other threads:[~2016-10-01 16:33 UTC|newest]

Thread overview: 6+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2016-09-30  6:27 manipulate org tables using emacs-lisp Alan Schmitt
2016-09-30 20:52 ` Thorsten Jolitz
2016-10-01  8:44   ` Alan Schmitt
2016-10-01 16:32     ` Thorsten Jolitz [this message]
2016-10-02  7:19     ` Heikki Lehvaslaiho
2016-10-03 12:58       ` Alan Schmitt

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87intcyqqa.fsf@gmail.com \
    --to=tjolitz@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).