Exporting PDF with charts

[alejandrofloresm]

Hi

I'm generating an excel file with the package. In the excel file it has a visible chart but on the generated PDF the chart is not showing. I have tried using TCPDF and DOMPDF with no luck.

$fileName = 'support-tickets-' . fileTimestamp() .  '.pdf';
Excel::store(new SupportTicketsReportExport($supportTickets), $fileName, null, MaatwebsiteExcel::DOMPDF);

Any ideas on how to do it? The sheet that has the Chart looks like

<?php

namespace App\Exports\Sheets;

use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithTitle;
use Maatwebsite\Excel\Concerns\WithStyles;
use Maatwebsite\Excel\Concerns\WithCharts;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Chart\Chart;
use PhpOffice\PhpSpreadsheet\Chart\Legend;
use PhpOffice\PhpSpreadsheet\Chart\PlotArea;
use PhpOffice\PhpSpreadsheet\Chart\Axis;
use PhpOffice\PhpSpreadsheet\Chart\DataSeries;
use PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues;
use PhpOffice\PhpSpreadsheet\Chart\Title;
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Events\BeforeSheet;
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;

class TicketTypeCountSheet implements FromCollection, WithEvents, WithTitle, WithHeadings, WithStyles, WithCharts
{
    private $data;

    public function __construct($data)
    {
        $this->data = $data;
    }

    public function charts(): array
    {
        $collectionCount = $this->collection()->count();
        // Important can't have a chart where the name of the sheet has spaces or non ascii characters
        $label = [
            new DataSeriesValues(
                DataSeriesValues::DATASERIES_TYPE_STRING,
                'conteo_de_tipo_de_tickets!$A$1',
                null,
                1
            )
        ];
        $categories = [
            new DataSeriesValues(
                DataSeriesValues::DATASERIES_TYPE_STRING,
                'conteo_de_tipo_de_tickets!$A$2:$A$' . ($collectionCount + 1),
                null,
                ($collectionCount + 1)
            )
        ];
        $values = [
            new DataSeriesValues(
                DataSeriesValues::DATASERIES_TYPE_NUMBER,
                'conteo_de_tipo_de_tickets!$B$2:$B$' . ($collectionCount + 1),
                null,
                ($collectionCount + 1)
            )
        ];

        // Define the chart data series
        $range = range(0, count($values) - 1);
        $dataSeries = new DataSeries(
            DataSeries::TYPE_BARCHART,
            null,
            $range,
            $label,
            $categories,
            $values,
        );

        // Define the chart's plot area
        $plotArea = new PlotArea(null, [$dataSeries]);

        // Define the chart's legend
        $legend = new Legend(Legend::POSITION_TOP, null, false);

        // Define the chart's title
        $title = new Title('Conteo de tipos de tickets');
        $xAxisTitle = new Title('Tipo');
        $yAxisTitle = new Title('Cantidad');

        // Create the chart
        $chart = new Chart(
            'chart1',
            $title,
            $legend,
            $plotArea,
            true,
            DataSeries::EMPTY_AS_ZERO,
            $xAxisTitle,
            $yAxisTitle
        );

        // Set the chart's position on the worksheet
        $chart->setTopLeftPosition('D2');
        $chart->setBottomRightPosition('K15');

        return [$chart];
    }

    public function collection()
    {
        // Count the occurrences of each ticket type
        $typeCounts = $this->data->countBy('tipo');

        // Format the data for the new sheet
        $typeCountCollection = collect([]);
        foreach ($typeCounts as $type => $count) {
            $typeCountCollection->push([
                'tipo' => $type,
                'count' => $count,
            ]);
        }

        return $typeCountCollection;
    }

    public function headings(): array
    {
        return [
            'Tipo',
            'Cantidad',
        ];
    }

    public function title(): string
    {
        return 'conteo_de_tipo_de_tickets';
    }

    public function styles(Worksheet $sheet)
    {
        // Auto-size the columns
        foreach (range('A', 'B') as $columnID) {
            $sheet->getColumnDimension($columnID)->setAutoSize(true);
        }
    }

    /**
     * Register events
     *
     * @return array
     */
    public function registerEvents(): array
    {
        \Log::info('registerEvents');
        return  [
            AfterSheet::class => function (AfterSheet $event) {
                $event->sheet
                    ->getPageSetup()
                    ->setOrientation(PageSetup::ORIENTATION_LANDSCAPE);
            }
        ];
    }
}