无法在 CodeIgniter 中上传文件 xls 和 csv

Question

每次上传xls和csv格式的文件时，我都会收到错误"upload_invalid_filetype"。它适用于带有xlsx，docx和pdf的文件。我知道这与Mimes有关.php。我尝试了我在互联网上找到的所有东西来让它工作，但仍然没有运气。在这里，我放了哑剧内容，所以也许你可以找到我错过的内容。

'csv'   =>  array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel','application/zip'),
'xls'   =>  array('application/vnd.openxmlformats-officedocument.wordprocessingml.document','application/excel', 'application/vnd.ms-excel', 'application/msexcel','application/zip'),

Answer 1

如果你的xls和csv是问题所在，那么在mime.php中尝试这个

'xls'   =>  array('application/vnd.ms-excel', 'application/msexcel', 'application/x-msexcel', 'application/x-ms-excel', 'application/x-excel', 'application/x-dos_ms_excel', 'application/xls', 'application/x-xls', 'application/excel', 'application/download', 'application/vnd.ms-office', 'application/msword'),
'csv'   =>  array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'text/plain'),

同样在上传时尝试这个

$randomString = substr(str_shuffle(str_repeat($x = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', ceil(10 / strlen($x)))), 1, 10);
$config['upload_path'] = $YOUR_PATH;
$config['file_name'] = $randomString;
$config['allowed_types'] = 'csv|CSV|xls|XLS';
$config['overwrite'] = 0;
$config['max_size'] = 2048;
$this->load->library('upload', $config);
$this->upload->initialize($config); // Make sure it has been initialized

还尝试在构造中加载库，或在上传部分之后立即加载库

$this->load->library('excel');

这只会上传XLS和CSV文件，您必须在上传后阅读该文件，您必须遵循Excel库的文档