* 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; 11+ 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] 11+ messages in thread* Re: org-table export to ods/xlsx etc
2017-06-16 15:25 ` org-table export to ods/xlsx etc 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 ` org-table export to ods/xlsx etc Uwe Brauer
2 siblings, 2 replies; 11+ 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] 11+ messages in thread[parent not found: <a7f661839cd64e268ffe1ccbeb208777@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>]
* Re: org-table export to ods/xlsx etc
[not found] ` <a7f661839cd64e268ffe1ccbeb208777@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
@ 2017-06-17 15:50 ` Eric S Fraga
2017-06-26 15:27 ` [setting is not read] (was: org-table export to ods/xlsx etc) Uwe Brauer
0 siblings, 1 reply; 11+ messages in thread
From: Eric S Fraga @ 2017-06-17 15:50 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 482 bytes --]
On Saturday, 17 Jun 2017 at 14:54, Nicolas Goaziou wrote:
[...]
> According to `org-odt-convert-processes', `org-odt-convert-capabilities'
> and `org-odt-convert', isn't it already possible?
Indeed. <blush> Adding this
(add-to-list 'org-odt-convert-processes '("gnumeric" "ssconvert %i %o"))
(setq org-odt-convert-process "gnumeric")
is all that is needed. As always, why am I surprised? :-)
Thanks.
--
: Eric S Fraga via Emacs 26.0.50, Org release_9.0.6-425-gf4fca1
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 194 bytes --]
^ permalink raw reply [flat|nested] 11+ messages in thread* [setting is not read] (was: org-table export to ods/xlsx etc)
2017-06-17 15:50 ` Eric S Fraga
@ 2017-06-26 15:27 ` Uwe Brauer
2017-06-26 15:53 ` [setting is not read] Nick Dokos
0 siblings, 1 reply; 11+ messages in thread
From: Uwe Brauer @ 2017-06-26 15:27 UTC (permalink / raw)
To: emacs-orgmode
>>> "Eric" == Eric S Fraga <e.fraga@ucl.ac.uk> writes:
> On Saturday, 17 Jun 2017 at 14:54, Nicolas Goaziou wrote:
> [...]
>> According to `org-odt-convert-processes', `org-odt-convert-capabilities'
>> and `org-odt-convert', isn't it already possible?
> Indeed. <blush> Adding this
> (add-to-list 'org-odt-convert-processes '("gnumeric" "ssconvert %i %o"))
> (setq org-odt-convert-process "gnumeric")
Odd thing. I put these lines in my org_init.el file byte compile and
restart emacs but then
(org-odt-do-reachable-formats "csv") returns
Nil
I have to explicitly eval the two settings
(add-to-list 'org-odt-convert-processes '("gnumeric" "/usr/bin/ssconvert %i %o"))
(setq org-odt-convert-process "gnumeric")
What do I miss? I could use customize of course, but I would like to
understand the problem.
^ permalink raw reply [flat|nested] 11+ messages in thread* Re: [setting is not read]
2017-06-26 15:27 ` [setting is not read] (was: org-table export to ods/xlsx etc) Uwe Brauer
@ 2017-06-26 15:53 ` Nick Dokos
0 siblings, 0 replies; 11+ messages in thread
From: Nick Dokos @ 2017-06-26 15:53 UTC (permalink / raw)
To: emacs-orgmode
Uwe Brauer <oub@mat.ucm.es> writes:
>>>> "Eric" == Eric S Fraga <e.fraga@ucl.ac.uk> writes:
>
> > On Saturday, 17 Jun 2017 at 14:54, Nicolas Goaziou wrote:
> > [...]
>
> >> According to `org-odt-convert-processes', `org-odt-convert-capabilities'
> >> and `org-odt-convert', isn't it already possible?
>
> > Indeed. <blush> Adding this
>
> > (add-to-list 'org-odt-convert-processes '("gnumeric" "ssconvert %i %o"))
> > (setq org-odt-convert-process "gnumeric")
>
> Odd thing. I put these lines in my org_init.el file byte compile and
> restart emacs but then
> (org-odt-do-reachable-formats "csv") returns
>
> Nil
>
> I have to explicitly eval the two settings
>
> (add-to-list 'org-odt-convert-processes '("gnumeric" "/usr/bin/ssconvert %i %o"))
> (setq org-odt-convert-process "gnumeric")
>
These probably need to be done after loading ox-odt. But the first one should give
an error if org-odt-convert-processes is not defined: are you getting an error at
initialization? Check *Messages*.
>
> What do I miss? I could use customize of course, but I would like to
> understand the problem.
>
--
Nick
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: org-table export to ods/xlsx etc
2017-06-16 15:25 ` org-table export to ods/xlsx etc 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; 11+ 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] 11+ 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; 11+ 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] 11+ messages in thread
* org-table export to ods/xlsx etc
@ 2017-06-16 10:25 Uwe Brauer
0 siblings, 0 replies; 11+ 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] 11+ messages in thread
end of thread, other threads:[~2017-06-26 15:55 UTC | newest]
Thread overview: 11+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
[not found] <eca7bd11a4eb4d3bbb600d77484d4449@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
2017-06-16 15:25 ` org-table export to ods/xlsx etc 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-26 15:27 ` [setting is not read] (was: org-table export to ods/xlsx etc) Uwe Brauer
2017-06-26 15:53 ` [setting is not read] Nick Dokos
2017-06-17 16:38 ` org-table export to ods/xlsx etc Uwe Brauer
[not found] <mailman.87.1497628817.13493.emacs-orgmode@gnu.org>
2017-06-17 1:41 ` edgar
2017-06-16 10:25 Uwe Brauer
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).