- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- Export XLS files
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Export XLS files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Feb 17 1:09 PM
- SAP Managed Tags:
- ABAP Development
Hi all.
Does anyone know a function to export "real" XLS files from SAP ECC 6?
When we try to export in this format, besides the XLS extension, the file content is a CSV (separated by tabs) which I have to open in Excel to convert into a real XLS file.
I would like to generate a "real" XLS from SAP to be imported into another into another application (which doesn't accept CSV format) without having the extra step of the conversion in Excel.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Feb 17 1:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Feb 17 1:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Feb 19 12:10 AM
- SAP Managed Tags:
- ABAP Development
Hi!
Check this FM MS_EXCEL_OLE_STANDARD_DAT or SAP_CONVERT_TO_XLS_FORMAT
--
Raul Natu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Feb 28 6:50 PM
- SAP Managed Tags:
- ABAP Development
Thank you, guys.
The function SAP_CONVERT_TO_XLS_FORMAT solved our problem.
Just a detail for reference: it only works in workstations where you have MS Excel installed.
Best Regards,
Marcelo
