1.上官方的GitHub的地址的下载PHPExcel
2.把PHPExcel放到你的项目中去
3.项目中的开发:以ThinkPHP框架开发项目为例,PHPExcel放置于ThinkPHP / Lirbray /组织/的Util
导出:
import("Org.Util.PHPExcel"); //引入PHPExcel
$PHPExcel = new \PHPExcel(); //实例化PHPExcel
//实例化后创建了第一个sheet
$objSheet = $PHPExcel->getActiveSheet();//获取当前活动sheet
$objSheet->setTitle('food');//给当前活动sheet设置名称
$objSheet->setCellValue("A1","food_id")->setCellValue("B1","food_name");//给当前活动sheet填充数据
$objSheet->setCellValue("A2",1)->setCellValue("B2",'红烧排骨');//给当前活动sheet填充数据
$xlsxTitle = 'menu';
$fileName = 'menu';
//处理文件和网页下载
header('pragma:public');
header('Content-type:application/vnd.ms-excel;charset=utf-8;name="'.$xlsxTitle.'.xlsx"');
header("Content-Disposition:attachment;filename=$fileName.xlsx");
import("Org.Util.PHPExcel.IOFactory");
$objWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel2007');
$objWriter->save('php://output');
导入:
//引入PHPExcel文件
import("Org.Util.PHPExcel");
import("Org.Util.PHPExcel.IOFactory.php");
import("Org.Util.PHPExcel.Reader.Excel2007.php");
$filename = $file_name; //读取的Excel文件名
//实例化类,读取行和列
$objPHPExcel = \PHPExcel_IOFactory::load($filename,$encode='utf-8');
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
//根据行和列去遍历数据
for($j=2;$j<=$highestRow;$j++){
$i=0;
for($k='A';$k<=$highestColumn;$k++){
$str = (string)$objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue();//读取单元格
echo $str.'<br/>';
}
}