I used to use PHPExcel to mangle data into XLS(x) sheets for the boss at an old job.

Finding out I may need to do a similar task now; has anyone used the (successor) PHPSpreadsheet? How steep is the learning curve, and how troublesome the installation?

    I've used Laravel Excel that implements PHPSpreadsheet and it was fairly straightforward. The only hitch I found was a php extension that wasn't installed by default on my server (sorry I can't remember what the package was, but it was simple enough to install).

      6 days later

      Thanks for that! Hadn't even heard of Laravel Excel, but I'm just back in the saddle PT after a 3+ year stint in IT Admin stuff.

      We may just be doing this with CSV; we figured out that the sheet's protected and it makes little difference to the worker who creates it whether they export a unprotected XLSX vs. a CSV since they're going to have to do two operations anyway.

      We might be able to automate the generation of the CSV, so that'd be win....

      dalecosp We might be able to automate the generation of the CSV

      fputcsv() is your friend. 😉

      NogDog

      Thanks... of course, context is important.

      I can generate CSVs all day. The question is, can the accountant do it with the data from QuickBooks using SaasAnt? (Which I think is 'yes'). After that, it's possible that WinSCP can be scripted to upload it to a webserver where PHP can do its magic. 😄

      I'd complain about it feeling clunky, but I remember spending something over a year writing (and several more maintaining) a system in PHP to do something similar*** 10 years ago....

      ***more complex though

        Write a Reply...