Phpspreadsheet: XSLM Workbook - macro logic is removed when file is written to.

Created on 13 Jun 2017 · 4Comments · Source: PHPOffice/PhpSpreadsheet

I have a excel macro enabled workbook with custom macros. Our users can access a website and a there is a download process which populates the sheets of the workbook with data and downloads the complete book.

What is the expected behavior?

When writing to a xlsm workbook with empty sheets, the original macro's should remain after writing the file.

What is the current behavior?

It seems the original macro VBA details are getting stripped from the file when it's written to the php:output stream

What are the steps to reproduce?

See the code below

<?php

// load the workbook
$spreadsheet = PhpOffice\PhpSpreadsheet\IOFactory::load("BHAA.Race.Master.xlsm");

// create a writer instance
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, "Xlsx");

// set the headers
header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header("Content-Disposition: attachment; filename=05featuredemo.xlsm");
header("Pragma: no-cache");
header("Expires: 0");

// write to the output stream
$writer->save('php://output');