PHP 读取EXCEL

PHPExcel 自己下载。

PHP读取EXCEL

public function import_Excel($file_name){
include_once LIB_ROOT_PATH."3rdParty/phpexcel/PHPExcel.php";
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load($file_name,$encode='utf-8');
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();//取得总行数
$highestColumn = $sheet->getHighestColumn();//取得总列数
$data = array();
for($i=2;$i<=$highestRow;$i++){
for($j='A';$j<=$highestColumn;$j++){
$data[$i][] = $objPHPExcel->getActiveSheet()->getCell("$j$i")->getValue();
}
}
return $data;
}

  

PHP导出EXCEL

public function data_excel(){ include_once LIB_ROOT_PATH."3rdParty/phpexcel/PHPExcel.php";
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', '相近字')
->setCellValue('B1', '可能的字');
$i = 0;
foreach ($temp as $key => $value) {
$i++;
$objPHPExcel->getActiveSheet(0)->setCellValue('A'.($i+1), $key);
$objPHPExcel->getActiveSheet(0)->setCellValue('B'.($i+1), $value);
}
// sheet命名
$objPHPExcel->getActiveSheet()->setTitle('易错字统计');
$objPHPExcel->setActiveSheetIndex(0);
// excel头参数
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="('.date('Ymd-His').').xlsx"'); //日期为文件名后缀
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); //excel5为xls格式,excel2007为xlsx格式
$objWriter->save('php://output');
exit;
}

EXCEL转为html

include './phpexcel/PHPExcel.php';
$filename = '1.xls'; $objReader = new \PHPExcel_Reader_Excel2007(); //实例化一个读取对象 $objWriteHTML = new \PHPExcel_Writer_HTML($objReader->load($filename)); //读取excel文件,并将它实例化为PHPExcel_Writer_HTML对象 $objWriteHTML->save("php://output");
上一篇:【学习笔记】【Foundation】数组


下一篇:msp430的两本书 电子版【worldsing笔记】