×ðÁú¿­Ê±¹ÙÍøµÇ¼

ThinkPHP6ÖÐÔõÑù¾ÙÐÐExcelµ¼ÈëºÍµ¼³ö£¿

Ëæ×Å»¥ÁªÍøÓ¦ÓÃÈÕÒæÆÕ¼° £¬ÒÔ¼°ÖÖÖÖÊý¾ÝÖ®¼äµÄÏ໥½»»¥ºÍÊý¾ÝתÒÆÐèÇóµÄÒ»Ö±ÔöÌí £¬ÎļþÃûÌõÄת»»ºÍµ¼Èëµ¼³öÒѳÉΪ³£¼ûÐèÇóÖ®Ò»¡£ÔÚwebÓ¦ÓóÌÐòÖÐ £¬µ¼ÈëºÍµ¼³öexcelÎļþÊÇÒ»Ñùƽ³£ÊÂÇéÖг£¼ûµÄÊý¾Ý½»“Q·½·¨¡£±¾ÎĽ«ÏÈÈÝÔõÑùÔÚthinkphp6¿ò¼ÜÖÐʵÏÖexcelµ¼Èëµ¼³ö¹¦Ð§¡£

Ò»¡¢ ThinkPHP6¿ò¼ÜÏÈÈÝ

ThinkPHP6ÊÇÒ»¸ö×ÔÓÉ¡¢¿ªÔ´¡¢¿ìËÙ¡¢¼òÆÓµÄÃæÏò¹¤¾ßµÄÇáÁ¿¼¶PHP¿ò¼Ü¡£Ëü¾ßÓиßÐÔÄÜ¡¢¸»ºñµÄ¹¦Ð§¡¢ÎÞаµÄÉèÖá¢Ç¿Ê¢µÄÀ©Õ¹ÐÔµÈÌصã £¬ÒѾ­³ÉΪPHPÓ¦Óÿª·¢ÁìÓòµÄÒ»¸öÈÈÃÅ¿ò¼Ü¡£

¶þ¡¢Excelµ¼³ö

ʾÀý´úÂë

<?php
namespace appindexcontroller;

use PHPExcel;
use PHPExcel_IOFactory;

class ExcelExport
{
    public function export()
    {
        $objPHPExcel = new PHPExcel();

        // ÉèÖÃÄ¿½ñÔ˶¯sheet
        $objPHPExcel->setActiveSheetIndex(0);

        // ÉèÖÃÎÊÌâ
        $objPHPExcel->getActiveSheet()->setTitle('ѧÉúЧ¹û');

        // ÉèÖñíÍ·
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'ѧºÅ');
        $objPHPExcel->getActiveSheet()->setCellValue('B1', 'ÐÕÃû');
        $objPHPExcel->getActiveSheet()->setCellValue('C1', 'ÓïÎÄ');
        $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Êýѧ');
        $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Ó¢Óï');
        $objPHPExcel->getActiveSheet()->setCellValue('F1', '×Ü·Ö');

        // ÉèÖÃÊý¾Ý
        $data = [
            ['1001', 'ÕÅÈý', '85', '90', '88', '263'],
            ['1002', 'ÀîËÄ', '90', '88', '90', '268'],
            ['1003', 'ÍõÎå', '92', '87', '91', '270']
        ];
        $row = 2;
        foreach ($data as $val) {
            $objPHPExcel->getActiveSheet()->setCellValue('A' . $row, $val[0]);
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $row, $val[1]);
            $objPHPExcel->getActiveSheet()->setCellValue('C' . $row, $val[2]);
            $objPHPExcel->getActiveSheet()->setCellValue('D' . $row, $val[3]);
            $objPHPExcel->getActiveSheet()->setCellValue('E' . $row, $val[4]);
            $objPHPExcel->getActiveSheet()->setCellValue('F' . $row, $val[5]);
            $row++;
        }

        // ÉèÖÃÁпí
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);

        // µ¼³öExcel
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="ѧÉúЧ¹û.xlsx"');
        header('Cache-Control: max-age=0');
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
        $objWriter->save('php://output');
        exit;
    }
}

µÇ¼ºó¸´ÖÆ

˵Ã÷

ÉÏÃæµÄʾÀý´úÂëÑÝʾÁËÔõÑùʹÓÃPHPExcel¿âʵÏÖExcelµ¼³ö¡£PHPExcel¿âÊÇÒ»¸öPHP¶ÁдExcelÎļþµÄ¿ªÔ´¿â £¬¹¦Ð§Ç¿Ê¢ £¬²Ù×÷¼òÆÓ¡£

Á¬Ã¦Ñ§Ï°¡°PHPÃâ·ÑѧϰÌõ¼Ç£¨ÉîÈ룩¡±£»

