Allow use of utf-8-sig encoding for Excel-compatible CSV export

[jazzband]

Allow use of utf-8-sig encoding for Excel-compatible CSV export

[kennethreitz]

Thanks!

I think replacing the current export behavior with this is best.

[kennethreitz]

Any objections?

[kennethreitz]

Done.

[boatcoder]

What ever happened with this? I'm using tablib==3.2.0 and not finding anything with utf-8-sig and excel is still unable to show the emojis that are in the file correctly.

[claudep]

When you export with tablib in csv, you get an unicode result, so AFAIR it's your business to write it in a file with the proper encoding.

[boatcoder]

I'm using tablib via django-tables2 and this is what I had to do to get the encoding bytes into the file.

        if request.GET.get('_export', None):
            export = TableExport(export_format=request.GET['_export'], table=table)
            response = HttpResponse(content_type=export.content_type())
            filename=f"{self.export_name}.{request.GET['_export']}"
            response["Content-Disposition"] = f'attachment; filename="{filename}"'
            # These 3 bytes at the beginning of the file make excel happy with the emojis
            response.write(b'\xef\xbb\xbf')
            response.write(export.export())
            return response

[claudep]

You could write a single write line with response.write(export.export().encode('utf-8-sig'))