DEV Community

Md Anik Islam
Md Anik Islam

Posted on

How To Export Unique Barcode to Excel In Laravel

Hi Artisan,
What's up? Hope's all are good. In this tutorial, I will give you an example to export barcode in excel in Laravel by using JavaScript.

You can easily export barcode in laravel 5, laravel 6, laravel 7, laravel 8, laravel 9 and laravel 10 version.

Step 1

In first step, If you haven't installed Laravel in your system then you can run bellow command and get fresh Laravel project.

composer create-project --prefer-dist laravel/laravel export-barcode
Enter fullscreen mode Exit fullscreen mode

Step 2

Now we need a install a barcode package of laravel. there is so many barcode package we have for laravel. Among them you can use any one. In this case i am installing picqer/php-barcode-generator package for barcode generator, that way we can use it's method. So Open your terminal and run bellow command.

composer require picqer/php-barcode-generator
Enter fullscreen mode Exit fullscreen mode

Step 3

In this step, we will create one route for testing example. So, let's add new route on that file.
routes/web.php

<?php
Route::view('export-barcode', 'export-barcode');
Enter fullscreen mode Exit fullscreen mode

Now we need to create export-barcode.blade.php for display bar code. so let's create blade file as like bellow code:

resources/views/export-barcode.blade.php

export-barcode.blade.php

Step 4

This is the main part of this tutorial. Here we will doing our main operation to export barcode to excel. Note that the generated barcodes are in base64 format. So whenever we need to export a barcode to excel. First need to save generate bar code to your local storage. Here is code save base64 image to local.

    @php
        $generatorPNG = new Picqer\Barcode\BarcodeGeneratorPNG();
        $somecode = time() . '.png'; //left as excersise for the reader.
        $baseImage = 'data:image/png;base64,' . base64_encode($generatorPNG->getBarcode('000005263635', $generatorPNG::TYPE_CODE_128));

        $img = str_replace('data:image/png;base64,', '', $baseImage);
        $img = str_replace(' ', '+', $img);
        $data = base64_decode($img);

        $path = public_path() . '/barcode/' . $somecode;
        file_put_contents($path, $data);
    @endphp
Enter fullscreen mode Exit fullscreen mode

After Saving The image to local use that saved path of image in Rendered Table.

Step 5

Finally we need a js function which will export excel. Here is the below code of js Function.

$(function() {
            $(".exportToExcel").click(function(event) {
                console.log("Exporting XLS");
                $("#studentTable").table2excel({
                    exclude: ".excludeThisClass",
                    name: $("#studentTable").data("tableName"),
                    filename: "StudentTable.xls",
                    preserveColors: false
                });
            });
        });
Enter fullscreen mode Exit fullscreen mode

Don't forget to import below CDN link.

    <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
    <script src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
Enter fullscreen mode Exit fullscreen mode

Output

Here is the snapshot of our Output.

Excel Output

Note: If You don't want to save all the barcode in your local storage then you can hit Ajax request that delete all the barcode image after export.

Top comments (4)

Collapse
 
developerdoran profile image
Jake Doran

I'm yet to work on a project that requires barcodes, but if I do I'll keep this handy article in mind! Thank you!

Collapse
 
anik2069 profile image
Md Anik Islam

You are welcome. Feel free to knock me if there is any issue.

Collapse
 
sharman profile image
Arman Hasan

Thank you soo much. saved a lot time and makes this super easy to understand step by step guide.

Collapse
 
anik2069 profile image
Md Anik Islam

You are welcome.