Dashboard - Exporting - with Views - Dashboard to Excel

Katherine Wong commented on May 23, 2023

From the https://www.koolreport.com/examples/reports/dashboard/demo/

May I know when can the development team fix this error? Thanks.

Sebastian Morales commented on May 24, 2023

Thank for your feedback! We've fixed this issue with Dashboard Demo's Exporting With Views. You can check the updated code in file ExportViewBoard.php below the page. Pls try it again and let us know if there's any issue.

Katherine Wong commented on May 24, 2023

Hi, I found the export only for the line and bar chart, how about export the "Data table" into the excel?? Looking for your reply.

Sebastian Morales commented on May 24, 2023

Oh, it's because in the Dashboard's excel view file export_views/ExportViewBoardExcel.view.php we don't include excel's Table widget. You can add it yourself to the excel view:

    ...
    <div>
        <?php
        $ProductTable = $dashboard->widget("ProductTable");
        \koolreport\excel\Table::create([
            "dataSource" => $ProductTable->exportedData()
        ]);
        ?>
    </div>

Katherine Wong commented on May 24, 2023

Hi, Can I used this method ?

...

                Panel::create()->type("danger")->header("<b>Profit and Loss/Income Statement</b>")->sub([
			Dropdown::create("exportOptions")
			->title("<i class='far fa-file-pdf'></i> Export Options")
			->items([
				"Export PDF"=>MenuItem::create()
				->onClick(
					Client::showLoader().
					Client::widget("ClosingPLStatementTable")->exportToPDF("PL Statement Dashboard", ["all" => true] )
				),
				
				"Export Xlsx"=>MenuItem::create()
				->onClick(
					Client::showLoader().
					Client::widget("ClosingPLStatementTable")->exportToXLSX("All PL Statement Dashboard",["all"=>true])
				),
				
			])
			->align("right")
			->cssStyle("margin-bottom:15px;")
			->cssClass("text-right"),

			HTML::style("#ClosingPLStatementTable .table {white-space:nowrap;}"),

			HTML::style("#ClosingPLStatementTable .pivot-column td{font-weight:bold}"),
			HTML::style("#ClosingPLStatementTable .pivot-row{white-space: normal;}"),
			
			ClosingPLStatementTable::create()->pdfExportable(true)->lazyLoading(true),   
			
		]),

....

Sebastian Morales commented on May 25, 2023

I'm not sure what you meant but the menu and command for exporting the current dashboard to excel is:

                        Dropdown::menuItem()
                            ->text("Dashboard to Excel")
                            ->icon("far fa-file-excel")
                            ->onClick(
                                Client::dashboard($this)
                                    ->exportToXLSX("Dashboard - Revenue 2022")
                            ),

KoolReport's Forum

Dashboard - Exporting - with Views - Dashboard to Excel #3055

Build Your Excellent Data Report