Is there other ways of convert mysql data into excel file or a better and easy way?
These are the methods that I know of:
1. using phpExcel (a php converter program)
2. using mysql OUTFILE command and dump the data into .xls file
I am trying to create an excel file from the data store inside mysql. The excel file has to be version 4.0 or below or else the other program will not recognize the file format.
Is there a mysql2excel command that I can use in linux which can get the job done? (concept is from dbf2mysql) If not is there a similar program that can perform the function of converting mysql data into excel?