Former Member

May 20, 2008 at 09:39 PM

Download file from UNIX to EXCEL problem

102 Views

Hi,

I am trying to download file from UNIX server to excel file, there is one column which is messing up and that is number 100000000000000002 (18 in length) it is writing as 1E+17, funny thing is when I click on that cell it is showing as

100000000000000000.

I am using GUI_DOWNLOAD to download to excel, below is the output excel format, I am talking about 4th value from left

GUID leg_reg lic_type lic_num ex_lic_num vali_from valid_to created_by

3E633B85C05E6F28E100 EAR ENC 1E+17 ENC 20030305 20930305 VANRIJ

below is the program I am using to download the output from UNIX to excel

FORM get_data_file.

OPEN DATASET p_unxfil FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc = 0.

DO.

READ DATASET p_unxfil INTO input_file_tab-line_string.

IF sy-subrc <> 0.

EXIT.

ENDIF.

APPEND input_file_tab.

CLEAR input_file_tab.

ENDDO.

ELSE.

PERFORM write_message USING 'ZZ' 'E' '000'

'Unable to find file' p_unxfil

' Press Enter key to exit.' ''.

ENDIF.

CLOSE DATASET p_unxfil.

DESCRIBE TABLE input_file_tab LINES record_cnt.

ENDFORM. " get_data_file

_______________________________________

FORM create_pc_file.

DATA: l_file TYPE string.

MOVE p_pcfile TO l_file.

Save the file

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = l_file

TABLES

data_tab = input_file_tab

EXCEPTIONS

file_write_error = 1

no_batch = 2

gui_refuse_filetransfer = 3

invalid_type = 4

no_authority = 5

unknown_error = 6

header_not_allowed = 7

separator_not_allowed = 8

filesize_not_allowed = 9

header_too_long = 10

dp_error_create = 11

dp_error_send = 12

dp_error_write = 13

unknown_dp_error = 14

access_denied = 15

dp_out_of_memory = 16

disk_full = 17

dp_timeout = 18

file_not_found = 19

dataprovider_exception = 20

control_flush_error = 21

OTHERS = 22.

IF sy-subrc NE 0.

WRITE: / 'Error creating pc file', p_pcfile.

EXIT.

endif.

I will assure of points.

Thanks for your help

Sarath