[TYPO3-english] Headers to export to Excel

[Guillermo R. Oramas J.]

Thank you Richard!

I had the same structure but I didn't have the final "exit;".

Adding that line I was able to solve this issue.

I probed applying this same solution to a PDF export link that I have in
other plugin and the result was also great.

Now both plugins display correctly the files when the users click the links.

Greetings.

2012/9/10 Richard Davies <richard at ocular.co.nz>

> Hi there,
>
> I believe typo3 only throws out its headers right at the end, so if you
> call your headers, echo out the data then exit, it should work.
> spreadsheet_excel_writer works well for me. Can you confirm you call send
> at the start of your write? It should go something like
> ->construct
> ->send(file)
> //add/write data
> ->close
> exit;
>
> Richard
>
>
> On 11 September 2012 10:38, Guillermo R. Oramas J. <oramas.g at gmail.com
> >wrote:
>
> > Hello.
> >
> > I have a frontend plugin where I displayed some tabular data. I
> developed a
> > function to export the same data to excel.
> >
> > To do that I created a link with a parameter "?cmd=excel" that redirects
> to
> > the same plugin and trigger the excel function.
> >
> > When the user clicks the link the browser dialog appears offering to open
> > or save the file. If the user selects "save", the file is saved and then
> > opens without problems, but if the user selects "open" then the browser
> > opens the file in an unreadable format.
> >
> > I know that is because the headers passed to the browser are html and
> > nothing is said about excel.
> >
> > I think I need to put something like:
> >
> >         header('Content-Type: application/vnd.ms-excel');
> >         header('Content-Disposition:
> attachment;filename="filename.xls"');
> >         header('Cache-Control: max-age=0');
> >
> > But I suspect that the Spreadsheet_Excel_Writer already do that, so the
> > problem is how to pass these headers before any other headers?
> >
> > Thanks for the help. I hope I will learn something new today!
> > _______________________________________________
> > TYPO3-english mailing list
> > TYPO3-english at lists.typo3.org
> > http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
> >
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>