I have been using PHPExcel for some time to open Excel files (Excel5 and above) and import the data into mySQL tables.
However, as the files get larger, PHPExcel has extreme issues with memory. I've tied every conceivable caching methods that they employ and still hare having problems.
Does anyone know of any other way to do this without using PHPExcel or it's parent PEAR:Excel_Spreadsheet?
Is there a way to use OpenOffice API to convert the Excel files to CSV or tab-delimited using PHP?