Heim > php教程 > php手册 > PhpExcel中文帮助手册|thinkphp适用3.1.2

PhpExcel中文帮助手册|thinkphp适用3.1.2

WBOY
Freigeben: 2016-06-07 11:35:32
Original
1187 Leute haben es durchsucht

kevin
我写这些主要是为了以后有个记忆,也为了新手可以作为参考。如有哪里不对,请大家指出我好改正。

第一:你要去PHPExcel官网下载,然后放到网站的Vendor文件夹下面。当然这是为了好管理和导入。你放在其他位置也没有关系。
PhpExcel中文帮助手册|thinkphp适用3.1.2

第二:当然是在你需要的地方写代码。我只写样例,你看懂了就可以灵活的使用。          vendor("PHPExcel.PHPExcel");//如果这里提示类不存在,肯定是你文件夹名字不对。<br>           $objPHPExcel = new \PHPExcel();//这里要注意‘\’ 要有这个。因为版本是3.1.2了。<br>           $objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);//设置保存版本格式<br> <br> //接下来就是写数据到表格里面去<br> $list =你从数据库查出来的的数据<br>  foreach ($list as $key => $value) {<br>                   $i=$key+1;//表格是从1开始的<br>                   $objPHPExcel->getActiveSheet()->setCellValue('A'.$i,  $value['name']);//这里是设置A1单元格的内容<br>                   $objPHPExcel->getActiveSheet()->setCellValue('B'.$i,  $value['id']);////这里是设置B1单元格的内容<br>                   //以此类推,可以设置C D E F G看你需要了。<br>                   <br> }<br> <br> //接下来当然是下载这个表格了,在浏览器输出就好了<br>           header("Pragma: public");<br>           header("Expires: 0");<br>           header("Cache-Control:must-revalidate, post-check=0, pre-check=0");<br>           header("Content-Type:application/force-download");<br>           header("Content-Type:application/vnd.ms-execl");<br>           header("Content-Type:application/octet-stream");<br>           header("Content-Type:application/download");;<br>           header('Content-Disposition:attachment;filename=文件名称.xls');<br>           header("Content-Transfer-Encoding:binary");<br>           $objWriter->save('文件名称.xls');<br>           $objWriter->save('php://output');<br> <br> 到这里你就已经完成了。如果有哪里不懂可以加我QQ164418960。或者留言<br>             第三 : 上面只是完成了流程而已。但是不可能这样简单而已。我们可以设置很多东西。看自己需要来设置了。设置excel的属性:<br> 创建人<br> $objPHPExcel->getProperties()->setCreator("Maarten Balliauw");<br> 最后修改人<br> $objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");<br> 标题<br> $objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");<br> 题目<br> $objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");<br> 描述<br> $objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");<br> 关键字<br> $objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");<br> 种类<br> $objPHPExcel->getProperties()->setCategory("Test result file");设置当前的sheet<br> $objPHPExcel->setActiveSheetIndex(0);<br> 设置sheet的name<br> $objPHPExcel->getActiveSheet()->setTitle('Simple');<br> 设置单元格的值<br> $objPHPExcel->getActiveSheet()->setCellValue('A1', 'String');<br> $objPHPExcel->getActiveSheet()->setCellValue('A2', 12);<br> $objPHPExcel->getActiveSheet()->setCellValue('A3', true);<br> $objPHPExcel->getActiveSheet()->setCellValue('C5', '=SUM(C2:C4)');<br> $objPHPExcel->getActiveSheet()->setCellValue('B8', '=MIN(B2:C5)');<br> 合并单元格<br> $objPHPExcel->getActiveSheet()->mergeCells('A18:E22');<br> 分离单元格<br> $objPHPExcel->getActiveSheet()->unmergeCells('A28:B28');<br> <br> 保护cell<br> $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true); // Needs to be set to true in order to enable any worksheet protection!<br> $objPHPExcel->getActiveSheet()->protectCells('A3:E13', 'PHPExcel');<br> 设置格式<br> // Set cell number formats<br> echo date('H:i:s') . " Set cell number formats\n";<br> $objPHPExcel->getActiveSheet()->getStyle('E4')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE);<br> $objPHPExcel->getActiveSheet()->duplicateStyle( $objPHPExcel->getActiveSheet()->getStyle('E4'), 'E5:E13' );<br> 设置宽width<br> // Set column widths<br> $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);<br> $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);<br> 设置font<br> $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Candara');<br> $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(20);<br> $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);<br> $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);<br> $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);<br> $objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);<br> $objPHPExcel->getActiveSheet()->getStyle('D13')->getFont()->setBold(true);<br> $objPHPExcel->getActiveSheet()->getStyle('E13')->getFont()->setBold(true);<br> 设置align<br> $objPHPExcel->getActiveSheet()->getStyle('D11')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);<br> $objPHPExcel->getActiveSheet()->getStyle('D12')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);<br> $objPHPExcel->getActiveSheet()->getStyle('D13')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);<br> $objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);<br> //垂直居中<br> $objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);<br> 设置column的border<br> $objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);<br> $objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);<br> $objPHPExcel->getActiveSheet()->getStyle('C4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);<br> $objPHPExcel->getActiveSheet()->getStyle('D4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);<br> $objPHPExcel->getActiveSheet()->getStyle('E4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);<br> 设置border的color<br> $objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getLeft()->getColor()->setARGB('FF993300');<br> $objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getTop()->getColor()->setARGB('FF993300');<br> $objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getBottom()->getColor()->setARGB('FF993300');<br> $objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getTop()->getColor()->setARGB('FF993300');<br> $objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getBottom()->getColor()->setARGB('FF993300');<br> $objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getRight()->getColor()->setARGB('FF993300');<br> 设置填充颜色<br> $objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);<br> $objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->setARGB('FF808080');<br> $objPHPExcel->getActiveSheet()->getStyle('B1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);<br> $objPHPExcel->getActiveSheet()->getStyle('B1')->getFill()->getStartColor()->setARGB('FF808080');<br> 加图片<br> $objDrawing = new PHPExcel_Worksheet_Drawing();<br> $objDrawing->setName('Logo');<br> $objDrawing->setDescription('Logo');<br> $objDrawing->setPath('./images/officelogo.jpg');<br> $objDrawing->setHeight(36);<br> $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());<br> $objDrawing = new PHPExcel_Worksheet_Drawing();<br> $objDrawing->setName('Paid');<br> $objDrawing->setDescription('Paid');<br> $objDrawing->setPath('./images/paid.png');<br> $objDrawing->setCoordinates('B15');<br> $objDrawing->setOffsetX(110);<br> $objDrawing->setRotation(25);<br> $objDrawing->getShadow()->setVisible(true);<br> $objDrawing->getShadow()->setDirection(45);<br> $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());<br> //处理中文输出问题<br> 需要将字符串转化为UTF-8编码,才能正常输出,否则中文字符将输出为空白,如下处理:<br>  $str  = iconv('gb2312', 'utf-8', $str);<br> 或者你可以写一个函数专门处理中文字符串:<br> function convertUTF8($str)<br> {<br>    if(empty($str)) return '';<br>    return  iconv('gb2312', 'utf-8', $str);<br> }

AD:真正免费,域名+虚机+企业邮箱=0元

Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Empfehlungen
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage