Use SAP function modules to create an XLS file (no customisation possible).There have traditionally been a few ways around this problem numeric fields of more than about 15 digits are truncated.dates are YYYYMMDD, so are not shown as a date in Excel.no formatting (headings, colours, column widths etc).This is fine for simple data, but has lots of problems: The simplest solution is to download a tab separated file and then open this in Excel. If the report is a simple ALV grid then the ALV control can do it automatically, but otherwise ABAP coding is required.
There is often a requierment to export report data to a Microsoft Excel spreadsheet. Exporting data to Excel - XML to the rescue You can also use the abap2xlsx tool described in SDN blog abap2xlsx - Generate your professional Excel spreadsheet from ABAP, by Ivan Femia, which generates an XLSX file (available from Excel 2007).
0 kommentar(er)
