xlsx php new spreadsheet code example
Example 1: export html table data to excel in php
Use a PHP Excel for generatingExcel file. You can find a good one called PHPExcel here: https://github.com/PHPOffice/PHPExcel
And for PDF generation use http://princexml.com/
Example 2: php read excel file
I use PHP-ExcelReader to read xls files, and works great.