topic Re: GUI_DOWNLOAD Problem in Application Development and Automation Discussions

GUI_DOWNLOAD Problem

Former Member — Thu, 20 Aug 2009 07:47:57 GMT

Hi,

I am using GUI_DOWNLOAD FM to download my internal table entries into .xls file. It is downloading the file to my local system. But it is not saving in plain .xls file.

Most of the times, the excel file will be downloaded, converted to tab delimited text file. But I need it as a plain .xls file.

Because my client needs to modify the same file and uses to upload it. But they are unable to modify it. It is throwing error like "the document is not compatable with text(tab delimeter)".

Please help me on this situation...

Regards

Ramesh.

Re: GUI_DOWNLOAD Problem

Former Member — Thu, 20 Aug 2009 07:57:53 GMT

HI,

You can use Concatenate statement before using GUI_DOWNLOAD

function module.Kindly check the sample code below:



  data: v_path     type rlgrap-filename,
        v_pathname type string         .

*func mod to select path for downloading file
 call function 'KD_GET_FILENAME_ON_F4'
exporting
program_name        = syst-repid
dynpro_number       = syst-dynnr
*       FIELD_NAME          = ' '
*       STATIC              = ' '
*       MASK                = ' '
changing
file_name           = v_path
exceptions
mask_too_long       = 1
others              = 2
                           .
if sy-subrc <> 0.
message id sy-msgid type sy-msgty number sy-msgno
with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
endif.

*assigning path value to another var to be passed in gui_download
v_pathname = v_path.


*if user gives the value in path var then only download will be called
if v_pathname is not initial.

*TO CONCATENATE EXTENSION WITH THE FILE PATH NAME
concatenate v_pathname '.xls' into v_pathname.

call function 'GUI_DOWNLOAD'
exporting
*   BIN_FILESIZE                    =
    filename                        = v_pathname
    filetype                        = 'ASC'
    append                          = 'X'
    write_field_separator           = 'X'
*   HEADER                          = '00'
*   TRUNC_TRAILING_BLANKS           = 'X'
*   WRITE_LF                        = 'X'
*   COL_SELECT                      = ' '
*   COL_SELECT_MASK                 = ' '
*   DAT_MODE                        = ' '
*   CONFIRM_OVERWRITE               = ' '
*   NO_AUTH_CHECK                   = ' '
*   CODEPAGE                        = ' '
*   IGNORE_CERR                     = ABAP_TRUE
*   REPLACEMENT                     = '#'
*   WRITE_BOM                       = ' '
*   TRUNC_TRAILING_BLANKS_EOL       = 'X'
   wk1_n_format                    = '22'
   wk1_n_size                      = '18'
*   WK1_T_FORMAT                    = ' '
*   WK1_T_SIZE                      = ' '
* IMPORTING
*   FILELENGTH                      =
    tables
    data_tab                        = <dyn_table>
*   FIELDNAMES                      =
  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 <> 0.
message id sy-msgid type sy-msgty number sy-msgno
with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
endif.

endif.

clear: v_pathname, v_path.

Hope it helps

Regards

Mansi

Re: GUI_DOWNLOAD Problem

Former Member — Thu, 20 Aug 2009 08:01:53 GMT

Hello,

You can try using XXL_FULL_API function module. It will download the abap data into xls with full details.

also, you can try one more function module:

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

I_FIELD_SEPERATOR =
I_LINE_HEADER =

I_FILENAME =

I_APPL_KEEP = ' '

TABLES

I_TAB_SAP_DATA =

CHANGING
I_TAB_CONVERTED_DATA =
EXCEPTIONS
CONVERSION_FAILED = 1
OTHERS = 2

Hope this resolves your issue.

Thanks,

Augustin.

Re: GUI_DOWNLOAD Problem

Former Member — Thu, 20 Aug 2009 08:17:10 GMT

Hi ,

Try using FM

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

this will help u

regards

Prashant

Re: GUI_DOWNLOAD Problem

Former Member — Thu, 20 Aug 2009 08:46:02 GMT

Hi,

Use the function module

SAP_CONVERT_TO_XLS_FORMAT

Here is a sample code:

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
             EXPORTING
*              I_FIELD_SEPERATOR          =
*              I_LINE_HEADER              =
               i_filename                 = '<<File-Path>>>
*              I_APPL_KEEP                = ' '
             tables
               i_tab_sap_data             =<Table-Name>
*            CHANGING
*              I_TAB_CONVERTED_DATA       =
*            EXCEPTIONS
*              CONVERSION_FAILED          = 1
*              OTHERS                     = 2
                     .
           IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
           ENDIF.

Hope this solves the issue.

Regards,

Rajani

Re: GUI_DOWNLOAD Problem

Former Member — Thu, 20 Aug 2009 10:24:20 GMT

Thanks to All...

The FM is working fine but it is not writing the COLUMN (HEADING) Names...do needful on this.

Regards,

Ramesh.

Re: GUI_DOWNLOAD Problem

kesavadas_thekkillath — Thu, 20 Aug 2009 10:28:52 GMT

check exporting parameter I_LINE_HEADER

Re: GUI_DOWNLOAD Problem

faisalatsap — Thu, 20 Aug 2009 10:32:24 GMT

Hi, Ramesh

Test my Sample Code in the [This Link|] hope it will solve out your problem,

Best Regards,

Faisal