Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    fuzzy007
    @fuzzy007
    hi all.
    I use laravel :: Excel to import the data into the database. If the file reaches 10,000 lines. Very slow processes .. Help pliz
    example code:

    Excel::load('public/EkoAll.xlsx', function($reader)

          {
    
            $result = $reader->select(array('date','sn','tid','place'))->get();
    
            foreach ($result as $key => $value) {
    
            foreach ($value as $key => $value1) {
    
    
    
    $post = Jadeeko::create([
    
             'date' => date("Y-m-d",strtotime($value1->date)),
             'id_num' => $value1->sn,
             'shj' => $value1->tid,
             'place' => $value1->place

    ]);
    }
    }

    })->get();

    akung11
    @akung11
    hi
    Daniel
    @Dutchie1990
    Someone familiair with excel VBA
    Fery Wardiyanto
    @feryardiant
    Hello @everyone
    Fery Wardiyanto
    @feryardiant
    I just tried laravel-excel on my project, but got an issue that exported file is empty (not resulting any data from my model).
    Fery Wardiyanto
    @feryardiant

    I create new artisan command app:export

    // App\Console\Commands\ExportDataCommand::handle()
    
    $model = $this->argument('model');
    $exportData = new ExportingData();
    
    dispatch($exportData->model($model));

    and jobs

    // App\Jobs\ExportingData::handle()
    
    $store = $excel->create($filename, function ($writer) {
        $writer->sheet('Exported data', function ($sheet) {
            $sheet->fromModel($this->model);
        });
    })->store('xls', storage_path('app/exports'), true);

    When I tried to run php artisan app:export 'App\Models\User' which is registered for App\Console\Commands\ExportDataCommand, I can see file exported to storage_path('app/exports') but it's empty no data whatsoever.

    Any solution?

    blob
    DreCurrency
    @drecurrency
    hello world ! anybody home ?!?!
    Alexey
    @a1ex7
    Hello. Was the laravel excel based on new version of PHP Excel (PHP Spreadsheet). Anybody know?
    Sylvain Pillet
    @SteamWind

    @a1ex7

    An eloquent way of importing and exporting Excel and CSV files for Laravel with the power of PHPExcel

    look at the channel description
    Alan Christian Ruiz Aguirre
    @achristian92
    hello, how can I put excel cell styles
    Alan Christian Ruiz Aguirre
    @achristian92
    OnEachRow WithValidation laravel import ???
    felixbvf
    @felixbvf
    hello
    Narey Moumouni
    @NareyMoum
    hello i want insert or update database with relationship model .How can do this ?
    Rayhan Yulanda
    @RayhanYulanda
    Hello i want to put number for the first row. How can i do that with laravel excel 3.1?