一:下载最新的phpexcel(目前是1.8.0) http://phpexcel.codeplex.com/releases/view/119187
解压出来放在根目录。
二:在CI控制器中直接写方法
function read_excel(){
set_include_path(get_include_path() . PATH_SEPARATOR . './phpexcel/'); //这个可能需要改 注意下面include的路径问题
//set_include_path(' http://localhost/PHPExcel/phpexcel/');
/** PHPExcel */
include 'PHPExcel.php';
/** PHPExcel_IOFactory */
include 'PHPExcel/IOFactory.php';
/** include php_excel5 */
include 'PHPExcel/Reader/Excel5.php';
$reader->setReadDataOnly(true); // Not read styles
$excel = $reader->load("uploads/yyy.xls"); //excel的路径
echo "<pre>";
$data=$excel->getActiveSheet()->toArray();
print_r($data);
}
解压出来放在根目录。
二:在CI控制器中直接写方法
function read_excel(){
set_include_path(get_include_path() . PATH_SEPARATOR . './phpexcel/'); //这个可能需要改 注意下面include的路径问题
//set_include_path(' http://localhost/PHPExcel/phpexcel/');
/** PHPExcel */
include 'PHPExcel.php';
/** PHPExcel_IOFactory */
include 'PHPExcel/IOFactory.php';
/** include php_excel5 */
include 'PHPExcel/Reader/Excel5.php';
$reader = new PHPExcel_Reader_Excel5();
//$reader = new PHPExcel_Reader_CSV(); //读取csv格式的
$reader->setReadDataOnly(true); // Not read styles
$excel = $reader->load("uploads/yyy.xls"); //excel的路径
echo "<pre>";
$data=$excel->getActiveSheet()->toArray();
print_r($data);
}