代码过程是,读取模板文件template.xls。写入对应内容,导出pdf文件。template.xls文件内容带有表格和日文。 个人认为是没有字体的原因,但是如何对应,望大虾告知!!!
require_once 'excel/phpexcel.php';
$objphpexcel = phpexcel_iofactory::load( template.xls );
$objphpexcel->setactivesheetindex(0);
$objworksheet = $objphpexcel->getactivesheet();
//写内容
$objworksheet->getcell(c1)->setvalue(test);
//假如图片
$objdrawing = new phpexcel_worksheet_drawing();
$objdrawing->setname('stamp');
$objdrawing->setdescription(aaaa);
$objdrawing->setpath(images/p1.jpg);
$objdrawing->setcoordinates('m1');
$objdrawing->setoffsetx(25);
$objdrawing->setrotation(36);
$objdrawing->setheight(73);
$objdrawing->getshadow()->setvisible(true);
$objdrawing->getshadow()->setdirection(45);
$objdrawing->setworksheet($objworksheet);
$objworksheet->settitle('simple');
ob_end_clean();
header('content-type: application/pdf');
header('content-disposition: attachment;filename=detail.pdf');
header('cache-control: max-age=0');
$objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'pdf');
$objwriter->save('php://output');
exit;
------解决思路----------------------
確定內容文字是utf-8编码嗎?如果不是就要用iconv轉換編碼。
------解决思路----------------------
phpexcel生成pdf有一个重大的缺陷:excel中如果有图片,生成的pdf里不会保留,所以你用这个来生成pdf文件不是最好的方案!
