* org-table export to ods/xlsx etc
@ 2017-06-16 10:25 Uwe Brauer
0 siblings, 0 replies; 9+ messages in thread
From: Uwe Brauer @ 2017-06-16 10:25 UTC (permalink / raw
To: emacs-orgmode
Hi
I am sometimes in need to send my org-table spreadhseets to colleagues
who are using (sigh) excel. I thought sending csv would be enough but it
turns out,
- that sometimes technical inapt people don't know how to open it,
- when using a non english language setting say spanish, numbers
like 3.4 are interpreted as text.
That can be circumvented by sending the spreadheet as ods/xlsx
I did not find any built in function so I came up with two solutions.
One is using gnumeric but then a path must be set to its binaries and
that is platform dependent. The other relies on `org-odt-convert' which
uses in my case LO/OO.
Somebody with better lisp skills might want to generalize the function
to include in a more comfortable way other formats
(defun org-table-export-to-xlsx ()
(interactive)
(let* ((source-file (file-name-sans-extension (buffer-file-name (current-buffer))))
(csv-file (concat source-file ".csv")))
(org-table-export csv-file "orgtbl-to-csv")
(org-odt-convert csv-file "xlsx")))
^ permalink raw reply [flat|nested] 9+ messages in thread
[parent not found: <eca7bd11a4eb4d3bbb600d77484d4449@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>]
* Re: org-table export to ods/xlsx etc
[not found] <eca7bd11a4eb4d3bbb600d77484d4449@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
@ 2017-06-16 15:25 ` Eric S Fraga
2017-06-17 14:54 ` Nicolas Goaziou
` (2 more replies)
0 siblings, 3 replies; 9+ messages in thread
From: Eric S Fraga @ 2017-06-16 15:25 UTC (permalink / raw
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 762 bytes --]
On Friday, 16 Jun 2017 at 10:25, Uwe Brauer wrote:
> Hi
>
> I am sometimes in need to send my org-table spreadhseets to colleagues
> who are using (sigh) excel. I thought sending csv would be enough but it
> turns out,
[...]
> I did not find any built in function so I came up with two solutions.
> One is using gnumeric but then a path must be set to its binaries and
> that is platform dependent. The other relies on `org-odt-convert' which
> uses in my case LO/OO.
Thanks for this. Works nicely! Great addition to the repertoire of
useful emacs-lisp snippets. Would be great to have this incorporated
into org.
If gnumeric (ssconvert) can be an option, that would be great as well.
--
: Eric S Fraga via Emacs 26.0.50, Org release_9.0.7-531-g530113
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 194 bytes --]
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: org-table export to ods/xlsx etc
2017-06-16 15:25 ` Eric S Fraga
@ 2017-06-17 14:54 ` Nicolas Goaziou
2017-06-21 13:01 ` Uwe Brauer
[not found] ` <4e6e65e9ba354c9a8dab18796c1e92dc@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
[not found] ` <a7f661839cd64e268ffe1ccbeb208777@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
2017-06-17 16:38 ` Uwe Brauer
2 siblings, 2 replies; 9+ messages in thread
From: Nicolas Goaziou @ 2017-06-17 14:54 UTC (permalink / raw
To: emacs-orgmode
Hello,
Eric S Fraga <e.fraga@ucl.ac.uk> writes:
> On Friday, 16 Jun 2017 at 10:25, Uwe Brauer wrote:
>> Hi
>>
>> I am sometimes in need to send my org-table spreadhseets to colleagues
>> who are using (sigh) excel. I thought sending csv would be enough but it
>> turns out,
>
> [...]
>
>> I did not find any built in function so I came up with two solutions.
>> One is using gnumeric but then a path must be set to its binaries and
>> that is platform dependent. The other relies on `org-odt-convert' which
>> uses in my case LO/OO.
>
> Thanks for this. Works nicely! Great addition to the repertoire of
> useful emacs-lisp snippets. Would be great to have this incorporated
> into org.
According to `org-odt-convert-processes', `org-odt-convert-capabilities'
and `org-odt-convert', isn't it already possible?
Regards,
--
Nicolas Goaziou
^ permalink raw reply [flat|nested] 9+ messages in thread
[parent not found: <a7f661839cd64e268ffe1ccbeb208777@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>]
* Re: org-table export to ods/xlsx etc
2017-06-16 15:25 ` Eric S Fraga
2017-06-17 14:54 ` Nicolas Goaziou
[not found] ` <a7f661839cd64e268ffe1ccbeb208777@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
@ 2017-06-17 16:38 ` Uwe Brauer
2 siblings, 0 replies; 9+ messages in thread
From: Uwe Brauer @ 2017-06-17 16:38 UTC (permalink / raw
To: emacs-orgmode
> On Friday, 16 Jun 2017 at 10:25, Uwe Brauer wrote:
> [...]
> Thanks for this. Works nicely! Great addition to the repertoire of
> useful emacs-lisp snippets. Would be great to have this incorporated
> into org.
Maybe this is even more useful?
(defun org-table-export-to-spreadsheet (arg)
"Export org table to varios first to cvs and then via LO/OO (or gnumeric)
to various spreadsheet format, the most common are `ods', `xls' and
`xlsx'."
(interactive "sFormat: ")
(let* ((source-file (file-name-sans-extension (buffer-file-name (current-buffer))))
(csv-file (concat source-file ".csv")))
(org-table-export csv-file "orgtbl-to-csv")
(org-odt-convert csv-file arg)))
> If gnumeric (ssconvert) can be an option, that would be great as well.
^ permalink raw reply [flat|nested] 9+ messages in thread
[parent not found: <mailman.87.1497628817.13493.emacs-orgmode@gnu.org>]
* Re: org-table export to ods/xlsx etc
[not found] <mailman.87.1497628817.13493.emacs-orgmode@gnu.org>
@ 2017-06-17 1:41 ` edgar
0 siblings, 0 replies; 9+ messages in thread
From: edgar @ 2017-06-17 1:41 UTC (permalink / raw
To: oub; +Cc: emacs-orgmode
> Message: 19
> Date: Fri, 16 Jun 2017 10:25:55 +0000
> From: Uwe Brauer <oub@mat.ucm.es>
> To: emacs-orgmode@gnu.org
> Subject: [O] org-table export to ods/xlsx etc
> Message-ID: <87fuf0i5zg.fsf@mat.ucm.es>
> Content-Type: text/plain
>
> I am sometimes in need to send my org-table spreadhseets to colleagues
> who are using (sigh) excel. I thought sending csv would be enough but
> it
> turns out,
I want to join you in that *deep* sigh! and thank you for your
contribution. I may eventually have to use it.
> (defun org-table-export-to-xlsx ()
> (interactive)
> (let* ((source-file (file-name-sans-extension (buffer-file-name
> (current-buffer))))
> (csv-file (concat source-file ".csv")))
> (org-table-export csv-file "orgtbl-to-csv")
> (org-odt-convert csv-file "xlsx")))
-------------------------------------------------
ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!
^ permalink raw reply [flat|nested] 9+ messages in thread
end of thread, other threads:[~2017-06-22 7:00 UTC | newest]
Thread overview: 9+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2017-06-16 10:25 org-table export to ods/xlsx etc Uwe Brauer
[not found] <eca7bd11a4eb4d3bbb600d77484d4449@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
2017-06-16 15:25 ` Eric S Fraga
2017-06-17 14:54 ` Nicolas Goaziou
2017-06-21 13:01 ` Uwe Brauer
[not found] ` <4e6e65e9ba354c9a8dab18796c1e92dc@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
2017-06-21 13:43 ` Eric S Fraga
2017-06-22 6:57 ` Uwe Brauer
[not found] ` <a7f661839cd64e268ffe1ccbeb208777@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
2017-06-17 15:50 ` Eric S Fraga
2017-06-17 16:38 ` Uwe Brauer
[not found] <mailman.87.1497628817.13493.emacs-orgmode@gnu.org>
2017-06-17 1:41 ` edgar
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.