Export table caption (v2023)

elonmusk · Post by **elonmusk** » Sat May 11, 2024 2:21 pm

i have one dashboard report i want export to Excel using phpexcel with table caption.
Is there any posibilities?
Help me out.

Thanks !

mobhar · Post by **mobhar** » Mon May 13, 2024 2:29 pm

Did you mean "table caption" = title of the page?

elonmusk · Post by **elonmusk** » Wed May 15, 2024 11:58 am

yes thats correct. because i want to export the dashboard report that contains 9 reports i can't differentiate which report that is. That's why i am asking.
Please help me out.
Thank You!

mobhar · Post by **mobhar** » Wed May 15, 2024 2:59 pm

Well, since you want to export the Dashboard Report, it does not support for Page_Exporting server event.

You may follow this topic, and then you need to customize the loadHtml method that belongs to the related Export class, since Report Pages use that method to display the data in the exported media/file.

elonmusk · Post by **elonmusk** » Wed May 15, 2024 8:23 pm

I am using pageDataRendering function. Now i am facing issue is that table header is exporting but i want it as a header now it is show like a simple text. below i my code please correct it if i am wrong.

public function pageDataRendering(&$header)
    {
        // Example:
        //$header = "your header";
        if ($this->isExport("excel"))
            $header = '<table><thead><tr class = "ew-table-header"><th class="ew-export-table-header ew-export"><b>BANGALORE</b></th></tr></thead></table>';
    }

mobhar · Post by **mobhar** » Thu May 16, 2024 2:46 pm

You may disable the PhpSpreadsheet extension from Tools -> Extensions, after that, re-generate ALL the scripts, and try again.

elonmusk · Post by **elonmusk** » Tue May 21, 2024 6:35 pm

If i disable PhpSpreadsheet extension. grand summary is not exporting.
i don't know how to solve it.