I'm new to phpExcel. (IT'S URGENT!!!)
I used phpExcel to convert my .xlsx file to .xls (say 1) file. Then, i'm using phpExcelReader to dump it into Access/mySQL as it doesn't support .xlsx.
But, the converted .xls (say 2) file opens perfectly in Microsoft Excel 2007, but it can't be dumped in Access/mySQL.
Also, when i save the .xlsx file in .xls format using Excel, then it is dumped into Access/mySQL successfully, without any errors.
Is there an issue with encoding??? Also, the content of both .xls files are exactly same, but size differs greatly (.xls (say 1) is of 10 KB, whereas .xls (say 2) is of 26 KB!!!
Alternatively, suggest me how to read, dump data from excel file to Access/mySQL using phpExcel...