What is 'Separator' for Excel (.xls ext) file to upload into Itab From PS??

[former_member182350]

Hi Experts,

I would like to know the what is the '<b>"separator</b>" used for to upload '.xls' extension file directly into <b>Internal table From Presentation Server</b>?? by using 'GUI_UPLOAD' FM or 'CL_GUI_FRONTENDSERVICES=>GUI_UPLOAD' METHOD in the SAPCRM system only.

Or tell me another way if it is there.?

Can anybody help me in this regard?

Regards,

Arjun

[former_member182350]

What is 'Field Separator' for Excel (.xls ext) file to upload into Itab??

1. You can try giving the field seperator as '#'. I guess it would work.

2. You could use use either a tab \t or comma , in a plain text file.

If you use the comma, read the data into a table with one field big enough to contain the whole line. Then splitting that line by split command.

SPLIT dobj AT sep INTO

{ {result1 result2 ...} | {TABLE result_tab} }

[IN {BYTE|CHARACTER} MODE].

You may find that a tab will be able to go straight into a table. Do a couple of tests.

If you are using a binary xl formatted file there may be another way.

There should be plenty of other help on this... did you search?

3. Look the attributes in the class CL_ABAP_CHAR_UTILITIES.

Hope it will help

Regards,

Arjun

[former_member182350]

Answered

[Former Member]

Hi Arjun,

What is the answer ? I am trying to read excel in CRM and GUI_UPLOAD is not working Do U know the solution