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

[James Harkins]

At Tue, 02 Jul 2013 20:40:40 +0530,
Jambunathan K wrote:
> Works here for simple files.
> 
>         M-: (org-odt-convert "file.ods" "csv")
> 
> Executing libreoffice4.0 --headless --convert-to csv --outdir 
> /home/kjambunathan/ /home/kjambunathan/file.ods
> convert /home/kjambunathan/file.ods -> /home/kjambunathan//file.csv using 
> Text - txt - csv (StarCalc)
> 
> Exported to /home/kjambunathan/file.csv
> "/home/kjambunathan/file.csv"
> 
> AFAIK, if you can save as CSV from LO UI, then it should work from the
> command line.

Famous last words: "It should work" :)

Okay, I've just tested with two very simple files at the command line. 
LibreOffice fails to write any output file at all. Apparently this is a common 
problem. Bing finds [1], but ask.libreoffice.org is down.

Here is the transcript for a simple Writer file containing only the word "test":

$ soffice --headless --convert-to html --outdir /home/dlm/Documents/orgtests/ 
/home/dlm/Documents/orgtests/html-table-test-word.odt 

$ ls ht*
html-table.html   html-table.ods  html-table.org~
html-table.html~  html-table.org  html-table-test-word.odt

Anyway, I'm not convinced that org-odt-convert would meet my needs anyway. It 
will have to be a multi-worksheet file, and I'll have to extract just one or 
two of the worksheets. The macro might be the way to go.

hjh

[1] 
http://ask.libreoffice.org/en/question/2641/convert-to-command-line-parameter/