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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Export XLS files

Go to solution
Monsores
Active Participant

‎02-17-2011 1:09 PM

0 Kudos

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

Go to solution
scott_fischer2
Discoverer

‎02-17-2011 1:13 PM

0 Kudos

Take a look at this FM: SAP_CONVERT_TO_XLS_FORMAT

3 REPLIES 3

Go to solution
scott_fischer2
Discoverer

‎02-17-2011 1:13 PM

0 Kudos

Take a look at this FM: SAP_CONVERT_TO_XLS_FORMAT

Go to solution
Former Member

‎02-19-2011 12:10 AM

0 Kudos

Hi!

Check this FM MS_EXCEL_OLE_STANDARD_DAT or SAP_CONVERT_TO_XLS_FORMAT

--

Raul Natu

Go to solution
Monsores
Active Participant

‎02-28-2011 6:50 PM

0 Kudos

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