Unable to import xlsx file in Codeigniter

问题:

after all the configuration if I am trying to import csv or xls file I am easily being able to do that but, the moment I am trying to import xlsx file gettig an error 'The filetype you are attempting to upload is not allowed'. In the file mimes.php

'xlsx'  =>  array('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/zip'),

getting error as 'The filetype you are attempting to upload is not allowed'. Any suggestion will be appreciated thnx.

回答1:

Please try with following

On upload function use

$config['allowed_types'] = '*'; //All Files

If it is working then Please check with $_FILES for what mime type your browser read for .xlsx file

Your can also check with another excel import (If all above solution is not working) http://phpexcel.codeplex.com/

回答2:

I think you also need to convert your file xlsx to xls or maybe you can save as it xls, and it will work sure.

its working for me after save as xls.