如何在PHPExcel库中使用打印就绪功能 [英] How to use print ready functionality in PHPExcel library
本文介绍了如何在PHPExcel库中使用打印就绪功能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用PHPExcel库进行电子表格操作.我要应用打印就绪功能.是否存在此功能?
I am using PHPExcel library for spreadsheet operations. I am to apply print ready functionality. Does this functionality exist?
推荐答案
如果您阅读设置Excel文件的打印机选项"的部分,其中有很多有关页面的信息打印设置:-
If you read the documentation, particularly the section entitled "Setting printer options for Excel files", there's a lot of information about page setup for printing:-
方向和纸张尺寸:
$objPHPExcel->getActiveSheet()
->getPageSetup()
->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
$objPHPExcel->getActiveSheet()
->getPageSetup()
->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
页边距:
$objPHPExcel->getActiveSheet()
->getPageMargins()->setTop(1);
$objPHPExcel->getActiveSheet()
->getPageMargins()->setRight(0.75);
$objPHPExcel->getActiveSheet()
->getPageMargins()->setLeft(0.75);
$objPHPExcel->getActiveSheet()
->getPageMargins()->setBottom(1);
页眉和页脚:
$objPHPExcel->getActiveSheet()
->getHeaderFooter()
->setOddHeader('&C&HPlease treat this document as confidential!');
$objPHPExcel->getActiveSheet()
->getHeaderFooter()
->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() .
打印机分页符:
$objPHPExcel->getActiveSheet()
->setBreak( 'A10' , PHPExcel_Worksheet::BREAK_ROW );
显示网格线:
$objPHPExcel->getActiveSheet()
->setShowGridlines(true);
设置行/列以在每个页面的顶部/左侧重复
$objPHPExcel->getActiveSheet()
->getPageSetup()
->setRowsToRepeatAtTopByStartAndEnd(1, 5);
设置打印区域:
$objPHPExcel->getActiveSheet()
->getPageSetup()
->setPrintArea('A1:E5,G4:M20');
我们编写文档是为了让您不必问这样的问题
We write the documentation so that you don't have to ask questions like this
这篇关于如何在PHPExcel库中使用打印就绪功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文