Problem in uploading XL data

[Former Member]

Hi,

We are trying to use the class->method CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD for reading data in an XL sheet. The data read into the internal table consists of junk characters instead of the proper XL sheet content.

We have tried creating the internal table of a custom type structure and also as of type string. It doesnt work in either ways.

Any suggestions on the same?

Thanks,

Prasath N

Edited by: Prasath Natesan on Apr 7, 2008 10:52 PM

[Former Member]

using simply a GUI_UPLOAD bring the data up unformatted. what you see is essntially what you would see if you brought a XLS up in wordpad or something like that. the data is formatted. You should use one of the function modules specifically set up for reading excel.

Something like CL_UA_EXCEL_TOOLS (object) or ALSM_EXCEL_TO_INTERNAL_TABLE (FM)

[Former Member]

using simply a GUI_UPLOAD bring the data up unformatted. what you see is essntially what you would see if you brought a XLS up in wordpad or something like that. the data is formatted. You should use one of the function modules specifically set up for reading excel.

Something like CL_UA_EXCEL_TOOLS (object) or ALSM_EXCEL_TO_INTERNAL_TABLE (FM)

[Former Member]

Hi,

Thanks for your reply.

We are on a CRM system and these function modules does not exist here. Can someone let me know if there are similar function modules in CRM?

Thanks,

Prasath N

[Former Member]

To Rectify the problem, you have one option. Save the XL file as Tab Delimited file. then use the Method.

use HAS_FIELD_SEPARATOR = 'X' while calling method. it will work.

[Former Member]

Thanks that works perfectly.

One more question. We have certain special characters in our XL sheet for example characters like å, ä, Ö, These special characters are replaced by the symbol " when we upload it. Is there a way to retrieve these characters properly?

Thanks,

Prasath N