XLS import works fine until you hit the 27th column.
Exporting XLS from tables longer than 26 columns works fine.
I've looked at PHPExcel but other that getting maximum column Im stuck.
This has something to do with the way columns are numbered in Excel (A-Z and then AA-AZ, ...). The 27th column is the AA column, but it isn't translated correctly to 27. The PMA function that does this doesn't seem to work for AA and higher. I'll try and fix it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Moved to bugs.
This has something to do with the way columns are numbered in Excel (A-Z and then AA-AZ, ...). The 27th column is the AA column, but it isn't translated correctly to 27. The PMA function that does this doesn't seem to work for AA and higher. I'll try and fix it.
This bug was fixed in repository and will be part of a future release; thanks for reporting.