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

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 jamshar...@gmail.com writes: At Wed, 10 Jul 2013 09:20:25 +0530, Jambunathan K wrote: James Harkins

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

2013-07-18 Thread Jambunathan K
Jambunathan K kjambunat...@gmail.com 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

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 jamshar...@gmail.com 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

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

2013-07-10 Thread Andreas Leha
Hi James, James Harkins jamshar...@gmail.com 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

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 jamshar...@gmail.com 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'.

[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

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 headless

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 jamshar...@gmail.com 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

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

2013-07-02 Thread Jambunathan K
James Harkins jamshar...@gmail.com 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

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 jamshar...@gmail.com writes: Famous last words: It should work :) Sure. As magical as running and talking at the same time.