Display excel file with Liuggio/Excelbundle and Symfony2

Question

I just want to display a Excel file existing on my hardisk in a twig view.

I'm using Symfony[2.5] and "Liuggio/Excelbundle"

This trick works well but i want to add it in my view.

 public function newAction()
    {
        $filename = 'filename.xlsx';
        $reader = \PHPExcel_IOFactory::createReaderForFile($filename);
        $excel = $reader->load($filename);
        $writer = \PHPExcel_IOFactory::createWriter($excel, "HTML");

        $writer->generateStyles();
        $writer->generateSheetData();

// this doesnt work..
        return $this->render('MonextReportingBundle:Default:excel.html.twig', array(
            'excelHtml'=>$writer
    ));

And in my excel.html.twig :

{{ excelHtml | raw }}

Catchable fatal error: Object of class PHPExcel_Writer_HTML could not be converted to string

Thanks a lot guys ! Excuse my english..

Did you try excelHtml.generateSheetData | raw?

Maerlyn
– Maerlyn

2016-12-30 15:32:22 +00:00
Commented Dec 30, 2016 at 15:32 — Maerlyn
– Maerlyn, Commented Dec 30, 2016 at 15:32
@Maerlyn it works great ! thanks a lot

Simon Delaunay
– Simon Delaunay

2016-12-30 15:50:59 +00:00
Commented Dec 30, 2016 at 15:50 — Simon Delaunay
– Simon Delaunay, Commented Dec 30, 2016 at 15:50

Maerlyn · Accepted Answer · 2016-12-30 18:19:36Z

1

PHPExcel's HTML writer has no toString(), that's why your attempt didn't work.

It has, however, a method called generateSheetData that seems to do what you want. Use it like this:

{{ excelHtml.generateSheetData | raw }}

answered Dec 30, 2016 at 18:19

Maerlyn

34.2k18 gold badges99 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Simon Delaunay Over a year ago

Maerlyn, do you know how to set Max column ? I want to display only 14 columns in my HTML table. I dont know how to implement a Filter inside my newAction function.. Thanks a lot.

Maerlyn Over a year ago

@SimonDelaunay if you have a question, ask a question

Collectives™ on Stack Overflow

Display excel file with Liuggio/Excelbundle and Symfony2

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related