We are using the following code to produce an Excel Spreadsheet. But the parameter WRITE_BOM is not working - SAP does not write a byte-order mark to the file. The result is that Excel does not open the file correctly. When we add the BOM manually in UltraEdit the file opens correctly.
CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = 'C:\export.xls' filetype = 'DAT' trunc_trailing_blanks = 'X' write_field_separator = 'X' codepage = '4310' write_bom = 'X' TABLES data_tab = gt_textsi EXCEPTIONS