phpExcel常用方法详解

男娘i 2022-05-30 01:09 195阅读 0赞

操作excel

1.header

PHP

2.PHPExcel

http://www.codeplex.com/PHPExcel  
http://www.phpexcel.net

开发包Tests目录有详细使用实例  
支持中文,注意文件编码,文件保存为utf-8

写excel

PHP

<table style="margin-left:0px;font-size:12px;margin-top:0px;margin-right:0px;margin-bottom:0px;padding:0px;width:auto;border:none;background:none;border-spacing:0px;table-layout:auto;"> 
 <tbody> 
  <tr style="background:0px center;padding:0px;border-style:none;vertical-align:top;margin:0px;"> 
   <td style="border-width:0px;font-family:Monaco, MonacoRegular, 'Courier New', monospace;padding:0px;vertical-align:top;margin:0px;background:rgb(223,239,255);color:rgb(84,153,222);"> 
    <div style="background:0px center;border:0px;padding:0px;margin:0px;white-space:nowrap;font-size:12px;line-height:15px;"> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       1 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       2 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       3 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       4 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       5 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       6 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       7 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       8 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       9 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       10 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       11 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       12 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       13 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       14 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       15 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       16 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       17 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       18 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       19 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       20 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       21 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       22 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       23 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       24 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       25 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       26 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       27 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       28 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       29 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       30 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       31 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       32 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       33 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       34 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       35 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       36 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       37 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       38 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       39 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       40 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       41 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       42 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       43 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       44 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       45 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       46 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       47 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       48 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       49 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       50 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       51 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       52 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       53 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       54 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       55 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       56 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       57 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       58 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       59 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       60 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       61 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       62 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       63 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       64 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       65 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       66 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       67 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       68 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       69 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       70 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       71 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       72 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       73 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       74 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       75 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       76 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       77 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       78 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       79 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       80 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       81 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       82 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       83 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       84 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       85 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       86 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       87 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       88 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       89 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       90 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       91 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       92 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       93 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       94 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       95 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       96 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       97 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       98 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       99 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       100 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       101 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       102 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       103 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       104 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       105 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       106 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       107 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       108 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       109 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       110 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       111 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       112 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       113 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       114 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       115 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       116 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       117 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       118 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       119 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       120 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       121 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       122 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       123 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       124 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       125 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       126 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       127 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       128 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       129 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       130 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       131 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       132 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       133 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       134 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       135 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       136 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       137 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       138 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       139 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       140 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       141 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       142 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       143 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       144 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       145 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       146 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       147 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       148 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       149 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       150 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       151 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       152 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       153 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       154 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       155 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       156 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       157 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       158 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       159 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       160 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       161 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       162 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       163 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       164 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       165 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       166 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       167 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       168 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       169 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       170 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       171 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       172 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       173 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       174 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       175 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       176 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       177 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       178 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       179 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       180 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       181 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       182 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       183 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       184 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       185 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       186 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       187 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       188 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       189 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       190 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       191 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       192 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       193 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       194 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       195 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       196 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       197 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       198 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       199 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       200 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       201 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       202 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       203 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       204 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       205 
     </div> 
     <div style="font-family:inherit;background:rgb(200,225,250);border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;color:rgb(49,124,197);">
       206 
     </div> 
    </div></td> 
   <td style="border-width:0px;background:0px center;width:1131px;font-family:Monaco, MonacoRegular, 'Courier New', monospace;padding:0px;vertical-align:top;margin:0px;"> 
    <div style="padding:0px;margin:0px;color:rgb(0,0,0);white-space:pre;background:none;border:none;font-size:12px;line-height:15px;"> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Include class</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">require_once</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Classes/PHPExcel.php'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">require_once</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Classes/PHPExcel/Writer/Excel2007.php'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">new</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set properties 设置文件属性</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCreator</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"Maarten Balliauw"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setLastModifiedBy</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"Maarten Balliauw"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setTitle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"Office 2007 XLSX Test Document"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setSubject</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"Office 2007 XLSX Test Document"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setDescription</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"Test document for Office 2007 XLSX, generated using PHP classes."</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setKeywords</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"office 2007 openxml php"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCategory</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"Test result file"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Add some data 添加数据</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setActiveSheetIndex</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">0</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Hello'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//可以指定位置</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A2'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A3'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">false</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B2'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'world!'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B3'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">2</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'C1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Hello'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D2'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'world!'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//循环</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">for</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$i</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$i</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">&lt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">200</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$i</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">++</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">{ </span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">.</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$i</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$i</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">.</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$i</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Test value'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">}</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//日期格式化</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">time</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getNumberFormat</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setFormatCode</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_NumberFormat::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">FORMAT_DATE_YYYYMMDDSLASH</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Add comment 添加注释</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getComment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E11'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setAuthor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'PHPExcel'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objCommentRichText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getComment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E11'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createTextRun</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'PHPExcel:'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objCommentRichText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBold</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getComment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E11'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createTextRun</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"\r\n"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getComment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E11'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createTextRun</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Total amount on the current invoice, excluding VAT.'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Add rich-text string 添加文字 可设置样式</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objRichText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">new</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_RichText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getCell</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A18'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objRichText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'This invoice is '</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPayable</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objRichText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createTextRun</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'payable within thirty days after the end of the month'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPayable</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBold</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPayable</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setItalic</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPayable</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">new</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Color</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> \</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Color::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">COLOR_DARKGREEN</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objRichText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">', unless specified otherwise on the invoice.'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Merge cells 合并分离单元格</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">mergeCells</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A18:E22'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">unmergeCells</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A18:E22'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Protect cells 保护单元格</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProtection</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Needs to be set to true in order to enable any worksheet protection!</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">protectCells</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A3:E13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'PHPExcel'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set cell number formats 数字格式化</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E4'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getNumberFormat</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setFormatCode</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_NumberFormat::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">FORMAT_CURRENCY_EUR_SIMPLE</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">duplicateStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E4'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E5:E13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set column widths 设置列宽度</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColumnDimension</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setAutoSize</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColumnDimension</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setWidth</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">12</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set fonts 设置字体</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setName</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Candara'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setSize</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">20</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBold</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setUnderline</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Font::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">UNDERLINE_SINGLE</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setARGB</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Color::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">COLOR_WHITE</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set alignments 设置对齐</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D11'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getAlignment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setHorizontal</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Alignment::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">HORIZONTAL_RIGHT</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A18'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getAlignment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setHorizontal</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Alignment::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">HORIZONTAL_JUSTIFY</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A18'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getAlignment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setVertical</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Alignment::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">VERTICAL_CENTER</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A3'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getAlignment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setWrapText</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set column borders 设置列边框</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A4'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getTop</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBorderStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Border::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">BORDER_THIN</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A10'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getLeft</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBorderStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Border::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">BORDER_THIN</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E10'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getRight</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBorderStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Border::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">BORDER_THIN</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getLeft</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBorderStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Border::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">BORDER_THICK</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBottom</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBorderStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Border::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">BORDER_THICK</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set border colors 设置边框颜色</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getLeft</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setARGB</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'FF993300'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getTop</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setARGB</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'FF993300'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBottom</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setARGB</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'FF993300'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E13'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getBorders</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getRight</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setARGB</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'FF993300'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set fills 设置填充</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFill</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setFillType</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Fill::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">FILL_SOLID</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A1'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFill</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStartColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setARGB</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'FF808080'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Add a hyperlink to the sheet 添加链接</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCellValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E26'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'www.phpexcel.net'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getCell</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E26'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getHyperlink</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setUrl</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'http://www.phpexcel.net'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getCell</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E26'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getHyperlink</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setTooltip</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Navigate to website'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E26'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getAlignment</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setHorizontal</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Alignment::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">HORIZONTAL_RIGHT</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Add a drawing to the worksheet 添加图片</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">new</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Worksheet_Drawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setName</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Logo'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setDescription</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Logo'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setPath</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'./images/officelogo.jpg'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setHeight</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">36</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCoordinates</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B15'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setOffsetX</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">110</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setRotation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">25</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getShadow</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setVisible</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getShadow</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setDirection</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">45</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objDrawing</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setWorksheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Play around with inserting and removing rows and columns</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">insertNewRowBefore</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">6</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">10</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">removeRow</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">6</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">10</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">insertNewColumnBefore</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">5</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">removeColumn</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">5</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Add conditional formatting</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objConditional1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">new</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Conditional</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objConditional1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setConditionType</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Conditional::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">CONDITION_CELLIS</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objConditional1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setOperatorType</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Conditional::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">OPERATOR_LESSTHAN</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objConditional1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCondition</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'0'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objConditional1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColor</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setARGB</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Style_Color::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">COLOR_RED</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objConditional1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getFont</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setBold</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set autofilter 自动过滤</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setAutoFilter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A1:C9'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Hide "Phone" and "fax" column 隐藏列</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColumnDimension</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'C'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setVisible</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">false</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColumnDimension</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'D'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setVisible</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">false</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set document security 设置文档安全</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getSecurity</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setLockWindows</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getSecurity</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setLockStructure</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getSecurity</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setWorkbookPassword</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"PHPExcel"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set sheet security 设置工作表安全</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProtection</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setPassword</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'PHPExcel'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProtection</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">// This should be enabled in order to enable any of the following!</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProtection</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setSort</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProtection</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setInsertRows</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProtection</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setFormatCells</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Calculated data 计算</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">echo</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Value of B14 [=COUNT(B2:B12)]: '</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">.</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getCell</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B14'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getCalculatedValue</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">.</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">"\r\n"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set outline levels</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColumnDimension</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setOutlineLevel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColumnDimension</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setVisible</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">false</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getColumnDimension</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'E'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setCollapsed</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Freeze panes</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">freezePane</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'A2'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Rows to repeat at top</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getPageSetup</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setRowsToRepeatAtTopByStartAndEnd</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set data validation 验证输入值</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getCell</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B3'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getDataValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setType</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> \</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Cell_DataValidation::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">TYPE_WHOLE</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setErrorStyle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> \</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Cell_DataValidation::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">STYLE_STOP</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setAllowBlank</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setShowInputMessage</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setShowErrorMessage</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">true</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setErrorTitle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Input error'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setError</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Number is not allowed!'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setPromptTitle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Allowed input'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setPrompt</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Only numbers between 10 and 20 are allowed.'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setFormula1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">10</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setFormula2</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">20</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getCell</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'B3'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setDataValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objValidation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Create a new worksheet, after the default sheet 创建新的工作标签</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setActiveSheetIndex</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set header and footer. When no different headers for odd/even are used, odd header is assumed. 页眉页脚</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getHeaderFooter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setOddHeader</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'&amp;C&amp;HPlease treat this document as confidential!'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getHeaderFooter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setOddFooter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'&amp;L&amp;B'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">.</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getProperties</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getTitle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">.</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'&amp;RPage &amp;P of &amp;N'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set page orientation and size 方向大小</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getPageSetup</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setOrientation</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Worksheet_PageSetup::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">ORIENTATION_LANDSCAPE</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getPageSetup</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setPaperSize</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(\</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Worksheet_PageSetup::</span> 
      <span style="font-family:inherit;height:inherit;">PAPERSIZE_A4</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Rename sheet 重命名工作表标签</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">getActiveSheet</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setTitle</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Simple'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Set active sheet index to the first sheet, so Excel opens this as the first sheet</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">setActiveSheetIndex</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(206,0,0);">0</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Save Excel 2007 file 保存</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objWriter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">new</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Writer_Excel2007</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objWriter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">save</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">str_replace</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'.php'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'.xlsx'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">__FILE__</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//Save Excel 5 file 保存</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">require_once</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Classes/PHPExcel/Writer/Excel5.php'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objWriter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">new</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_Writer_Excel5</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objWriter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">save</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">str_replace</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'.php'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'.xls'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">__FILE__</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);">
       &nbsp; 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,128,0);">//1.6.2新版保存</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">require_once</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Classes/PHPExcel/IOFactory.php'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objWriter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">=</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">PHPExcel_IOFactory::</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">createWriter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objPHPExcel</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'Excel2007'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
     <div style="font-family:inherit;border:0px;padding:0px 5px;margin:0px;height:inherit;background:rgb(247,247,247);"> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,45,122);">$objWriter</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);">-&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">save</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,78,208);">str_replace</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'.php'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,128,0);">'.xls'</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(128,0,128);">__FILE__</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(51,51,51);">;</span> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

读excel

PHP

读写csv

PHP

写html

PHP

写pdf

PHP