php生成excel带图片格式,phpexcel导出带图片的Excel

/** Error reporting */

error_reporting(E_ALL);

ini_set('display_errors', TRUE);

ini_set('display_startup_errors', TRUE);

define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '
');

date_default_timezone_set('Europe/London');

/** Include PHPExcel */

require_once '../Classes/PHPExcel.php';

// Create new PHPExcel object

echo date('H:i:s') , " Create new PHPExcel object" , EOL;

$objPHPExcel = new PHPExcel();

// Set document properties

echo date('H:i:s') , " Set document properties" , EOL;

$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")

->setLastModifiedBy("Maarten Balliauw")

->setTitle("Office 2007 XLSX Test Document")

->setSubject("Office 2007 XLSX Test Document")

->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")

->setKeywords("office 2007 openxml php")

->setCategory("Test result file");

// Add some data, we will use printing features

echo date('H:i:s') , " Add some data" , EOL;

for ($i = 1; $i < 80; $i++) {

$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);

$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');

//导出图片start

$objDrawing = new PHPExcel_Worksheet_Drawing();

$objDrawing->setName('PHPExcel logo');

$objDrawing->setDescription('PHPExcel logo');

$objDrawing->setPath('./p_w_picpaths/phpexcel_logo.gif');

$objDrawing->setHeight(36);

$objDrawing->setCoordinates('C'. $i);

$objDrawing->setOffsetX(10);

$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

//导出图片end

}

// Set header and footer. When no different headers for odd/even are used, odd header is assumed.

echo date('H:i:s') , " Set header/footer" , EOL;

$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&G&C&HPlease treat this document as confidential!');

$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');

// Add a drawing to the header

echo date('H:i:s') , " Add a drawing to the header" , EOL;

$objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing();

$objDrawing->setName('PHPExcel logo');

$objDrawing->setPath('./p_w_picpaths/phpexcel_logo.gif');

$objDrawing->setHeight(36);

$objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_HEADER_LEFT);

// Set page orientation and size

echo date('H:i:s') , " Set page orientation and size" , EOL;

$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);

$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);

// Rename worksheet

echo date('H:i:s') , " Rename worksheet" , EOL;

$objPHPExcel->getActiveSheet()->setTitle('Printing');

// Set active sheet index to the first sheet, so Excel opens this as the first sheet

$objPHPExcel->setActiveSheetIndex(0);

// Save Excel 2007 file

echo date('H:i:s') , " Write to Excel2007 format" , EOL;

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

$objWriter->save(str_replace('.php', '.xlsx', __FILE__));

echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;

// Save Excel5 file

echo date('H:i:s') , " Write to Excel5 format" , EOL;

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save(str_replace('.php', '.xls', __FILE__));

echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;

// Echo memory peak usage

echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;

// Echo done

echo date('H:i:s') , " Done writing files" , EOL;

echo 'Files have been created in ' , getcwd() , EOL;