Home > Article > Backend Development > php excel class, introduction to how to use phpExcel_PHP tutorial
php excel class, introduction to how to use phpExcel_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:38:171011browse
phpExcel, it is very convenient to operate excel, especially you can easily add pictures, supporting jpg gif png format.
Download address: http://www.codeplex.com/PHPExcel
The following are summarized several usage methods
include ‘PHPExcel.php’;
include ‘PHPExcel/Writer/Excel2007.php’;
//Or include ‘PHPExcel/Writer/Excel5.php’;
for outputting .xls
Create an excel
$objPHPExcel = new PHPExcel();
Save excel—2007 format
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
//Or $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); non-2007 format
$objWriter->save("xxx.xlsx");
Output directly to the browser
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
header("Pragma: public");
header(”Expires: 0″);
header(”Cache-Control:must-revalidate, post-check=0, pre-check=0″);
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header(’Content-Disposition:attachment;filename=”resume.xls”‘);
header("Content-Transfer-Encoding:binary");
$objWriter->save(’php://output’);
————————————————————————————————————————
Set excel attributes:
Created by
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
Last modified by
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
Title
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
Title
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
Description
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
Keywords
$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");
Type
$objPHPExcel->getProperties()->setCategory(”Test result file”);
————————————————————————————————————————
Set the current sheet
$objPHPExcel->setActiveSheetIndex(0);
Set the name of the sheet
$objPHPExcel->getActiveSheet()->setTitle(’Simple’);
Set cell value
$objPHPExcel->getActiveSheet()->setCellValue(’A1′, ‘String’);
$objPHPExcel->getActiveSheet()->setCellValue(’A2′, 12);
$objPHPExcel->getActiveSheet()->setCellValue(’A3′, true);
$objPHPExcel->getActiveSheet()->setCellValue(’C5′, ‘=SUM(C2:C4)’);
$objPHPExcel->getActiveSheet()->setCellValue(’B8′, ‘=MIN(B2:C5)’);
Merge cells
$objPHPExcel->getActiveSheet()->mergeCells(’A18:E22′);
Separate cells
$objPHPExcel->getActiveSheet()->unmergeCells(’A28:B28′);