Add UTF-8 BOM to CSV output

[suzukieng]

By default, the table exporter seems to output UTF-8 CSV data, but without a BOM (see: https://csv.thephpleague.com/8.0/bom/)

When opening the CSV file in Excel (yes, I realize there is an Excel export option, but unfortunately that is how many users consume CSV files), special characters will end up garbled by default. You can observe this behavior with your own example (row 10, Wilhelm Röntgen).

As a workaround, is it possible to intercept the output of the exporter, and patch the Blob (put a BOM in front of it), before sending it to the browser as download?

[HalitTalha]

Thanks for the feedback.
As a workaround you can extend CsvExporterService and use it as your custom exporter.
Check this stackblitz: https://stackblitz.com/edit/mte-cex-demo

For those who still use excel version lower than 2013, there seems to be a known MS Office bug that makes the BOM ignored.

I'll label this as a bug later to be fixed.

[HalitTalha]

BOM is available by default