PHP匯出Excel檔案問題!求解救~~

來源:互聯網
上載者:User
關鍵字 php

先貼代碼:

public function check_daochu($data) {        $this->load->library('PHPExcel');        $this->load->library('PHPExcel/IOFactory');        $objPHPExcel = new PHPExcel();        $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);        //設定表頭        $this->Excel_bt($objPHPExcel, $data['bt_data']);        //匯出的類容        $this->Excel_lr($objPHPExcel, $data['data']);        //設定儲存格的寬度        $objPHPExcel->getActiveSheet()->getColumnDimension('b')->setWidth(15);        foreach ($data['hb_data'] as $key => $value) {            //合併儲存格            $objPHPExcel->getActiveSheet()->mergeCells($key . ':' . $value);        }        //水平垂直置中設定        $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);        $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);        $fieldname = iconv('utf-8', 'gb2312', date("Y-m-d", time()) . '_' . $data['bt_data']['A1']);        ob_end_clean();        header("Pragma: public");        header("Expires: 0");        header("Cache-Control:must-revalidate, post-check=0, pre-check=0");        header("Content-Type:application/force-download");        header("Content-Type:application/vnd.ms-execl");        header("Content-Type:application/octet-stream");        header("Content-Type:application/download");        header('Content-Disposition:attachment;filename="' . $fieldname . '.xlsx"');        header("Content-Transfer-Encoding:binary");        $objWriter->save('php://output');    }//設定匯出標題的方法    public function Excel_bt($objPHPExcel, $bt_data) {        foreach ($bt_data as $key => $value) {            $objPHPExcel->getActiveSheet()->setCellValue($key, $value);        }    }    //設定匯出的內容    public function Excel_lr($objPHPExcel, $select_data) {        $i = 3;        $data = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');        foreach ($select_data as $key => $value) {            $j = 0;            foreach ($value as $k => $v) {                $objPHPExcel->getActiveSheet()->setCellValue($data[$j] . $i, $v);                $j++;            }            $i++;        }    }

匯出出現如下的錯誤:

回複內容:

先貼代碼:

public function check_daochu($data) {        $this->load->library('PHPExcel');        $this->load->library('PHPExcel/IOFactory');        $objPHPExcel = new PHPExcel();        $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);        //設定表頭        $this->Excel_bt($objPHPExcel, $data['bt_data']);        //匯出的類容        $this->Excel_lr($objPHPExcel, $data['data']);        //設定儲存格的寬度        $objPHPExcel->getActiveSheet()->getColumnDimension('b')->setWidth(15);        foreach ($data['hb_data'] as $key => $value) {            //合併儲存格            $objPHPExcel->getActiveSheet()->mergeCells($key . ':' . $value);        }        //水平垂直置中設定        $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);        $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);        $fieldname = iconv('utf-8', 'gb2312', date("Y-m-d", time()) . '_' . $data['bt_data']['A1']);        ob_end_clean();        header("Pragma: public");        header("Expires: 0");        header("Cache-Control:must-revalidate, post-check=0, pre-check=0");        header("Content-Type:application/force-download");        header("Content-Type:application/vnd.ms-execl");        header("Content-Type:application/octet-stream");        header("Content-Type:application/download");        header('Content-Disposition:attachment;filename="' . $fieldname . '.xlsx"');        header("Content-Transfer-Encoding:binary");        $objWriter->save('php://output');    }//設定匯出標題的方法    public function Excel_bt($objPHPExcel, $bt_data) {        foreach ($bt_data as $key => $value) {            $objPHPExcel->getActiveSheet()->setCellValue($key, $value);        }    }    //設定匯出的內容    public function Excel_lr($objPHPExcel, $select_data) {        $i = 3;        $data = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');        foreach ($select_data as $key => $value) {            $j = 0;            foreach ($value as $k => $v) {                $objPHPExcel->getActiveSheet()->setCellValue($data[$j] . $i, $v);                $j++;            }            $i++;        }    }

匯出出現如下的錯誤:

你的不行指的是什嗎?

register_shutdown_function(function(){    $lastError = error_get_last();    if ($lastError) {        error_log(json_encode($lastError));    }});

你用記事本開啟看下有沒有報錯
一般這種情況是出錯了

以前的文章,還是沒找到原因呢

  • 相關文章

    聯繫我們

    該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

    如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.