Hi fellow developers!
I want to implement following action:
Admin-priviledged user uploads a spreadsheet file (with many sheets)
When page is saved, back end generates repeater items from the sheets
We can render spreadsheet data from the repeater field. Profit!
Currently I'm trying to find a way to read the uploaded spreadsheet file. ProcessWire doesn't seem to have modules suitable for my needs, but external PHP Library PhpSpreadsheet sounds like it could do the job. However, I can't even try it, because I simply don't understand how I can refer to an external library!
Folder structure:
templates
_func.php > where I want to refer to the library
libraries
PhpSpreadsheet
bunch of *.php > what I want to refer to
I have tried different things varying from their documentation to forum posts and PW API with no luck. I would prefer not to use Composer, since it seems kind of overkill for one library.
Thanks in advance and have a great day!