Build 4.5.0.24 of xlsgen improves support for Unicode in CSV export and XML export.

For CSV export, the option to export as Unicode UTF8 was already available, but the CSV export did not include a Byte Order Mark right at the beginning of the file that would instruct a consumer application that the file is encoded with Unicode UTF8. This build adds it automatically.

If you need to support Unicode UCS2 (i.e. fix 2-byte encoding), this build adds the option in the worksheet export interface. Of course, the corresponding Byte Order Mark is added as well.

For XML export, it is exactly the same. Both Unicode UCS2 support is new (default was Unicode UTF8), and also this build adds a Byte Order Mark in the XML output, that lets a consuming application know in advance how the stream/file is encoded.

Here is an example (Unicode UCS2) :

workbook.WorksheetByIndex(2).Export.Options.UnicodeEncoding = True
workbook.WorksheetByIndex(2).Export.ExportAsCSV("filename.csv", True)