Problem reading excel cell which has 1000 characters

[Former Member]

Hello Frnds,

I am reading an excel file , i have declared my internal table with fields of length 1000 characters each. But it is holding only 256 characters in a field ( where that cell has 1000 chars in excel ) in the internal table and i want all the 1000 chars to be stored in internal table . Is there any way to get all the 1000 chars in to the internal table field ? please suggest on this ?

Thanks,

subash

[Former Member]

Hello Frnds,

I am reading an excel file , i have declared my internal table with fields of length 1000 characters each. But it is holding only 256 characters in a field ( where that cell has 1000 chars in excel ) in the internal table and i want all the 1000 chars to be stored in internal table . Is there any way to get all the 1000 chars in to the internal table field ? please suggest on this ?

Thanks,

subash

[Former Member]

structures can keep these long data but tables cannot

[Former Member]

Hi,

Declare the fields of the internal table as string, since its length is not fixed,it can hold any number of characters.

Use FM TEXT_CONVERT_XLS_TO_SAP while uploading.

Regards,

Amit

[GauthamV]

Hello subash,

Instead of using Excel use a text tab-delimited file for FM GUI_UPLOAD .

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = p_file
filetype = 'ASC'
has_field_separator = 'X'
TABLES
data_tab = itab
EXCEPTIONS
file_open_error = 1
file_read_error = 2
no_batch = 3
gui_refuse_filetransfer = 4
invalid_type = 5
no_authority = 6
unknown_error = 7
bad_data_format = 8
header_not_allowed = 9
separator_not_allowed = 10
header_too_long = 11
unknown_dp_error = 12
access_denied = 13
dp_out_of_memory = 14
disk_full = 15
dp_timeout = 16
OTHERS = 17.

[Former Member]

Hi GADDAMEEDI SUBASH,

What Data Type you are using while declaring the internal table.. ??

I would suggest you to increase the field length of the internal table fileld which stores this string

OR

Use String or LRAW data type.. Depends on your requirement..

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya