Anyone have idea how to read excel file on unix platform from progress code? On windows we can use COM objects to read excel and I used same. Now my application is deployed on unix and I need to read excel file for same. I have little idea about way in which we can read it on UNIX,
you could use openoffice/libreoffice to convert an excel to a csv file -
soffice --headless --convert-to csv $filename --outdir $outdir
i am planning to add an import procedure to the docxfactory project but i've been a little busy with another side project.
you could use openoffice/libreoffice to convert an excel to a csv file -
soffice --headless --convert-to csv $filename --outdir $outdir
i am planning to add an import procedure to the docxfactory project but i've been a little busy with another side project.