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