Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Export XLS files

Monsores
Active Participant
0 Kudos
192

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.

1 ACCEPTED SOLUTION

scott_fischer2
Discoverer
0 Kudos
90

Take a look at this FM: SAP_CONVERT_TO_XLS_FORMAT

3 REPLIES 3

scott_fischer2
Discoverer
0 Kudos
91

Take a look at this FM: SAP_CONVERT_TO_XLS_FORMAT

Former Member
0 Kudos
90

Hi!

Check this FM MS_EXCEL_OLE_STANDARD_DAT or SAP_CONVERT_TO_XLS_FORMAT

--

Raul Natu

Monsores
Active Participant
0 Kudos
90

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