Re: Use babel to import table data from OpenDocument spreadsheets?

[James Harkins <jamshark70@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 410 bytes --]

At Thu, 18 Jul 2013 14:49:16 +0530,
Jambunathan K wrote:
> 1. Give me a sample worksheet.

Attached.

> 2. Give me the specific unoconv command that you used for converting the
>    worksheet.

unoconv -f csv -i 9,34,system,1,1/5/2/1/3/1/4/1 html-table.ods

Maybe the filename needs a full path, not sure. I can supply that later.

> If you do (1) and (2), I will post a recipe.

Really appreciate that!

hjh


[-- Attachment #2: html-table.org --]
[-- Type: text/plain, Size: 677 bytes --]

#+OPTIONS: html-postamble:auto html-preamble:t tex:t
#+CREATOR: <a href="http://www.gnu.org/software/emacs/">Emacs</a> 23.3.1 (<a href="http://orgmode.org">Org</a> mode 8.0.2)
#+HTML_CONTAINER: div
#+HTML_DOCTYPE: xhtml-strict
#+EXCLUDE_TAGS: noexport


* Table test

After running the script, I expect the existing table (with 1, 2, 3 in
the second column) to be replaced by the new table data (10, 20, 30).

#+name: gettable1
#+begin_src emacs-lisp :exports none
(... don't know what to write in here...)
#+end_src

#+name: table1
#+ATTR_HTML: :border 2 :rules all :frame border
| Simple | Table |
|--------+-------|
|      1 |     1 |
|      2 |     2 |
|      3 |     3 |


[-- Attachment #3: html-table.ods --]
[-- Type: application/vnd.oasis.opendocument.spreadsheet, Size: 8788 bytes --]