Exporting MySQL data to Excel format

[mistaq]

I'm new to this plugin and am somewhat lost as to how to get started. Essentially I want to get data conditional on the columns selected in a MySQL table, and export them into Excel format (either .xls or .xlsx).

For example:

If table Users has 3 columns: First Name, Last Name and Address and I only wanted the first 2 columns, only those would be exported to the Excel file.

I've looked at this particular sample, however, I'm not sure if it's the right sample to be looking at.

I'm using CakePHP 3.3.x. The PHPExcel plugin is installed under Vendor, while I have a PHP file called excelexport.php under directory: C:/xampp/htdocs/project/src/Template/Resources/excelexport.php.