From mboxrd@z Thu Jan  1 00:00:00 1970
From: James Harkins <jamshark70@gmail.com>
Subject: Re: Use babel to import table data from OpenDocument spreadsheets?
Date: Wed, 03 Jul 2013 10:35:51 +0800
Message-ID: <87vc4s5q0o.wl%jamshark70@dewdrop-world.net>
References: <87k3l9kq78.wl%jamshark70@dewdrop-world.net>
	<878v1pvybk.fsf@gmail.com>
	<87y59p591f.wl%jamshark70@dewdrop-world.net>
	<87y59p80b3.fsf@gmail.com>
Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka")
Content-Type: text/plain; charset=US-ASCII
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:41487)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <jamshark70@gmail.com>) id 1UuCvS-0000ZQ-Qz
	for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 22:36:12 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <jamshark70@gmail.com>) id 1UuCvR-0007Vq-EF
	for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 22:36:10 -0400
Received: from mail-pb0-x22a.google.com ([2607:f8b0:400e:c01::22a]:58051)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <jamshark70@gmail.com>) id 1UuCvR-0007Vb-6z
	for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 22:36:09 -0400
Received: by mail-pb0-f42.google.com with SMTP id un1so6868598pbc.15
	for <emacs-orgmode@gnu.org>; Tue, 02 Jul 2013 19:36:08 -0700 (PDT)
In-Reply-To: <87y59p80b3.fsf@gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Jambunathan K <kjambunathan@gmail.com>
Cc: orgmode <emacs-orgmode@gnu.org>

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/