topic Re: Problem in uploading XL data in Application Development and Automation Discussions

Problem in uploading XL data

Former Member — Mon, 07 Apr 2008 17:21:41 GMT

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

Re: Problem in uploading XL data

Former Member — Mon, 07 Apr 2008 18:42:41 GMT

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)

Re: Problem in uploading XL data

Former Member — Tue, 08 Apr 2008 07:52:39 GMT

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

Re: Problem in uploading XL data

Former Member — Tue, 08 Apr 2008 08:09:40 GMT

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.

Re: Problem in uploading XL data

Former Member — Tue, 08 Apr 2008 10:57:55 GMT

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