emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* import excel files into org
@ 2017-06-27 16:54 Uwe Brauer
  2017-06-28  9:47 ` Neil Jerram
  0 siblings, 1 reply; 3+ messages in thread
From: Uwe Brauer @ 2017-06-27 16:54 UTC (permalink / raw)
  To: emacs-orgmode


Hi

Maybe the following is helpful:


(defun org-table-import-xlsx-to-csv-org () 
  (interactive)
  (let* ((source-file  (file-name-sans-extension (buffer-file-name (current-buffer))))
         (xlsx-file (concat source-file ".xlsx"))
         (csv-file (concat source-file ".csv")))
    (org-odt-convert xlsx-file "csv")
    (org-table-import csv-file  nil)))


(defun org-table-import-xlsx-file-to-csv-org (file) 
  (interactive "f")
  (let* ((source-file  (file-name-sans-extension (buffer-file-name (current-buffer))))
         (xlsx-file (concat source-file ".xlsx"))
         (csv-file (concat source-file ".csv")))
    (org-odt-convert file "csv")
    (org-table-import csv-file  nil)))

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2017-06-28 16:44 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2017-06-27 16:54 import excel files into org Uwe Brauer
2017-06-28  9:47 ` Neil Jerram
2017-06-28 16:44   ` 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).