topic Re: Export XLS files in Application Development and Automation Discussions

Export XLS files

Monsores — Thu, 17 Feb 2011 13:09:38 GMT

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.

Re: Export XLS files

scott_fischer2 — Thu, 17 Feb 2011 13:13:51 GMT

Take a look at this FM: SAP_CONVERT_TO_XLS_FORMAT

Re: Export XLS files

Former Member — Sat, 19 Feb 2011 00:10:35 GMT

Hi!

Check this FM MS_EXCEL_OLE_STANDARD_DAT or SAP_CONVERT_TO_XLS_FORMAT

Raul Natu

Re: Export XLS files

Monsores — Mon, 28 Feb 2011 18:50:41 GMT

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