No XLS to download

  • Resolved jramed

    (@jramed)


    7 years, 4 months ago

    Hello,

    after the last update, now I can’t download a XLS file like I used to do.

    I have an URL with this at the end: “/admin-ajax.php” and nothing to download.

    It does, however, in TSV, but I do really need like it used to work before the update.

    Could you help me please ?

    Thank you.

    Best regards,
    Jra

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author algol.plus

    (@algolplus)

    hi Jra

    Do you have access to webserver logs? What error do you get ?

    Could you edit file /classes/formats/class-woe-formatter-xls.php
    Find and delete this line
    PHPExcel_Settings::setCacheStorageMethod( PHPExcel_CachedObjectStorageFactory::cache_to_sqlite3 );

    Will it help ?

    thank, Alex

    Thread Starter jramed

    (@jramed)

    Hello,

    I followed your indications and it was perfect ! Now it works as before !

    Thanks a lot !

    Jra

    Plugin Author algol.plus

    (@algolplus)

    Hello Jra

    Do you have access to webserver logs? What error do you get ?
    thanks, Alex

    Thread Starter jramed

    (@jramed)

    Hello, this is the error that I got:
    —
    [18-Jul-2017 23:26:16 UTC] PHP Fatal error: Uncaught exception ‘PHPExcel_Exception’ with message ‘No cells exist within the specified range’ in ../plugins/woo-order-export-lite/classes/PHPExcel/Worksheet/RowCellIterator.php:214
    Stack trace:
    #0 ../plugins/woo-order-export-lite/classes/PHPExcel/Worksheet/CellIterator.php(86): PHPExcel_Worksheet_RowCellIterator->adjustForExistingOnlyRange()
    #1 ../plugins/woo-order-export-lite/classes/formats/class-woe-formatter-xls.php(137): PHPExcel_Worksheet_CellIterator->setIterateOnlyExistingCells(true)
    #2 ../plugins/woo-order-export-lite/classes/class-wc-order-export-engine.php(428): WOE_Formatter_Xls->finish()
    #3 ../plugins/woo-order-export-lite/classes/class-wc-order-export-admin.php(1228): in ../plugins/woo-order-export-lite/classes/PHPExcel/Worksheet/RowCellIterator.php on line 214
    —

    Plugin Author algol.plus

    (@algolplus)

    thank you!
    I’ve updated the plugin.

    Thread Starter jramed

    (@jramed)

    That’s fantastic, thank you !

    Plugin Author algol.plus

    (@algolplus)

    you’re welcome. thank you for cooperation

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘No XLS to download’ is closed to new replies.