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

[Jambunathan K <kjambunathan@gmail.com>]

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 <jamshark70@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