topic Fetching long string from excel sheet. in Application Development and Automation Discussions

Fetching long string from excel sheet.

Former Member — Mon, 01 Jun 2009 03:33:09 GMT

Hello experts,

I wish to fetch a text from an excl sheet that is very long. I used FM "TEXT_CONVERT_XLS_TO_SAP"

but it fetches only 256 characters of that text into the internal table.

I want all the text to be copied into internal table filed. I used string type and also edidd-sdata (1000 char). But that wont work as the FM itself isnt fetching all the text.

Please suggest some solution except to change the FM.

Thanks and regards!

Sumit Nene

Re: Fetching long string from excel sheet.

faisalatsap — Mon, 01 Jun 2009 03:39:07 GMT

Hi, Sumit

Have you tried FM GUI_UPLOAD ? Hope will help you to solve out your problem,

Best Regards,

Faisal

Re: Fetching long string from excel sheet.

Former Member — Mon, 01 Jun 2009 07:56:52 GMT

The FM TEXT_CONVERT_XLS_TO_SAP use internaly a filed with maximum length 256 to read cells fromo XLS for that reason you get only 256 characters. To correct that split the long excel cell to more cells or try to download as text file and to upload it them into sap

Re: Fetching long string from excel sheet.

Former Member — Tue, 02 Jun 2009 07:47:37 GMT

problem solved.

fm ALSM_EXCEL_TO_INTERNAL_TABLE doesnt work here as maximum length of field it takes is 50 chars and for TEXT_CONVERT_XLS_TO_SAP it takes 256 chars.

i used gui_upload fm which takes text of any length but had to use a tab delimited file..

Thank you all for your suggestions.

Regards.

Sumit Nene