[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