php_novice2007 Posted August 14, 2007 Share Posted August 14, 2007 Hi, Is it possible to write PHP code to convert a MYSQL table into an excel file and store it on the server so that the user can download it? If so how?? Basically do the export command.. Thanks! Link to comment https://forums.phpfreaks.com/topic/64776-solved-making-an-excel-file/ Share on other sites More sharing options...
hitman6003 Posted August 14, 2007 Share Posted August 14, 2007 Use mysql's "SELECT ... INTO outfile" command to create a CSV http://dev.mysql.com/doc/refman/4.1/en/select.html#id3180150 Link to comment https://forums.phpfreaks.com/topic/64776-solved-making-an-excel-file/#findComment-323141 Share on other sites More sharing options...
php_novice2007 Posted August 14, 2007 Author Share Posted August 14, 2007 thanks! Link to comment https://forums.phpfreaks.com/topic/64776-solved-making-an-excel-file/#findComment-323181 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.