1

Windows 10, Emacs 26.1

I has org mode table. Is it possible to convert it to MS Excel?

Thanks.

1

I have two suggestions, depending on your system and requirements. Assuming you have cygwin installed then (1) should be possible - otherwise, try (2).

(1) Use ssconvert. This is a linux command line utility to convert spreadsheet files between various spreadsheet file formats. It is a companion utility to Gnumeric. Add something like this to you emacs init:

    (add-to-list 'org-odt-convert-processes
               '("gnumeric" "/usr/bin/ssconvert %i %o"))

You should then be able to convert to ms-excel.

  1. Use this defun:

    (defun org-table-export-to-spreadsheet (arg)
     "Export org table to spreadsheet formats, e.g. `ods', `xls', `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)))
    

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.