php excel class, introduction to how to use phpExcel_PHP tutorial

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′);

http://www.bkjia.com/PHPjc/486503.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/486503.htmlTechArticlephpExcel, it is very convenient to operate excel, especially you can easily add pictures, and supports jpg gif png format. Download address: http://www.codeplex.com/PHPExcel Here are some summarized usage methods...