Download file from UNIX to EXCEL problem

[Former Member]

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

[naimesh_patel]

It is not the problem of your program. This happens becuase of the "nature" of the excel. You need to retain the text property of that column.

Try like this:

1. Download the file in .txt

2. Open Excel .. blank sheet

3. Now, click on Open. Select your .txt file

4. One pop up will come ..."Text Import Wizard"

5. Select the fixed width or Delimited ... Press Next ...

6. Select appropriate delimitors or fixed length .. press Next

7. Select your coulumn (which has the problem), Select the "Text" radiobutton on the upper-right corner and finish.

Regards,

Naimesh Patel