<?php

 /**

  *

  * @copyright 2007-2012 Xiaoqiang.

  * @author Xiaoqiang.Wu <jamblues@gmail.com>

  * @version 1.01

  */

 error_reporting(E_ALL);

 date_default_timezone_set('Asia/ShangHai');

 /** PHPExcel_IOFactory */

 require_once 'Classes/PHPExcel/IOFactory.php';

 // Check prerequisites

 if (!file_exists("report.xls")) {

     exit("not found report.xls.\n");

 }

 $reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿)

 $PHPExcel = $reader->load("report.xls"); // 载入excel文件

 $sheet = $PHPExcel->getSheet(); // 读取第一個工作表

 $highestRow = $sheet->getHighestRow(); // 取得总行数

 $highestColumm = $sheet->getHighestColumn(); // 取得总列数

 /** 循环读取每个单元格的数据 */

 for ($row = ; $row <= $highestRow; $row++){//行数是以第1行开始

     for ($column = 'A'; $column <= $highestColumm; $column++) {//列数是以A列开始

         $dataset[] = $sheet->getCell($column.$row)->getValue();

         echo $column.$row.":".$sheet->getCell($column.$row)->getValue()."<br />";

     }

 }

 ?>

 <?php

   //向xls文件写入内容

   error_reporting(E_ALL);

   ini_set('display_errors', TRUE);

   include 'Classes/PHPExcel.php';

   include 'Classes/PHPExcel/IOFactory.php';

   //$data:xls文件内容正文

   //$title:xls文件内容标题

   //$filename:导出的文件名

   //$data和$title必须为utf-8码，否则会写入FALSE值

   function write_xls($data=array(), $title=array(), $filename='report'){

     $objPHPExcel = new PHPExcel();

     //设置文档属性，设置中文会产生乱码，需要转换成utf-8格式！！

     // $objPHPExcel->getProperties()->setCreator("云舒")

                // ->setLastModifiedBy("云舒")

                // ->setTitle("产品URL导出")

                // ->setSubject("产品URL导出")

                // ->setDescription("产品URL导出")

                // ->setKeywords("产品URL导出");

     $objPHPExcel->setActiveSheetIndex();

     $cols = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';

     //设置www.jb51.net标题

     for($i=,$length=count($title); $i<$length; $i++) {

       //echo $cols{$i}.'1';

       $objPHPExcel->getActiveSheet()->setCellValue($cols{$i}.'', $title[$i]);

     }

     //设置标题样式

     $titleCount = count($title);

     $r = $cols{}.'';

     $c = $cols{$titleCount}.'';

     $objPHPExcel->getActiveSheet()->getStyle("$r:$c")->applyFromArray(

       array(

         'font'  => array(

           'bold'   => true

         ),

         'alignment' => array(

           'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT,

         ),

         'borders' => array(

           'top'   => array(

             'style' => PHPExcel_Style_Border::BORDER_THIN

           )

         ),

         'fill' => array(

           'type'    => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR,

           'rotation'  => ,

           'startcolor' => array(

             'argb' => 'FFA0A0A0'

           ),

           'endcolor'  => array(

             'argb' => 'FFFFFFFF'

           )

         )

       )

     );

     $i = ;

     foreach($data as $d) { //这里用foreach,支持关联数组和数字索引数组

       $j = ;

       foreach($d as $v) {  //这里用foreach,支持关联数组和数字索引数组

         $objPHPExcel->getActiveSheet()->setCellValue($cols{$j}.($i+), $v);

         $j++;

       }

         $i++;

     }

     // 生成2003excel格式的xls文件

     header('Content-Type: application/vnd.ms-excel');

     header('Content-Disposition: attachment;filename="'.$filename.'.xls"');

     header('Cache-Control: max-age=0');

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

     $objWriter->save('php://output');

   }

 //传递数组的形式进行 导出excel文件

   $array = array(

     array(,'名称','品牌','商品名','http://www.jb51.net'),

     array(,'名称','品牌','商品名','http://www.jb51.net'),

     array(,'名称','品牌','商品名','http://www.jb51.net'),

     array(,'名称','品牌','商品名','http://www.jb51.net'),

     array(,'名称','品牌','商品名','http://www.jb51.net'),

   );

   write_xls($array,array('商品id','供应商名称','品牌','商品名','URL'),'report');

 ?>