topic Re: encoding problem in xls in Application Development and Automation Discussions

encoding problem in xls

balamurugan_ramakrishnan — Fri, 12 Dec 2008 08:02:17 GMT

Hi All,

I have to read information from a txt file, which contains Greek language/characters.

Using gui_upload it is uploading and displaying some other character.

How to read from the txt file which should return the Greek character.

Advance thanks,

Balamurugan.R

Re: encoding problem in xls

Former Member — Fri, 12 Dec 2008 08:18:59 GMT

Pass the codepage value wrt the language which you are uploading :

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
CODEPAGE = V_CODEPAGE
..........
..........

While saving the file in Notepad.. when you click on SAVE AS .. in ENCODING pass Unicode

Best regards,

Prashant

Re: encoding problem in xls

tarangini_katta — Fri, 12 Dec 2008 08:28:32 GMT

Hi,

While ur saving the file save it is NON_unicode.

Then it will work for you.

Like this i have solved my pblm.

Thanks,

Re: encoding problem in xls

Former Member — Fri, 12 Dec 2008 08:35:46 GMT

Hi...

I dont think so its an encoding problem....may be the problem is with ur tabs in the text file..just check the tabs again and then try and upload file..see what is being uploaded in your internal table though file while debugging

thanks

Re: encoding problem in xls

SuhaSaha — Fri, 12 Dec 2008 08:39:06 GMT

Hello Bala,

I agree with the solution Prashant provided, you must use the addition CODEPAGE in GUI_UPLOAD func. module.

For Greek characters the SAP Codepage is 1704. You should try having a look @ SAP Note 73606.

Hope this helps.

BR,

Suhas

Re: encoding problem in xls

tarangini_katta — Fri, 12 Dec 2008 08:52:10 GMT

HI Suhas,

If bala is using unicode system it doesn#t matter by specifying code page as i suppose.

Because unicode system has to accept all the codepages.

so beeter to save the file in non unicoefformat.

Thanks,

Re: encoding problem in xls

balamurugan_ramakrishnan — Fri, 12 Dec 2008 10:03:30 GMT

Hi Suhas,

Thank you. It is working.

I am generating xls file and attach it for mail using FM

SO_NEW_DOCUMENT_ATT_SEND_API1 .

The Polish language symbol not appearing in XLS file.

what to do.

Thanks

Balamurugan.R

Re: encoding problem in xls

balamurugan_ramakrishnan — Fri, 12 Dec 2008 11:26:04 GMT

Good.