thinkphp - Mengapa jadual eksport phpExcel bersempadan dengan hanya garis menegak?

Question

< /p>

fungsi awam sincewriter($cart,$shopname) {
        $obj = baru \PHPExcel();
        $obj->getProperties()->setCreator("JAMES")
            ->setLastModifiedBy("JAMES")
            ->setTitle("zltrans")
            ->setSubject("Dorder")
            ->setDescription("Senarai Dorder")
            ->setKeywords("Dorder")
            ->setCategory("Fail hasil ujian");

        $obj->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $obj->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objSheet = $obj->getActiveSheet();
        //相关行高
        $n = 'a';
        untuk ($i = 0; $i < 18; $i++) {
            $obj->getActiveSheet()->getRowDimension($i)->setRowHeight(40);
            $objSheet->getColumnDimension($n++)->setWidth(12);
        }

        $obj->getActiveSheet()->getColumnDimension('B')->setWidth(25);
        $obj->getActiveSheet()->getColumnDimension('F')->setWidth(25);

        //标题
        $obj->getActiveSheet()->mergeCells('A1:H1');

        $obj->getActiveSheet()->getStyle('A1')->getFont()->setSize(14);
        $obj->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);

        $obj->getActiveSheet()->setCellValue("A1", "优菜提货单签收单");


        $obj->getActiveSheet()->mergeCells('A2:D2');
        $obj->getActiveSheet()->setCellValue("A2", "提货站点：" . $nama kedai);

        $obj->getActiveSheet()->mergeCells('E2:H2');
        $obj->getActiveSheet()->setCellValue("E2", "出货时间：" . date("Y-m-d"));

        $obj->getActiveSheet()->setCellValue("A4", "序号");
        $obj->getActiveSheet()->setCellValue("B4", "订单号");
        $obj->getActiveSheet()->setCellValue("C4", "金额");
        $obj->getActiveSheet()->setCellValue("D4", "提货确定");

        $obj->getActiveSheet()->setCellValue("E4", "序号");
        $obj->getActiveSheet()->setCellValue("F4", "订单号");
        $obj->getActiveSheet()->setCellValue("G4", "金额");
        $obj->getActiveSheet()->setCellValue("H4", "提货确定");

        $len = 5;
        $len2 = 5;

        $count = count($cart);

        foreach ($cart as $key => $vo) {

            jika ($kunci < $count / 2 + 3) {
                $obj->getActiveSheet()->setCellValue("A" . $len, $key + 1);
                $obj->getActiveSheet()->setCellValue("B" . $len, $vo['orderid']);
                $obj->getActiveSheet()->setCellValue("C" . $len, ' ' . $vo['sum']);
                $obj->getActiveSheet()->setCellValue("D" . $len, '');
                $len++;
            } lain {
                $obj->getActiveSheet()->setCellValue("E" . $len2, $key + 1);
                $obj->getActiveSheet()->setCellValue("F" . $len2, $vo['orderid']);
                $obj->getActiveSheet()->setCellValue("G" . $len2, ' ' . $vo['sum']);
                $obj->getActiveSheet()->setCellValue("H" . $len2, ' ');
                $len2++;
            }
        }

        $hang = $len;

        $obj->getActiveSheet()->mergeCells('A' . $hang . ':B' . $hang);
        $obj->getActiveSheet()->setCellValue("A" . $hang, '优菜送货员签名送达');
        $obj->getActiveSheet()->mergeCells('C' . $hang . ':D' . $hang);
        $obj->getActiveSheet()->setCellValue("C" . $hang, '');


        $obj->getActiveSheet()->mergeCells('F' . $hang . ':H' . ($hang + 2));

        $hang++;
        $obj->getActiveSheet()->mergeCells('A' . $hang . ':C' . $hang);
        $obj->getActiveSheet()->setCellValue("A" . $hang, '本次物品袋数：');
        $obj->getActiveSheet()->setCellValue('D' . $hang, $count);
        $obj->getActiveSheet()->setCellValue('E' . $hang, '袋');
        $hang++;
        $obj->getActiveSheet()->mergeCells('A' . $hang . ':B' . $hang);
        $obj->getActiveSheet()->setCellValue("A" . $hang, '本次提货点签名签收：');
        $obj->getActiveSheet()->mergeCells('C' . $hang . ':E' . $hang);
        $obj->getActiveSheet()->getStyle('A1:H' . $hang)->getBorders()->getAllBorders()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);
        $nama = masa();
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="' . $name . '.xls"');
        header('Cache-Control: max-age=0');
        $objWriter = \PHPExcel_IOFactory::createWriter($obj, 'Excel5');
        $objWriter->save('php://output');
    }

这一句是边框

$obj->getActiveSheet()->getStyle('A1:H' . $hang)->getBorders()->getAllBorders()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN: );

Answer 1

Nampaknya tiada masalah dengan kod Ini mungkin masalah dengan versi Excel keluaran Anda boleh menggunakan: $objWriter = PHPExcel_IOFactory::createWriter($obj, 'Excel2007');

Selain itu: ia adalah yang terbaik. untuk menambah: ob_end_clean(); sebelum output //Kosongkan penimbal untuk mengelakkan aksara bercelaru

Manual rujukan bahasa Cina:https://www.kancloud.cn/jingyifeng/phpexcel/363084

Answer 2

Cuba tukar kepada kod ini:

$styleArray = array(
    'borders' => array(                                                                                                                                         
        'allborders' => array(                                                                                                                                  
            'style' => PHPExcel_Style_Border::BORDER_THIN                                                                                                       
        )
     )                                                                                                                                                       );
$obj->getActiveSheet()->getStyle('A1:H' . $hang)->applyFromArray($styleArray);