Re: import xls(x) into org on MacOS

[Greg Minshall <minshall@umich.edu>]

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