I've written an excel download which takes an internal table of data and sends it to Excel. The function works fine except for one column which contains an amount and currency.
The amount field is in the format '£ n.nnn'. The resulting column in Excel reads 'Â£ n.nn'.
The field in the internal table and the contents of the xstring are correct as they don't contain the 'A' character. It seems to happen on transmission of the excel doc.
The ABAP is below :
xbuffer = stringValue.
data = stringValue
buffer = xbuffer ).
i_filename = 'PurchaseOrders.xls'
i_content = xbuffer
i_mime_type = 'application/vnd.ms-excel'
i_in_new_window = abap_false
i_inplace = abap_false ).
I've checked Google and someone has a similar problem relating to MySQL. The suggestion there is to change the character set. I'm not sure I have ny control over it?