Getting unsupported type exception for DateTime objects

[sikhlana]

Even though the plugin can detect DateTime objects:

spout/src/Spout/Common/Entity/Cell.php

Lines 151 to 153 in 9533acc

	if (CellTypeHelper::isDateTimeOrDateInterval($value)) {
	return self::TYPE_DATE;
	}

spout/src/Spout/Common/Helper/CellTypeHelper.php

Lines 61 to 67 in 9533acc

	public static function isDateTimeOrDateInterval($value)
	{
	return (
	$value instanceof \DateTime ||
	$value instanceof \DateInterval
	);
	}

The writer does not have any appropriate parser for these objects and as a result my system is throwing this error:

Box\Spout\Common\Exception\InvalidArgumentException with message 'Trying to add a value with an unsupported type: object'

With a little bit of poking around, I found that this method is not being called anywhere within the package:

spout/src/Spout/Common/Entity/Cell.php

Line 196 in 9533acc

public function isDate()

Which in-turn throws the InvalidArgumentException here:

spout/src/Spout/Writer/XLSX/Manager/WorksheetManager.php

Line 256 in 9533acc

throw new InvalidArgumentException('Trying to add a value with an unsupported type: ' . \gettype($cell->getValue()));

I currently did an ugly hack to bypass this issue. Am I missing something here?

[mezuky04]

I encountered the same problem.