org-table Row Count Formula

org-table Row Count Formula

[Esben Stien]

I'm trying to figure out how to get the number of rows in an org-table,
but I can't find this in the documentation. 

Anyone have an idea?

-- 
Esben Stien is b0ef@e     s      a             
         http://www. s     t    n m
          irc://irc.  b  -  i  .   e/%23contact
           sip:b0ef@   e     e 
           jid:b0ef@    n     n

Re: org-table Row Count Formula

[Eric Abrahamsen]

Esben Stien <b0ef@esben-stien.name> writes:

> I'm trying to figure out how to get the number of rows in an org-table,
> but I can't find this in the documentation. 
>
> Anyone have an idea?

The vcount function will count the number of elements in a vector, so
you could probably pass a range reference, like @1..@> (first row to
last row) to vcount. I think empty rows would be omitted, though.

Re: org-table Row Count Formula

[Michael Brand]

On Wed, Jul 30, 2014 at 2:52 AM, Eric Abrahamsen
<eric@ericabrahamsen.net> wrote:
> The vcount function will count the number of elements in a vector, so
> you could probably pass a range reference, like @1..@> (first row to
> last row) to vcount.

Yes.

> I think empty rows would be omitted, though.

It depends on whether the mode "E" is used or not, see
http://orgmode.org/manual/Formula-syntax-for-Calc.html

Michael

Re: org-table Row Count Formula

[Thorsten Jolitz]

Esben Stien <b0ef@esben-stien.name> writes:

> I'm trying to figure out how to get the number of rows in an org-table,
> but I can't find this in the documentation. 
>
> Anyone have an idea?

As always, there might be some Org function for this, but otherwise here
is a starting point:

#+begin_src emacs-lisp
  (defun tj/count-tbl-rows (&optional tbl-as-lisp)
    "Return number of tbl rows for tbl at point."
    (interactive)
    (let ((rows (if tbl-as-lisp
                    (length tbl-as-lisp)
                  (length (org-table-to-lisp)))))
      (message "Table has %d Rows" rows)
      rows))
#+end_src

#+results:
: tj/count-tbl-rows

#+NAME: nice-tbl
| pretty | impressive | table |
| pretty | impressive | table |
| pretty | impressive | table |
| pretty | impressive | table |
| pretty | impressive | table |
| pretty | impressive | table |

#+header: :var data=nice-tbl
#+begin_src emacs-lisp 
(tj/count-tbl-rows data)
#+end_src

#+results:
: 6

-- 
cheers,
Thorsten