emacs-orgmode
[Top][All Lists]
Advanced

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

Re: import xls(x) into org on MacOS


From: Greg Minshall
Subject: Re: import xls(x) into org on MacOS
Date: Tue, 01 Jun 2021 10:05:04 +0300

Uwe,

i don't know if it will work for you, but on my linux box i use
=ssconvert= from the =gnumeric= package to convert from .xls to .csv.
in one project, the make rule looks like
----
${BDIRCSVS}/%.csv: xlsxs/%.xlsx
        ssconvert -T Gnumeric_stf:stf_csv $< fd://1 | \
                awk '{ \
                                line = line $$0; \
                                ol = line; \
                                gsub("[^\"]", "", ol); \
                                if (length(ol)%2==0) { \
                                        print line; \
                                        line = "" \
                                } \
                        }' | \
                grep '^,' | \
                grep -v '^,,*$$' > $@
----
(i could probably puzzle out why the awk and greps, but i don't recall
at the moment.)

cheers, Greg



reply via email to

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