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

2013-07-02 Thread James Harkins
Just wondering if anyone out there has some magic code snippets that will automatically bring in data from a LibreOffice spreadsheet during HTML export. I think I could save, by hand, the required worksheets out of the ods file into separate CSVs, and then write an emacs-lisp Babel block to impo

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

2013-07-02 Thread James Harkins
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 head

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

2013-07-02 Thread Jambunathan K
M-x org-odt-convert RET or (org-odt-convert ..) James Harkins writes: > Just wondering if anyone out there has some magic code snippets that > will automatically bring in data from a LibreOffice spreadsheet during > HTML export. > > I think I could save, by hand, the required worksheets

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

2013-07-02 Thread Jambunathan K
James Harkins 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 t

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

2013-07-02 Thread 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 ->

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

2013-07-02 Thread Jambunathan K
James Harkins writes: > Famous last words: "It should work" :) Sure. As magical as running and talking at the same time.

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

2013-07-09 Thread James Harkins
At Wed, 03 Jul 2013 10:35:51 +0800, James Harkins wrote: > 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. I've made a bit more

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

2013-07-09 Thread Jambunathan K
James Harkins writes: > I found a utility, unoconv[1], which I can persuade to produce a > tab-separated export of the first worksheet of an ODS document. FYI, unoconv is an option provided by `org-odt-convert-processes'.

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

2013-07-10 Thread Andreas Leha
Hi James, James Harkins writes: > At Wed, 03 Jul 2013 10:35:51 +0800, > James Harkins wrote: >> 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

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

2013-07-17 Thread James Harkins
At Wed, 10 Jul 2013 09:20:25 +0530, Jambunathan K wrote: > James Harkins writes: > > > I found a utility, unoconv[1], which I can persuade to produce a > > tab-separated export of the first worksheet of an ODS document. > > FYI, unoconv is an option provided by `org-odt-convert-processes'. Than

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

2013-07-18 Thread James Harkins
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

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

2013-07-18 Thread James Harkins
At Fri, 19 Jul 2013 00:32:44 +0530, Jambunathan K wrote: > I don't want to venture in to Babel. > > I don't want to experiment with unoconv either. I have a non-official > libreoffice installed. Pulling in official unoconv will interfere with > my working installation. Fair enough. > For your

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

2013-07-18 Thread Jambunathan K
I don't want to venture in to Babel. I don't want to experiment with unoconv either. I have a non-official libreoffice installed. Pulling in official unoconv will interfere with my working installation. For your purposes, just soffice will do. (defun org-table-import-ods (&optional file-nam

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

2013-07-18 Thread Jambunathan K
1. Give me a sample worksheet. 2. Give me the specific unoconv command that you used for converting the worksheet. If you do (1) and (2), I will post a recipe. James Harkins writes: > At Wed, 10 Jul 2013 09:20:25 +0530, > Jambunathan K wrote: >> James Harkins writes: >> >> > I found a

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

2013-07-18 Thread Jambunathan K
Jambunathan K writes: > I don't want to venture in to Babel. > > I don't want to experiment with unoconv either. I have a non-official > libreoffice installed. Pulling in official unoconv will interfere with > my working installation. > > For your purposes, just soffice will do. > > > (defun o