Why my date column always return int value?. How can I get the origin value? because its int value is wrong

[vinaynarendrapeeta]

Hello, I am using Laravel 9 and Laravel-excel is 3.1. In the excel sheet, in one field only i need to take all datatype values. and also how to check whether it is date or integer value getting from excel sheet

[joelharkes]

The best way to parse a Laravel Excel date is the following:

$carbonDatetime = Carbon::parse(Date::excelToTimestamp($value))

[vinaynarendrapeeta]

But here i am using same cell as int value as well as date value. sometimes we insert value as date, sometimes we use value as ids

[joelharkes]

You can pars the date and see if it is a relevant date (check years) or otherwise handle as int.

Or check the formatting that is used on the cell to parse as int or date.