Trying to implement export to a named excel table.

[syndesiweb]

Im trying to export some queries with nice styling. Our users use excel exports a lot and also use the table filter and sorting functions a lot, do do this successfully they always have to create a table first.

As i understand, the underlying phpspreadsheet package supports this behaviour but i just cant seem to get it to work.

I've tried using this code in both the afterSheet event and the styles() method.

 // create a table
$table = new Table('A1:' . $sheet->getHighestColumn() . $sheet->getHighestRow(), static::getTableName());
$tableStyle = new Table\TableStyle();
$tableStyle->setTheme(TableStyle::TABLE_STYLE_MEDIUM9);
$tableStyle->setShowRowStripes(true);
$table->setStyle($tableStyle);

// Add the table to the sheet
$sheet->addTable($table);

Has anyone successfully created a named table before, and how did they do it?

Thanks in advance.

[winterpk]

@syndesiweb did you ever figure this out? I have the same problem.

[jakebarshickf1nx]

I too am also in the same boat needing to generate formatted tables from this package!