topic Help please in Application Development and Automation Discussions

Help please

Former Member — Tue, 17 Jul 2007 07:04:53 GMT

Hi all,

To use the gui_upload I have to save the Excel file as Text Tab DeLimited file .... can anyone please tell me how to save it as Text Tab DeLimited.

Thanks

Former Member — Tue, 17 Jul 2007 07:06:49 GMT

Hi,

Goto Save as option and in the extension, instead of .xls either give .txt then it will be saved as a notepad file.

Or in the options there will be an option Microsoft Excel Workbook(Tab-delimited)

Regards,

Himanshu.

Former Member — Tue, 17 Jul 2007 07:07:40 GMT

Use GUI_UPLOAD FM with your internal table and mark the 'FIELD SEPARTOR' parameter to 'X'.

This will give a tab delimited file to the presentatios server.

e.g

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = lcl_filename

filetype = 'ASC'

write_field_separator = 'X'

TABLES

data_tab = download_table

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.

Regards