Question

phpexcel导入导出excel

求不要复制黏贴,,,能够在线聊更好,,,

Answer 1

下载phpexcel
require '/api/PHPExcel.php';//加载phpexcel
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getDefaultStyle()->getFont()->setName( '微软雅黑');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(14);
$objPHPExcel->getActiveSheet()->getStyle("A1:L1")->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle("A1:L1")->getFont()->setBold(TRUE);
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->getFill()->getStartColor()->setARGB('FF6FA0EC');

$ths=array('A1','B1');
$objPHPExcel->getActiveSheet()->setCellValue('A1', '用户名');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '密码');

$objPHPExcel->getActiveSheet()->getColumnDimension( 'A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension( 'B')->setWidth(12);
$size=count($passwords);
if($passwords){
for($i=0;$i<$size;$i++){
$objPHPExcel->getActiveSheet()->setCellValue("A".($i+2), $lists[$i]['username']);
$objPHPExcel->getActiveSheet()->setCellValue("B".($i+2), $lists[$i]['mima']);
}
}
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle('Excel表');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$outputFileName = "fileaname";//文件名字
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'.iconv('UTF-8','GB18030',$outputFileName).'.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header ('Pragma: public'); // HTTP/1.0
//$objWriter->save(DT_ROOT.'file/cache/');
$objWriter->save('php://output');

追问

为什么你的phpexcel路径这么神奇,,,不是在class里面的么

追答

路径是根据你放的位置未定的，可以修改的

追问

那导入怎么做,导出的我已经做了个伪的,,,凑合着先

追答

我这段代码会弹出一个保留的路径让人自己选择，就像下载一样，自己去选择保存路径，这样子很方便。

追问

额,,,这个很好,那有excel导入的码子麽,,,洒得一地泪纳