<?php
use PHPExcel;
use PHPExcel_IOFactory;

/**
 * @method Excel操作
 */
class LibExcel
{
	/**
    * 只支持 csv,xls,xlsx
	*/
    public static function getCsvFile($filename)
    {
		$ext = end(explode('.', $_FILES["file"]["name"]));
		$ext = strtolower($ext);
		if($ext!='csv'){
			$fileType = \PHPExcel_IOFactory::identify($filename);//获取文件类型
			$reader = \PHPExcel_IOFactory::createReader($fileType);//实列化阅读器对象
			$reader = $reader->setReadDataOnly(true);   //只读模式打开
			$excel = $reader->load($filename); //载入excel表格
			$wFileName = str_replace('.xls', '.csv', str_replace('.xlsx', '.csv', $filename));
			$writer = \PHPExcel_IOFactory::createWriter($excel, 'Csv');
			$writer->save($wFileName);
			$reader = null;
			$excel = null;
			$writer = null;
			$filename = $wFileName;
		}
		//file_get_contents($wFileName, iconv("gb2312", "utf-8//IGNORE", file_get_contents($wFileName)));
        return $filename;
    }
}