ＰＨＰ导出数据

最新推荐文章于 2023-11-06 08:56:23 发布

RenBingo

最新推荐文章于 2023-11-06 08:56:23 发布

阅读量155

点赞数

分类专栏： PHP 文章标签： php excel 数据

本文链接：https://blog.csdn.net/bingo199/article/details/78580409

版权

PHP 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

/**
     * 导出Excel文件
     */
    public function test() {
        $this->load->helper(array('url', 'common'));
        $title = ['id' => '数据ID', 'num' => '数字'];
        $file = 'test';
        $this->load->model('Test_model');
        $total = $this->Test_model->db_get_total('id', []);
        $num = ceil($total / 2000);
        require_once APPPATH . 'third_party/PHPExcel/PHPExcel.php';
        $objPHPExcel = new PHPExcel();
        for ($ki = 0; $ki < 5; $ki++) {
            $data = $this->Test_model->db_get_list('id,num', [], $ki * 2000, 2000);
            $objPHPExcel->createSheet($ki);
            $obj = $objPHPExcel->setActiveSheetIndex($ki);
            $objPHPExcel->getActiveSheet($ki)->setTitle('test_' . $ki);
            //表头数据
            $i = 0;
            foreach ($title as $k => $v) {
                $obj->setCellValue(chr(65 + $i) . '1', $v);
                $i++;
            }

            $i = 2;
            $j = 0;
            foreach ($data as $itemData) {
                $j = 0;
                foreach ($title as $k => $v) {
                    $obj->setCellValue(chr(65 + $j) . $i, $itemData[$k]);
                    $j++;
                }
                $i++;
            }
            unset($i, $j, $data);
        }
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
//        mkdir(RESOURCES_PATH . 'xls/temp/', 0777, true);
        $objWriter->save(RESOURCES_PATH . 'xls/temp/' . $file . '.xls');
        echo 11;
        die;
    }

/**

* 导出ＣＳＶ文件

**/

public function export_csv() {
        $this->load->helper(array('url', 'common'));
        $title = ['id' => '数据ID', 'num' => '数字'];
        $file = 'test';
        $this->load->model('Test_model');
        $total = $this->Test_model->db_get_total('id', []);
        $num = ceil($total / 2000);
        for ($ki = 0; $ki < $num; $ki++) {
            $data = $this->Test_model->db_get_list('id,num', [], $ki * 2000, 2000);
            $file_str = '';
            foreach ($data as $k => $v) {
//                $file_str .= $row['id'] . ',' . $row['title'] . ',' . $row['name'] . ',' . "'{$row['telephone']}'" . ',' . $row['qq'] . ',' . $row['email'] . ',' . str_ireplace(',', '，', $row['content']) . ',' . $row['retime'] . "\n";
                foreach ($title as $index => $item) {
                    $file_str .= $v[$index] . ',';
                }
                $file_str .= "\n";
            }
            file_put_contents(APP_PATH.'/xls/temp/test.csv', $file_str, FILE_APPEND);
        }
        echo 1111;
    }