I currently have this
file_put_contents($tmpfile, $attachments[0]['body']);
$objPHPExcel = PHPExcel_IOFactory::load($tmpfile);
The file I am reading is extracted from an email, so rather then writing it to a tempfile I would like to read it directly into phpexcel from a string (if that makes sense)
$objPHPExcel = PHPExcel_IOFactory::load($attachments[0]['body']);
I have looked at the php excel manual but can't see how to do it, any ideas?
PHPExcel provides no direct method for loading from a string rather than from a file. As an alternative to actually creating a physical filesystem file for $tmpfile though, you might be able to use php://memory
or php://temp