help-gnu-emacs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: get text from LibreOffice Calc to Emacs Org-Mode


From: Gottfried
Subject: Re: get text from LibreOffice Calc to Emacs Org-Mode
Date: Fri, 28 Apr 2023 15:57:10 +0000

Hi,

(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-processes '(("gnumeric" "~/.local/bin/xlsx2csv %i 
%o"))))
    (org-odt-convert xlsx-file "csv")
    (org-table-import csv-file  nil)))


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

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


I copied your suggestions into my init.el file

and tried to export a libreoffice calc file in xml format.

and then I opened this libreoffice calc file in emacs org-mode.
there were unreadably stuff
So may be I misunderstood you.
--
Kind regards

Gottfried

Attachment: OpenPGP_0x61FAF349C9FB7F94.asc
Description: OpenPGP public key

Attachment: OpenPGP_signature
Description: OpenPGP digital signature


reply via email to

[Prev in Thread] Current Thread [Next in Thread]