How to pre-format a cell to date on Laravel Excel

php excel laravel cell-formatting laravel-excel
Jay Marz picture Jay Marz · Apr 24, 2015 · Viewed 18.6k times · Source

I am using the package maatwebsite.com/excel for exporting xls files from my app. I want to pre-format the cell to date. Is it possible?

I have formatted the data to date, but I want that the cell would be pre-formatted with date (its default cell format is general). How can I achieve this in PHP or Laravel 4?

Answer

haakym picture haakym · Apr 24, 2015

Have you tried this yet?

$sheet->setColumnFormat(array(
    'A' => 'yyyy-mm-dd'
));

From the documentation: http://www.maatwebsite.nl/laravel-excel/docs/export#format

Different date formats are available here: http://www.maatwebsite.nl/laravel-excel/docs/reference-guide#formatting

Related questions

Call to undefined method Maatwebsite\Excel\Excel::load()

I'm trying to import excel file (.xlsx) using maatwebsite 3.0. How to fix This error Call to undefined method Maatwebsite\Excel\Excel::load() My controller public function importsave(Request $request) { if($request->hasFile('excel')) { $path = $request->file('excel')-&…

Read More
Laravel Excel , exporting from a model, styling issues

I am trying to export some data from my model to excel scheet with "Laravel excel", I have done it, but my result is far away from what I really need That is what I`ve got in downloaded file: …

Read More
Reading excel file in Laravel

I'm using Maatwebsite's library for reading and creating excel file. The creating was easy and somehow intuitive, but when it comes to reading one, I simply can't figure it out. This is how my excel file looks like: I figured …

Read More