亲测没有问题,使用方法(*输出Excel之前,不可以有echo,var_dump()等,否则报错*)
1,首先引入
2,$objPHPExcel = new PHPExcel();$objPHPExcelWrite = new PHPExcel();
3,读:
$filename = "/www/htdocs/invlist.xlsx";
$objReader = PHPExcel_IOFactory::createReaderForFile($filename);
$objPHPExcel = $objReader->load($filename);
$objPHPExcel->setActiveSheetIndex(0);
4,写
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="resinvlist.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 = new PHPExcel_Writer_Excel5($objPHPExcelWrite);
$objPHPExcelWrite->getActiveSheet()->getStyle('C')->getNumberFormat()
->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
$objPHPExcelWrite->setActiveSheetIndex(0)
->setCellValue( "A1", 'ID' )
->setCellValue( "B1", 'CustomerExID' )
->setCellValue( "C1",'InvNo');
Last:
$objWriter->save('php://output');
