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-name) (interactive "fFile: ") (let ((csv-file (org-odt-convert file-name "csv")) (pos (point))) (save-excursion (insert (with-temp-buffer (insert-file-contents csv-file) (org-table-convert-region (point-min) (point-max) '(4)) (buffer-string)))))) | Simple | Table | | 1 | 10 | | 2 | 20 | | 3 | 30 | Remember to close all libreoffice applications. THIS IS IMPORTANT. Otherwise `org-odt-convert' will error out. 0. Visit scratch buffer 1. Install the above snippet 2. Go to end of the scratch buffer. 3. M-x org-table-import-ods RET You will see something like what I see above. James Harkins <jamshar...@gmail.com> writes: > 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 sure. I can supply that later. > >> If you do (1) and (2), I will post a recipe. > > Really appreciate that! > > hjh