dousa2794
2017-06-01 10:15
浏览 159
已采纳

如何使用PhpSpreadsheet从表格单元格中检索日期?

I have xlsx tables and I use PhpSpreadsheet to parse them. Some cells format is date. The problem is that PhpSpreadsheet returns the values from date-formatted cells in an unspecified format:

// How it looks in excel: 2017.04.08 0:00
$value = $worksheet->getCell('A1')->getValue();  // 42833 - doesn't look like a UNIX time

How to get the date from a cell in form of a UNIX time or a DateTimeInterface instance?

2条回答 默认 最新

相关推荐 更多相似问题