Does anyone know how can i read excel files with php. At my job there is this huge xls database, that will be soon need to be converted to mysql. But i do not want to copy it word by word, so i thaught that with a little help from php it could be done automaticaly.
thnks
Google is your friend. You might also want to try checking PEAR. Another option is to export the Excel as CSV which you could then read into an array with less than 10 lines of PHP.
so no matter how is huge the db if i export it as cvs it should work?
You might have to change the max execution time, but yes, it should work. If you want you can split it into a few CVSs, that wouldn’t hurt either.
