* 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 ` 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; 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
* 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; 9+ 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] 9+ 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; 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
* Re: org-table export to ods/xlsx etc
2017-06-17 14:54 ` Nicolas Goaziou
@ 2017-06-21 13:01 ` Uwe Brauer
[not found] ` <4e6e65e9ba354c9a8dab18796c1e92dc@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
1 sibling, 0 replies; 9+ messages in thread
From: Uwe Brauer @ 2017-06-21 13:01 UTC (permalink / raw)
To: emacs-orgmode
> Hello,
> Eric S Fraga <e.fraga@ucl.ac.uk> writes:
> According to `org-odt-convert-processes', `org-odt-convert-capabilities'
> and `org-odt-convert', isn't it already possible?
Hm I set
(add-to-list 'org-odt-convert-processes '("gnumeric" "ssconvert %i %o"))
(setq org-odt-convert-process "gnumeric")
But then my function returns
Debugger entered--Lisp error: (error "Cannot convert from csv format to xlsx format?")
signal(error ("Cannot convert from csv format to xlsx format?"))
error("Cannot convert from %s format to %s format?" "csv" "xlsx")
org-odt-do-convert("/home/oub/ALLES/tex/vorlesungen/HG/HGQuim-Num-Estad/Notas/Notas2017/Controles/Rosa/rosa4.csv" "xlsx" nil)
org-odt-convert("/home/oub/ALLES/tex/vorlesungen/HG/HGQuim-Num-Estad/Notas/Notas2017/Controles/Rosa/rosa4.csv" "xlsx")
org-export-to-xlsx()
funcall-interactively(org-export-to-xlsx)
call-interactively(org-export-to-xlsx nil nil)
command-execute(org-export-to-xlsx)
> Regards,
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: org-table export to ods/xlsx etc
[not found] ` <4e6e65e9ba354c9a8dab18796c1e92dc@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
@ 2017-06-21 13:43 ` Eric S Fraga
2017-06-22 6:57 ` Uwe Brauer
0 siblings, 1 reply; 9+ messages in thread
From: Eric S Fraga @ 2017-06-21 13:43 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 278 bytes --]
On Wednesday, 21 Jun 2017 at 13:01, Uwe Brauer wrote:
> Debugger entered--Lisp error: (error "Cannot convert from csv format
> to xlsx format?")
What does (org-odt-do-reachable-formats "csv") return?
--
: Eric S Fraga via Emacs 26.0.50, Org release_9.0.8-582-g15c9e9
[-- 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-21 13:43 ` Eric S Fraga
@ 2017-06-22 6:57 ` Uwe Brauer
0 siblings, 0 replies; 9+ messages in thread
From: Uwe Brauer @ 2017-06-22 6:57 UTC (permalink / raw)
To: emacs-orgmode
>>> "Eric" == Eric S Fraga <e.fraga@ucl.ac.uk> writes:
> On Wednesday, 21 Jun 2017 at 13:01, Uwe Brauer wrote:
>> Debugger entered--Lisp error: (error "Cannot convert from csv format
>> to xlsx format?")
> What does (org-odt-do-reachable-formats "csv") return?
Ha thanks
I had to set
(add-to-list 'org-odt-convert-processes '("gnumeric" "/usr/bin/ssconvert %i %o"))
Otherwise ssconvert was not found.
I reported the misbehavior of LO/OO concerning the coding in the
relevant list. Maybe it is a bug.
^ permalink raw reply [flat|nested] 9+ 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; 9+ 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] 9+ 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; 9+ 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] 9+ messages in thread
end of thread, other threads:[~2017-06-26 15:55 UTC | newest]
Thread overview: 9+ 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
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).