Table footer on excel exports #140

Open dimasmaliq opened this topic on on Oct 30, 2017 - 1 comments

dimasmaliq commented on Oct 30, 2017

if we want to add a table footer on 'view', it can be solved by this code :

    "showFooter"=>"bottom",
    "columns"=>array(
        "member"=>array(
            "label"=>"Member",
            "footer"=>"sum"
        ),

But when i want to export data into excel, these table footer doesn't included. how to include the table footer on excel exports?

KoolReport commented on Oct 31, 2017

Currently it is not possible. Export to Excel will push all the dataStores to excel sheets. A dataStore per sheet.

But your question has trigger an idea for us " what if we can export HTML to Excel". if so the Table widgets can be exported to Table in excel (with sum at bottom) or even chart can convert to Excel charts. Not sure if it is a good idea. If anyone feels this is good idea or not good, please comment.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo

Labels

help needed

suggestion

Related package None

KoolReport's Forum

Table footer on excel exports #140

Build Your Excellent Data Report