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?
This might not be the most elegant solution but here is how I solved it:
public function fromString($data=null)
{
$file = tempnam(sys_get_temp_dir(), 'excel_');
$handle = fopen($file, "w");
fwrite($handle, $data);
$return = \PHPExcel_IOFactory::load($file);
fclose($handle);
unlink($file);
return $return;
}
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
PHPExcel_IOFactory::load('php://temp') seems to be wrong... Do you have any idea? Will there be any problems with zip or so?
php://memory (and similar) is not possible, because it's not possible to pass an already open stream to PHPExcel to load from it. Passing "php://memory" as filename to PHPExcel will make it open a separate fresh stream which will be empty.You must first create a reader for the excel file and then load that file from your constructed reader. Take a look at this for full details.
