PHPがExcelのSpreadsheetを読み込むExcel_Reader

1681 ワード

<?php
      require_once('Excel/Spreadsheet_Excel_Reader');
      @$data = new Spreadsheet_Excel_Reader();
      @$data->setOutputEncoding('UTF-8');
      @$data->read($fileName);
      
      //$i = 2           
        for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++)
        {
            
            
            $sql = "INSERT INTO goods_temp (
            goods_type,goods_no,goods_name,sys,sys_name,area,area_name,sys_goods_no,market_price,profit_price,
            retail_price,add_time,last_update,add_user,batch_no
            )
            VALUES('0','".
            $data->sheets[0]['cells'][$i][1]."','".
            $data->sheets[0]['cells'][$i][2]."','".
            $result['sys_id']."','".
            $data->sheets[0]['cells'][$i][3]."','".
            $result['ma_id']."','".
            $data->sheets[0]['cells'][$i][4]."','".
            $data->sheets[0]['cells'][$i][5]."','".
            $data->sheets[0]['cells'][$i][6]."','".
            $data->sheets[0]['cells'][$i][7]."','".
            $data->sheets[0]['cells'][$i][8]."','".
            time()."','".
            time()."','".
            $session_array['ac_name']."','".
            $id."')";
            
            $result = $this->db->query($sql);
           
        }