phpExcel 读取和导出

来源：互联网发布：龙管家网络计费系统编辑：程序博客网时间：2024/05/08 09:17

phpExcel 是一款功能强大的excel文件导出的工具。

下面介绍下导出

         set_include_path('Excel_Classes/');  //引用目录         require_once 'PHPExcel.php';          include 'PHPExcel/IOFactory.php';          $objPHPExcel = new PHPExcel();          $objPHPExcel->getActiveSheet()->getDefaultColumnDimension()->setWidth(22);          $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);          $objPHPExcel->getActiveSheet()->setCellValue('A1', '名称1');          $objPHPExcel->getActiveSheet()->setCellValue('B1', '名称2');          $objPHPExcel->getActiveSheet()->setCellValue('C1', '名称3');          $objPHPExcel->getActiveSheet()->setCellValue('D1', '名称4');          $objPHPExcel->getActiveSheet()->setCellValue('E1', '名称5');          $objPHPExcel->getActiveSheet()->setCellValue('F1', '名称6');          $objPHPExcel->getActiveSheet()->setCellValue('G1', '名称7');          $objPHPExcel->getActiveSheet()->setCellValue('H1', '名称8');          $i = 1;          foreach ($info as $k => $v) {              $i++;              $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, '值1');              $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, '值2');              $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, '值3');              $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, '值4');              $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, '值5');              $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, '值6');              $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, '值7');              $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, '值8');          }          unset($i);          $filename  = "creat-xls/product_info_export_" . date('YmdHis') . ".xlsx";          $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');          $objWriter->save($filename);          header("Location: $filename?yy=" . rand());

Excel_Classes 文件包已经上传到我的csdn的资源库了。也可以去官网下载

0 0