emacs-orgmode
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] import excel files into org

From: Uwe Brauer
Subject: [O] import excel files into org
Date: Tue, 27 Jun 2017 16:54:14 +0000
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/26.0.50 (gnu/linux) 
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)))
reply via email to
[Prev in Thread] Current Thread [Next in Thread]