php 导入excel 方法

方法一：

function fopen_utf8($filename)
{
    $encoding = '';
    $handle = fopen($filename, 'r');
    $bom = fread($handle, 2);
    //fclose($handle);
    rewind($handle);//将文件位置指针设为文件流的开头

    if ($bom === chr(0xff) . chr(0xfe) || $bom === chr(0xfe) . chr(0xff)) {
        // UTF16 Byte Order Mark present
        $encoding = 'UTF-16';
    } else {
        $file_sample = fread($handle, 1000) + 'e'; //read first 1000 bytes
        // + e is a workaround for mb_string bug
        rewind($handle);

        $encoding = mb_detect_encoding($file_sample, 'UTF-8, UTF-7, ASCII, EUC-JP,SJIS, eucJP-win, SJIS-win, JIS, ISO-2022-JP');
    }
    if ($encoding) {
        stream_filter_append($handle, 'convert.iconv.' . $encoding . '/UTF-8');
    }
    return ($handle);
}
$unzipfile = 'test.csv';
if (($handle = fopen_utf8($unzipfile, "r")) === false){
    echo 'encoding error'.$unzipfile;die;
}
$coldata = array();
while (($cols = fgetcsv($handle, 1000, ",")) !== false) {
    //print_r($cols);die;
    $coldata[] = $cols;
}
//数组$coldata就是最后的结果

方法二：

使用phpexcel插件，度娘上有很多，不在详细介绍