KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Dashboard | Export/Excel package #2937

Open Ilze Pabērza opened this topic on on Jan 11 - 5 comments

Ilze Pabērza commented on Jan 11

Hi,

Is it possible to set borders for Excel table if using Dashboard Export Excel engine? By default no formatting is set.

Best Regards

Ilze Pabērza commented on Jan 12

My current code:

PaymentBoard.php

            ])->class("text-right"),
            PaymentTable::create()
            ->xlsxExportable(true)
            ->pdfExportable(true)
        ];

PaymentTable.php

class PaymentTable extends Table
{
    protected function dataSource()
    {
        return AutoMaker::table("orders")->limit(10);
    }

    protected function fields()
    {
        return [
            Number::create("cards"),
        ];
    }
}

I would like to add borders and header in exported Excel:

Could you please help me with code? Thank you in advance.

Ilze Pabērza commented on Jan 12

Sebastian Morales commented on Jan 12

Unfortunately this is currently not possible with Dashboard's excel export. We will find a solution for you soon. Rgds,

Ilze Pabērza commented on Jan 20

When are you planning to get back with solution? Thank you!

Sebastian Morales commented on Jan 27

Sorry for the delayed reply. We have had Lunar New Year for the past week.

Regarding this issue, we are looking for a good solution. Pls send us an email to support@koolreport.com / support@koolphp.net. When we have a development version solving this we would send it to you to try. Tks,

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
help needed

Dashboard