[Summary view] [Print] [Text view]

   1  <?php
   2  /* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
   3  
   4  // +----------------------------------------------------------------------+
   5  // | Akelos Framework - http://www.akelos.org                             |
   6  // +----------------------------------------------------------------------+
   7  // | Copyright (c) 2002-2006, Akelos Media, S.L.  & Bermi Ferrer Martinez |
   8  // | Released under the GNU Lesser General Public License, see LICENSE.txt|
   9  // +----------------------------------------------------------------------+
  10  
  11  /**
  12   * @package ActiveSupport
  13   * @subpackage Converters
  14   * @author Bermi Ferrer <bermi a.t akelos c.om>
  15   * @copyright Copyright (c) 2002-2006, Akelos Media, S.L. http://www.akelos.org
  16   * @license GNU Lesser General Public License <http://www.gnu.org/copyleft/lesser.html>
  17   */
  18  
  19  class AkExcelToArray
  20  {
  21      function convert()
  22      {
  23          $this->handler->read($this->source_file);
  24          
  25          $result = array();
  26          for ($i = 1; $i <= $this->handler->sheets[0]['numRows']; $i++) {
  27              if($i === 1){
  28                  @$col_names = $this->handler->sheets[0]['cells'][$i-1];
  29                  foreach (range(1, $this->handler->sheets[0]['numCols']) as $column_number){
  30                      $col_names[$column_number-1] = empty($col_names[$column_number-1]) ? $column_number : trim($col_names[$column_number-1],"\t\n\r ");
  31                  }
  32                  continue;
  33              }
  34  
  35              for ($j = 0; $j < $this->handler->sheets[0]['numCols']; $j++) {
  36                  $result[$i-2][$col_names[$j]] = isset($this->handler->sheets[0]['cells'][$i-1][$j]) ? $this->handler->sheets[0]['cells'][$i-1][$j] : null;
  37              }
  38          }
  39          $this->delete_source_file ? @Ak::file_delete($this->source_file) : null;
  40          return $result;
  41      }
  42  
  43      function init()
  44      {
  45          if(empty($this->handler)){
  46              require_once(AK_VENDOR_DIR.DS.'Excel'.DS.'reader.php');
  47              $this->handler = new Spreadsheet_Excel_Reader();
  48              $this->handler->setRowColOffset((empty($this->first_column) ? 0 : $this->first_column));
  49          }
  50          
  51          $this->tmp_name = Ak::randomString();
  52          if(empty($this->source_file)){
  53              $this->source_file = AK_TMP_DIR.DS.$this->tmp_name.'.xls';
  54              Ak::file_put_contents($this->source_file,$this->source);
  55              $this->delete_source_file = true;
  56              $this->keep_destination_file = empty($this->keep_destination_file) ? (empty($this->destination_file) ? false : true) : $this->keep_destination_file;
  57          }else{
  58              $this->delete_source_file = false;
  59              $this->keep_destination_file = true;
  60          }
  61      }
  62  }
  63  
  64  ?>