June 2017
Beginner to intermediate
368 pages
8h 31m
English
If we are wanting to output Excel, ODS, or CSV spreadsheet-based reports, the PHPExcel library is the most straightforward way to create them. The library is accessed via an internal API called PHPExcel. Let's update the Ad-hoc database queries plugin to allow the user to download Excel files as well as CSV files:

The fully implemented code is available at https://github.com/iandavidwild/moodle-report_customsql. This is a forked copy of the original Ad-hoc database query code at https://github.com/moodleou/moodle-report_customsql. The modifications described in this section are in the master branch.
When the Ad-hoc database ...
Read now
Unlock full access