Advertisement
GWibisono

phpexcel.net make excel using php part 3

May 27th, 2012
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.39 KB | None | 0 0
  1. <?php
  2. /**
  3.  * PHPExcel
  4.  *
  5.  * Copyright (C) 2006 - 2011 PHPExcel
  6.  *
  7.  * This library is free software; you can redistribute it and/or
  8.  * modify it under the terms of the GNU Lesser General Public
  9.  * License as published by the Free Software Foundation; either
  10.  * version 2.1 of the License, or (at your option) any later version.
  11.  *
  12.  * This library is distributed in the hope that it will be useful,
  13.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  15.  * Lesser General Public License for more details.
  16.  *
  17.  * You should have received a copy of the GNU Lesser General Public
  18.  * License along with this library; if not, write to the Free Software
  19.  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
  20.  *
  21.  * @category   PHPExcel
  22.  * @package    PHPExcel
  23.  * @copyright  Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
  24.  * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
  25.  * @version    1.7.6, 2011-02-27
  26.  */
  27.  
  28. error_reporting(E_ALL);
  29. require_once 'Classes/PHPExcel/IOFactory.php';
  30.  
  31.  
  32. $s='<ol>';  
  33. $objPHPExcel = PHPExcel_IOFactory::load('test2_gagal.xlsx');
  34. for($i=1;$i<12;$i++){
  35.     $s.="<li>read B$i =".
  36.     $objPHPExcel->getActiveSheet()
  37.       ->getCell('B'.$i)->getValue();
  38. }
  39.  
  40.  
  41. $s.="</ol>";
  42. print $s;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement