PHP code example of hzx / excel-dto

1. Go to this page and download the library: Download hzx/excel-dto library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

hzx / excel-dto example snippets


use Hzx\ExcelDto\Annotation\ExcelData;
use Hzx\ExcelDto\Annotation\ExcelProperty;

/**
 * @ExcelData(name="test")
 */
class Test
{

    /**
     * @ExcelProperty(value="用户名", index="0")
     */
    public $name;

    /**
     * @ExcelProperty(value="邮箱", index="1")
     */
    public $email;


    /**
     * @ExcelProperty(value="经度", index="3")
     */
    public $longitude;

    /**
     * @ExcelProperty(value="纬度", index="4")
     */
    public $latitude;
}



    use Hzx\ExcelDto\Annotation\ExportExcel;

    /**
     * @ExportExcel(property="test", path="/storage/exports")
     */
    public function test1($filename)
    {
        $faker = \Faker\Factory::create();
        $data = [];
        for ($i = 0; $i < 100; $i++) {
            $data[] = [
                'name'      => $faker->name,
                'email'     => $faker->email,
                'longitude' => $faker->longitude,
                'latitude'  => $faker->latitude,
            ];
        }
        return $data;
    }
    
    /**
     * @ExportExcel(property="test", path="/storage/exports")
     */
    public function test2()
    {
        $faker = \Faker\Factory::create();
        $data = [];
        for ($i = 0; $i < 100; $i++) {
            $data[] = [
                'name'      => $faker->name,
                'email'     => $faker->email,
                'longitude' => $faker->longitude,
                'latitude'  => $faker->latitude,
            ];
        }
        return $data;
    }
    $result1 = $this->test1('test.xlsx');
    $result2 = $this->test2();
    
   print_r($result1);
   Array
    (
        [basic] => Array
            (
                [property] => test
                [path] => /www/poj/storage/exports
                [group] => local
                [filename] => test.xlsx
                [full_path] => www/poj/storage/exports/2021091810/test.xlsx
            )
    
        [data] => Array
            (
                [0] => Array
                    (
                        [name]      => Loan Officer,
                        [email]     => [email protected],
                        [longitude] => 113.23,
                        [latitude]  => 23.16,
                    )
    
            )
    
    )