[FLOW3-general] Direct output of an MS-Excel file to the browser

[Nicolas Forgerit]

Hey Regine,

hm we need some more information on your project. Is it meant to parse
Excel sheets and output them as HTML (which then can be rendered by
your browser) or are you up to constructing Excel sheets given to the
client for downloading? Assuming the latter case, it's all a matter of
setting the correct HTTP header (set it according to [0] via
$response->setHeader()) and set the responses contents
($response->setContent()) to the excel file's contents (the output
generated by PHPExcel). Did you try to open your downloaded excel file
with an editor (maybe rename it to .txt)? Often times you find some
additional information within this (like "Exception..." which when put
into a file foo.xlsx is of course not a valid excel sheet :) ).

Hope that helps.

Ciao Nico

[0] http://stackoverflow.com/questions/974079/setting-mime-type-for-excel-document


On Tue, Jul 24, 2012 at 9:46 AM, Bastian Waidelich <bastian at typo3.org> wrote:
> Regine Rosewich wrote:
>
> Hi Regine,
>
>> I've adapted the PHPExcel-Project to the FLOW3-Framework
>> (vendor-namespacing etc.) [...]
>> want to output Excel-Spreadsheets generated via FLOW3/PHPExcel directly to
>> the browser [...]
>
>
> How did you do that?
>
>> but are only getting header-errors
>
>
> What errors do you get?
>
> Best,
>