tab delimited XLS file attached to an email - 'recognizable format'

[Former Member]

The customer wants a tab delimited XLS file attached to an email. I have used the classes cl_bcs,cl_document_bcs

cl_gbt_multirelated_services and function SO_DOCUMENT_SEND_API1 to send the XLS file. At this time, I am able to view the contents of the file. However, I keep on getting the message 'The file is not in a recognizable format' before opening the file in excel.Any suggestion?

Fyi.. This message occurs with all versions of excel.

Thanks

[Former Member · Accepted solution]

Hi Chris,

There is an SAP Note that needs to be implemented to fix this error ( sorry I didn't have the note number at the moment ). But here is the solution...

Change the entry in the table TSCOPE for the entry FILE_EXT = XLS, the ASCII_TYPE for this entry should be X.

It worked for me

Regards,

Trikanth Basetty

[Former Member · Accepted solution]

Trikanth,

Thanks for the help... Your fix did it!!

Chris

[balamurugan_ramakrishnan · Accepted solution]

Hi Trikanth,

I am using ECC6. , there is no table called TSCOPE. where to fix it.

Thanks,

Balamurugan.R

[balamurugan_ramakrishnan · Accepted solution]

Hi Chris,

I am using ECC6. , there is no table called TSCOPE. How to fix the problem.

Thanks,

Balamurugan.R

[Former Member · Accepted solution]

Hi!

Check Note 1151258 - Error when sending Excel attachments

This will help!

Csaba

[Former Member]

Hi,

If you change the extention name the you will get the message.

Anil

[markus_doehr2]

Try to rename the file as "csv" and try again.

Markus