Avoid Pop-Up message for .XLS message when downloading from Application server

[former_member700189]

My requirement is to send payment data in .xls format to application server

from there the user downloads and upload in bank server(which accpets only .xls format)

i tried with horizontal tab and we are getting file - but when opening the file there is a popup coming as warning " excel cannot open the file, because file may be corrupted"

Steps i followed

• Prepared one internal table with actual data
• Prepared final table with headings and actual data with horizontal tab (#) separated
• Used OPEN DATASET p_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

we need to upload .xls file to application server and user wants to open the .xls file without any popup warning

Please help!!

Regards,

[FredericGirod]

Change extension to .CSV

[former_member700189]

We have shared the .CSV file, but at their end, only .xls is acceptable, please suggest if there is any other way..

[johnnbc]

To be clear - you are uploading to a bank server which expects Excel file format, but you are uploading in plain text?

You probably need to upload in Excel format (not just calling it .xls) - particularly if there are further dependencies downstream.

[matt]

From the comments, he seems to think he's upload xls because that's the file extension. It's amazing how often people think computers work by magic!

[Sandra_Rossi]

It's not a SAP problem, so it's discussed in all the Web for any programming language. You must not give a given extension if the internal format of your file doesn't match that extension. In your case, you say it's XLS format, but your internal format is not XLS.

Why do they want only XLS extension???

If they understand that you must spend more time to just have "not CSV", ask them if XLSX is possible, and ask them if they are ready to install abap2xlsx? Otherwise, it will be a lot of trouble.

[matt]

Horizontal tab separated is not xls. No matter how you name your file it will never be xls. In the same way, you could name it .pdf and it still won't be a valid pdf.