Problem with MySQL XLSX Export

The script is exactly what I have been looking for. The only problem is that it never creates the .xlsx file. When I run the script the data is loaded in to the .xml files, but never opens Excel to create the .xlsx file. Any help would be appreciated. I am using MS Office 2011.

In my last post I neglected to state that the data does not display in the browser either. I can drag and drop the newly created .xml files on to Excel on the desktop and all data is properly imported.

Hi, it's correct. May be it is a little bit confusion about that cause the description of the class and functionalities has been modified by the site owner/moderator. By the way the class creates a .xml file that you can open in excel or libre office. If you choose for output to browser, it will trigger the office package. I tested it in win 7 and xubuntu. Both were working fine.

Thanks for the quick reply. Uou state if I choose to output to browser. How do you choose this? The xml file are created correctly just no browser or Excel.

Hi, see the example below:

$xls_xml->long_query('dbase_name','SELECT * FROM table_name WHERE field_1 > 0 AND field_1 < 100 ORDER BY field_1 LIMIT 1');
$xls_xml->save_as('output_long.xml');

/*
* send the output to browser and triggers the office software. Tested with MS Office 2007 and libre office 3.6.2.2
*/
$xls_xml->to_excel('output_to_browser.xml');

Thanks again for your reply.

My problem was Excel was not the default app for .xml files.
I changed from Xcode to Excel and it is working prefectly.

Thanks and have a great day,
Frank