Excel export file is not readable through code -- I tried both, Export via Podio App and Export via Batch API


1 comment

  • Kars Marnink

    I have been struggling with PHPExcel as well. All other xlsx files I tried worked fine, except the Podio ones. Podio exports are either the wrong markup, or the compression used is not standard. 

    Anyway, if you're on linux you could try installing gnumeric. It has a command line conversion utility:

    sudo apt-get install gnumeric --no-install-recommends

    Or similar for other linux flavours. In your php script, after your xlsx download is finished:

    shell_exec('ssconvert exported.xlsx converted.csv');

    I used this to generate a csv-file to import into Google sheets with =importdata(). Works fine.


    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk