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

[Jambunathan K]

James Harkins <address@hidden> writes:

> At Tue, 02 Jul 2013 19:49:43 +0530,
> Jambunathan K wrote:
>> M-x org-odt-convert RET
>> 
>> or
>> 
>> (org-odt-convert ......)
>
> Is this valid for .ods, or only .odt? The file is from LibreOffice Calc, not 
> Writer.
>
> I made a quick test and got only "failed." From the Messages, I can
> see it's using a headless soffice, so maybe it needs some other
> command line parameters. That will have to wait for another
> day... busy with other things now.
>
> Debug (ox-odt): Searching for OpenDocument styles files...
> Debug (ox-odt): Trying /usr/share/emacs/etc/org/styles/...
> Debug (ox-odt): Using styles under /usr/share/emacs/etc/org/styles/
> Debug (ox-odt): Searching for OpenDocument schema files...
> Debug (ox-odt): Trying /usr/share/emacs/etc/org/schema/...
> Debug (ox-odt): Using schema files under /usr/share/emacs/etc/org/schema/
> Making completion list...
> Executing soffice --headless --convert-to csv --outdir
> /home/dlm/Documents/xinghai/12-13-spring/
> /home/dlm/Documents/xinghai/12-13-spring/gradesheet.ods
>
> Export to /home/dlm/Documents/xinghai/12-13-spring/gradesheet.csv failed

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.  

Start with a simple file and isolate the issue.

> hjh