Excel export with table format

[yayitazale]

The exported excel archive is not formatted as a table

Solution
Format the excell as a table, with titles and so, This is the guide to do it manually: https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370

Thanks

[kevinpapst]

Which export exactly?
And I have no Excel for testing, so I need dev help with that one.

[yayitazale]

Export > Excel

This is hat we get:
kimai-export-original.xlsx
And this is the same but with table format:
kimai-export-titles.xlsx

[kevinpapst]

Maybe this is related: https://stackoverflow.com/questions/50934401/phpspreadsheet-multiple-tables-with-format-as-table-in-excel-worksheet

[HeinzWuert]

Maybe this would solve the problem with loosing the autostart of the macro when creating the excel sheet.

[yayitazale]

Maybe this is related: https://stackoverflow.com/questions/50934401/phpspreadsheet-multiple-tables-with-format-as-table-in-excel-worksheet

You only need 1 table format as table.

[kevinpapst]

@HeinzWuert this is the export, which creates the excel dynamically, instead of parsing an existing template file.

@yayitazale yes, but I have no idea how to apply that. if anyone knows how to set that style on the table, I am happy to integrate it into kimai.

[yayitazale]

I found this, maybe it can be usefull:

https://github.com/PHPOffice/PhpSpreadsheet

[kevinpapst]

Yes and no.
Yes: this is the library I am using to generate the excel files.
No: I couldn't find any documentation how these table styles can be applied.

[kevinpapst]

now available in master

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs. If you use Kimai on a daily basis, please consider donating to support further development of Kimai.