Convert string to date laravel excel

Question

Hi I have a problem for date time format

when I set a string to date like this

$row['waktu_awal'] = date('Y-m-d H:i:s', strtotime($discharge->waktu_awal));

Format text/string change to date but in excel format not change to date

like this picture

Any solution to this case?

Thanks

@MuhammadDyasYaskur I use query builder for execute stored procedure here is my code pastebin.com/pZrHekBC — Temmy Alex
– Temmy Alex, Commented Feb 5, 2020 at 4:46
Problem is here imageupload.net/image/format-excel-date.CLCLp — Temmy Alex
– Temmy Alex, Commented Feb 5, 2020 at 4:48

Muhammad Dyas Yaskur · Accepted Answer · 2020-02-05 06:29:01Z

1

Try

$row['waktu_awal'] = date('Y-m-d H:i:s', strtotime($discharge->waktu_awal));
$row['waktu_awal'] = Date::dateTimeToExcel(Carbon::parse($row['waktu_awal']));

);

and you can format from the column use:

public function columnFormats(): array
{
    return [
        'B' => NumberFormat::FORMAT_DATE_DATETIME,
    ];
}

reference: https://docs.laravel-excel.com/3.1/exports/column-formatting.html

edited Feb 5, 2020 at 6:29

answered Feb 5, 2020 at 4:48

Muhammad Dyas Yaskur

8,35811 gold badges62 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Temmy Alex Over a year ago

Hi i have error when try this $row['waktu_awal'] = date('Y-m-d H:i:s', strtotime($discharge->waktu_awal)); $row['waktu_awal'] = Date::dateTimeToExcel($row['waktu_awal']); Argument 1 passed to PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel() must implement interface DateTimeInterface, string given, called in @MuhammadDyasYaskur

Temmy Alex Over a year ago

My update code pastebin.com/DEGHJmGg @MuhammadDyasYaskur

Muhammad Dyas Yaskur Over a year ago

@TemmyAlex try Carbon::parse($row['waktu_awal'])

Collectives™ on Stack Overflow

Convert string to date laravel excel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related