Ê×ÏÈ £¬ÎÒÃǽ¨ÉèÁËÒ»¸öPHPExcelʵÀý £¬È»ºóÉèÖÃÄ¿½ñÔ˶¯sheet £¬²¢ÉèÖÃÁËÎÊÌâºÍ±íÍ·¡£Ö®ºó £¬ÎÒÃÇÉèÖÃÊý¾Ý²¢¶ÔÁпí¾ÙÐÐÁËÉèÖá£×îºó £¬ÎÒÃÇʹÓÃheaderº¯ÊýÉèÖÃÁ˵¼³öExcelµÄÄÚÈÝÀàÐÍ¡¢ÎļþÃû»ººÍ´æ¿ØÖÆ £¬È»ºóʹÓÃPHPExcel_IOFactoryÀàµÄcreateWriterÒªÁ콨ÉèÒ»¸öExcel2007ÃûÌõÄдÈëÆ÷ £¬²¢½«Êý¾ÝÁ÷Êä³öµ½ä¯ÀÀÆ÷¡£

Èý¡¢Excelµ¼Èë

ʾÀý´úÂë

<?php
namespace appindexcontroller;

use PHPExcel;
use PHPExcel_IOFactory;

class ExcelImport
{
    public function import()
    {
        if (empty($_FILES['file']['tmp_name'])) {
            echo 'ÇëÑ¡ÔñÎļþ£¡';
            exit;
        }

        $reader = PHPExcel_IOFactory::createReader('Excel2007');
        $PHPExcel = $reader->load($_FILES['file']['tmp_name']);

        $sheet = $PHPExcel->getSheet(0); // »ñµÃµÚ1¸öÊÂÇé±í

        $highestRow = $sheet->getHighestRow(); // È¡µÃ×ÜÐÐÊý
        $highestColumn = $sheet->getHighestColumn(); // È¡µÃ×ÜÁÐÊý

        $data = [];
        for ($row = 2; $row <= $highestRow; $row++) {
            $rowData = [];
            for ($col = 'A'; $col <= $highestColumn; $col++) {
                $rowData[$col] = (string)$sheet->getCell($col . $row)->getValue();
            }
            $data[] = $rowData;
        }

        var_dump($data);
    }
}

µÇ¼ºó¸´ÖÆ

˵Ã÷

ÉÏÃæµÄʾÀý´úÂëÑÝʾÁËÔõÑùʹÓÃPHPExcel¿âʵÏÖExcelµ¼Èë¡£Ê×ÏÈ £¬ÎÒÃÇÅжϿͻ§¶ËÊÇ·ñÉÏ´«ÁËÎļþ £¬²¢Ê¹ÓÃPHPExcel_IOFactoryÀàµÄcreateReaderÒªÁ콨ÉèÒ»¸öExcel2007ÃûÌõĶÁÈ¡Æ÷¡£È»ºó £¬ÎÒÃÇʹÓÃ$readerµÄloadÒªÁ콫ExcelÎļþ¶ÁÈëÄÚ´æ £¬²¢»ñÈ¡ÆäÖеĵÚÒ»¸öÊÂÇé±í¡£½ÓÏÂÀ´ £¬ÎÒÃÇͨ¹ý×î¸ßÐкÍ×î¸ßÁеÄË÷Òýֵѭ»·±éÀúExcel±í¸ñ £¬½«Ã¿ÐÐÊý¾ÝÒÔ¹ØÁªÊý×éµÄÐÎʽ´æ´¢µ½$data±äÁ¿ÖÐ £¬²¢×îÖÕÊä³ö¸Ã±äÁ¿¡£

ËÄ¡¢×ܽá

ͨ¹ý±¾ÎĵÄÏÈÈÝ £¬ÎÒÃÇÏàʶÁËÔõÑùʹÓÃThinkPHP6¿ò¼ÜÍŽáPHPExcel¿âʵÏÖExcelÎļþµÄµ¼Èëµ¼³ö¹¦Ð§ £¬ÕâΪÎÒÃǵÄWebÓ¦ÓóÌÐò¿ª·¢ÌṩÁ˱㵱ºÍÖ§³Ö¡£ÎÒÃÇ¿ÉÒÔƾ֤ÏÖʵµÄÐèÇó £¬ÎÞаÔËÓÃPHPExcel¿âµÄÖÖÖÖÒªÁìºÍÊôÐÔ £¬À´ÊµÏÖÎļþÃûÌý»Á÷ £¬²¢¸üºÃµØЧÀÍÓÚÎÒÃǵÄÓ¦ÓóÌÐò¡£

ÒÔÉϾÍÊÇThinkPHP6ÖÐÔõÑù¾ÙÐÐExcelµ¼ÈëºÍµ¼³ö£¿µÄÏêϸÄÚÈÝ £¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí £¬°æȨÕùÒéÓë±¾Õ¾ÎÞ¹Ø £¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í×ðÁú¿­Ê±¹ÙÍøµÇ¼ÂËÓÍ»úÍø¹Ù·½Ì¬¶È £¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ £¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢ £¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢ £¬ÇëÄúÁ¬Ã¦ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎå £¬9:30-18:30 £¬½ÚãåÈÕÐÝÏ¢

QR code
ÍøÕ¾µØͼ