Title: Exporting PHP Array to Excel File Last modified: August 20, 2016 --- # Exporting PHP Array to Excel File * Resolved [questions4wp](https://wordpress.org/support/users/questions4wordpress/) * (@questions4wordpress) * [13 years, 11 months ago](https://wordpress.org/support/topic/exporting-php-array-to-excel-file/) * On a page that I generate within WordPress, I have a MySQL query that populates an array, which is then displayed in a table within the page. I would like to add a “download to Excel” button underneath this table. What I’ve found so far is some easy code in PHP to convert an array to Excel, found [ here](http://www.lateralcode.com/excel-spreadsheets-php/). I have tested this code in a new file I named test.php, and it works fine. * However, when I try to use this within WordPress (using the exec-php plugin), instead of providing the file for download (like using a straight .php file does), it instead prints the data within the generated XML tags directly to the screen. * Does anyone have any experience with this particular script/any advice on what to modify to get a download from WordPress like I do from a .php file? Or alternatively, an easy way to output data to an Excel file from an array? Viewing 4 replies - 1 through 4 (of 4 total) * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [13 years, 11 months ago](https://wordpress.org/support/topic/exporting-php-array-to-excel-file/#post-2820871) * What that code actually does is create a “tab separated values” file (a CVS, with tabs) and lie about the file type, which causes Excel to open it. It isn’t really an .xls until Excel imports it into a spreadsheet. That is why you get the message about the file format not matching. It probably works fine, unless your data has tabs in it. * I don’t think you are going to get this to work using exec-php though. You need to send http headers at the beginning of the transmission and exec-php operates in the post body, long after the headers have been sent. * Thread Starter [questions4wp](https://wordpress.org/support/users/questions4wordpress/) * (@questions4wordpress) * [13 years, 11 months ago](https://wordpress.org/support/topic/exporting-php-array-to-excel-file/#post-2820916) * Hmm, interesting, so this code doesn’t seem like it’ll work out. Can you point me to some other code that will let me generate an excel file without this header trick? * Thread Starter [questions4wp](https://wordpress.org/support/users/questions4wordpress/) * (@questions4wordpress) * [13 years, 11 months ago](https://wordpress.org/support/topic/exporting-php-array-to-excel-file/#post-2820920) * I seem to have solved my own issue…somewhat. * It appears that there are two ‘hacks’ going on in these PHP->Excel scripts. The first is as you described, changing the header so that the browser thinks it’s downloading an Excel file instead of an HTML file or something like that. The second hack is that the file that’s generated is not, in fact, an Excel file, but instead a .csv (again, as you described) which Excel will open, albeit with that message. * To solve the first issue, I just have WordPress call a different .php, so that the headers will be sent again. In other words, instead of copying the contents of test.php into WordPress, I have a link in the WordPress page to test.php. Clicking on that link launches a download of the Excel file. I can now modify test.php to use my real data instead of the test data. The second issue of the pop up message about the incorrect format remains, although I’ve just added a line on my site that says “Note: you will receive a message saying that this file may not be in the correct format, simply click ‘OK'”. * Through my research, I’ve found that the ‘correct’ way to generate an Excel file is through a [COM add-in](http://support.microsoft.com/kb/291392). It requires Excel to be installed on the server, however. There is an [OpenOffice alternative](http://www.wstech2.net/index.php?do=0a,01,05) called PUNO, which requires Java. Both of these options would seemingly solve both issues, as neither one is a header/filetype hack, but I haven’t messed with either. * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [13 years, 11 months ago](https://wordpress.org/support/topic/exporting-php-array-to-excel-file/#post-2820936) * > Through my research, I’ve found that the ‘correct’ way to generate an Excel > file is through a COM add-in. It requires Excel to be installed on the server… * I’d argue that that is not the ‘correct’ way to do it. You are vendor-locking your code. There are PHP libraries that will create proper .xls or .ods files. I’ve been using a rather old on called ExcelExport but I need to move to .ods since that is what the office uses now. (Yay! Me!) Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Exporting PHP Array to Excel File’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 4 replies * 2 participants * Last reply from: [s_ha_dum](https://wordpress.org/support/users/apljdi/) * Last activity: [13 years, 11 months ago](https://wordpress.org/support/topic/exporting-php-array-to-excel-file/#post-2820936) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics