Is there a way a can bypass the format? (Laravel Exporting)

Greetings everyone. Currently i'm working with a export plugin where i was instructed to export data to excel everything works on my end but were i need the field to display example Credit Card Number (CCN) of 16 characters it round it. I have tried many tweaks, i even tried to format the column but it never worked in most cases.

My question "Is there a way a can bypass the format?".

Here is the Export Code: ' public function columnFormats(): array { return [ 'X' => NumberFormat::FORMAT_NUMBER, 'P' => NumberFormat::FORMAT_CURRENCY_USD, ]; }

Razdan

6 years ago

Level 1

Here is the Code

public function view(): View{ $guests=Guest::all(); return view('form.export',compact('guests')); }

The P column works which add the $ sign

mstrauss

6 years ago

Level 14

What package are you using? A lot of folks, including myself, use [Laravel Excel] (https://github.com/Maatwebsite/Laravel-Excel).

Either way if you are exporting to MS Excel, there is a 15 digit precision rounding.

Check out this SO thread for a potential solution: https://stackoverflow.com/questions/51533373/laravel-excel-column-formatting-replaces-digit-with-0

slev1n

6 years ago

Level 4

You can highlight code blocks:

    ```
        public function some()
        {
            // do stuff
        }
    ```

Are you tried format CCN like string?

Please or to participate in this conversation.