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: 

Why am I seeing weird characters in AL11 excel file

siongchao_ng
Contributor
0 Kudos

Hi all,

I need to put an excel test file in one directory DIR_TEMP in AL11.

I use t-code CG3z to upload the excel file. I tried using both transfer format "BIN" as well as "ASC".

Basically the excel file contains 1 header and i line of information as below:

PERNR NAME SUBTY BEGDA ENDDA ANZHL BETRG ZEINH ZUORD

8000001 Test Employee 2154 8/1/2011 12/31/9999 800 F888

I manage to upload it but when I open the file in AL11, I am getting gibberish characters:

PK##########!#q#9+p### #####Û#[Content_Types].xml ¢×#( ####################################################################################################################################

P#TÒ##DQ4ï½ùfìé [#d##µ³9#g####Ni»ÌÙëËCzÍ##Â*a###í#Ù v~6}ÙyÀ#ª-æ¬#Ñßp#²#J`æ<XúS¸P#H#aɽ#+±#>##®¸t6##i¬5ØlúD##V#,D##¢"#¾5<#

For your further info, I tried saving as .dat and .csv/ and also .xls but no avail.

Anyone knows anything about this?

1 REPLY 1

mithun_shetty4
Contributor
0 Kudos

When u uploaded the file did u remove WORDWRAP from the file and uploaded ! sometimes the End of the record will be present in the wrong place