Skip to content

How to Export XLSX with Cell Formatting as Text #2551

Answered by aslanonline
aslanonline asked this question in Q&A

You must be logged in to vote

put this in config folder and name it excel.php

`<?php

use Maatwebsite\Excel\Excel;

return [
'exports' => [

    /*
    |--------------------------------------------------------------------------
    | Chunk size
    |--------------------------------------------------------------------------
    |
    | When using FromQuery, the query is automatically chunked.
    | Here you can specify how big the chunk should be.
    |
    */
    'chunk_size'             => 1000,

    /*
    |--------------------------------------------------------------------------
    | Pre-calculate formulas during export
    |--------------------------------------------------------------------------
    */
    'pre_c…

Replies: 5 comments 8 replies

You must be logged in to vote
0 replies

You must be logged in to vote
0 replies

You must be logged in to vote
4 replies
@3s777

@yajra

@3s777

@3s777

You must be logged in to vote
3 replies
@3s777

@3s777

@Revoluz

Answer selected by aslanonline

You must be logged in to vote
1 reply
@yajra

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
5 participants
Converted from issue

This discussion was converted from issue #2551 on December 23, 2020 12:36.