org-table export to ods/xlsx etc

org-table export to ods/xlsx etc

[Uwe Brauer]

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")))

Re: org-table export to ods/xlsx etc

[Eric S Fraga]

[-- 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 --]

Re: org-table export to ods/xlsx etc

[edgar]

> 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!  

Re: Bibliograph:ref.bib vs. \printbibliograpy (WAS: Re: > Citations with org-ref in apa style)

[edgar]

Hello Lars,

I am a beginner with Emacs, so my advice may not be very good. I assume 
that you are using org-ref (I missed part of the conversation). I have 
no problems with PDF and References (well, except that I don't know how 
to set an independent headline. I know this is not clear, but I won't 
hijack your post).

> If I want HTML export with citations, I need to use
> `bibliography:ref.bib' at the end, where I want the list of
> references. However, when exporting to pdf, it works only if I have
> \printbibliography at the end. If I use bibliograph:ref.bib, I get the

In my Org file, I have this at the end:

    bibliographystyle:unsrt
    bibliography:../References.bib

  I have no #+LATEX_HEADER, but I tried this with a clean Emacs (emacs 
-Q; you may need to evaluate line by line), and it works for me:

my_file.org
=================================
#+BEGIN_SRC emacs-lisp
   (require 'package)
   (package-initialize)
   (require 'org)
   (require 'org-ref)
   (require 'ox-latex)

   (setq org-latex-pdf-process
	    '("pdflatex -interaction nonstopmode -output-directory %o %f"
	      "bibtex %b"
	      "pdflatex -interaction nonstopmode -output-directory %o %f"
	      "pdflatex -interaction nonstopmode -output-directory %o %f"))
#+END_SRC

* My first section
   According to cite:SmartGuy17, this should work!

* I want this to say "References"
   I don't need this to say References again:
   bibliographystyle:unsrt
   bibliography:References.bib
=================================

References.bib
=================================
@article{SmartGuy17,
   author =       {A. Smart and Handsome Guy},
   title =        {Enjoying Emacs and Org-mode},
   journal =      {Hacking Accounts of Freedom},
   volume =       {2},
   number =       {4},
   pages =        {1858-1894},
   year =         {2017},
}
=================================

I hope that this helps :) . Good hacking!

Org mode version 9.0.7
GNU Emacs 24.4.1
org-ref: Version 0.9.0

-------------------------------------------------

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!  

Re: How to export LaTeX amsmath align bmatrix to ODT?

[edgar]

> Check out org-format-latex-options.  I have, for the same or similar 
> scenario:
> 
> #+begin_src emacs-lisp
>   (setq org-format-latex-options
>         '(:foreground "white" :background "black" :scale 3
>                       :html-foreground "Black" :html-background 
> "Transparent"
>                       :html-scale 1.0
>                       :matchers ("begin" "$1" "$" "$$" "\\(" "\\[")))
> #+end_src

Thanks, Eric. Unfortunately, that did not work. It does change the 
background and foreground colors, but the \tensor symbol is now 
"invisible" (it is black, and the background is also black). The rest of 
the equation looks fine.

-------------------------------------------------

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!  

Re: org-table export to ods/xlsx etc

[Nicolas Goaziou]

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

Re: org-table export to ods/xlsx etc

[Eric S Fraga]

[-- 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 --]

Re: How to export LaTeX amsmath align bmatrix to ODT?

[Eric S Fraga]

[-- Attachment #1: Type: text/plain, Size: 436 bytes --]

On Saturday, 17 Jun 2017 at 02:34, edgar@openmail.cc wrote:

[...]

> Thanks, Eric. Unfortunately, that did not work. It does change the 
> background and foreground colors, but the \tensor symbol is now 
> "invisible" (it is black, and the background is also black). The rest of 
> the equation looks fine.

Strange.  Maybe post an ECM for others to experiment with?
-- 
: 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 --]

Re: org-table export to ods/xlsx etc

[Uwe Brauer]

   > 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.

Re: Bibliograph:ref.bib vs. \printbibliograpy (WAS: Re: > Citations with org-ref in apa style)

[John Kitchin]

Try this to get the heading you want. It seems to work for me.

# https://tex.stackexchange.com/questions/17445/how-can-i-change-the-references-to-reference-in-the-thebibliography-environm
# This makes the bibliography section title empty and un-numbered
#+latex: \renewcommand{\bibsection}{\subsection*{}}

* References
bibliographystyle:unsrt
bibliography:References.bib

>
> * I want this to say "References"
>    I don't need this to say References again:
>    bibliographystyle:unsrt
>    bibliography:References.bib
> =================================
>
> References.bib
> =================================
> @article{SmartGuy17,
>    author =       {A. Smart and Handsome Guy},
>    title =        {Enjoying Emacs and Org-mode},
>    journal =      {Hacking Accounts of Freedom},
>    volume =       {2},
>    number =       {4},
>    pages =        {1858-1894},
>    year =         {2017},
> }
> =================================
>
> I hope that this helps :) . Good hacking!
>
> Org mode version 9.0.7
> GNU Emacs 24.4.1
> org-ref: Version 0.9.0
>
> -------------------------------------------------
>
> 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!


--
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu

Re: org-table export to ods/xlsx etc

[Uwe Brauer]

   > 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,

Re: org-table export to ods/xlsx etc

[Eric S Fraga]

[-- 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 --]

Re: Bibliograph:ref.bib vs. \printbibliograpy (WAS: Re: > Citations with org-ref in apa style)

[edgar]

On 2017-06-18 20:38, John Kitchin wrote:
> https://tex.stackexchange.com/questions/17445/how-can-i-change-the-references-to-reference-in-the-thebibliography-environm
> # This makes the bibliography section title empty and un-numbered
> #+latex: \renewcommand{\bibsection}{\subsection*{}}
> 
> * References
> bibliographystyle:unsrt
> bibliography:References.bib
> 
Thanks, I solved it by switching to BibLaTeX, as described in M-x 
org-ref-help :)



-------------------------------------------------

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!  

Re: org-table export to ods/xlsx etc

[Uwe Brauer]

>>> "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.