topic Re: internal table to excel in Application Development and Automation Discussions

internal table to excel

Former Member — Mon, 09 Jan 2006 12:57:29 GMT

Hi,

See the below code and can any one pls tell me what is that i writing wrong here. What i want to do is If the check box is checked, i want to download the data to excel sheet.

also tell me if there are any other parameters to be filled in the function module.


DATA: v_file type string.

DATA : BEGIN OF it_excelhead OCCURS 0,
         colname(40),
        END OF it_excelhead.

PARAMETER:  p_check AS CHECKBOX DEFAULT ' ',
            p_file LIKE rlgrap-filename DEFAULT 'c:'.



  IF p_check = 'X'.
    PERFORM prepare_excel_header.
    MOVE p_file TO v_file.

    CONCATENATE p_file '.xls' INTO v_file.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    filename                        = v_file
   FILETYPE                        = 'ASC'
  tables
    data_tab                        = i_final1
    FIELDNAMES                      = it_excelhead.
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.

Re: internal table to excel

Former Member — Mon, 09 Jan 2006 13:03:18 GMT

Hi,

Please change the 'ASC' to 'BIN'.Hope This Info Helps YOU.

Reward Points If It Helps YOU.

Regards,

Raghav

IF p_check = 'X'.

PERFORM prepare_excel_header.

MOVE p_file TO v_file.

CONCATENATE p_file '.xls' INTO v_file.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = v_file

FILETYPE = 'BIN'

tables

data_tab = i_final1

FIELDNAMES = it_excelhead.

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.

Re: internal table to excel

Former Member — Mon, 09 Jan 2006 13:05:17 GMT

Hi Hema,

you have build a flat file,

try to put a txt extension and open it with a txt editor.

for creating an excel file there is a fm.

As soon as i put it there,

bye

enzo

Re: internal table to excel

Former Member — Mon, 09 Jan 2006 13:05:50 GMT

Why don't you use fm XXL_SIMPLE_API?

Fo XL files this is the best

Re: internal table to excel

Former Member — Mon, 09 Jan 2006 13:09:04 GMT

Hi ,

Please use below FM to download data

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

EXPORTING

FILE_NAME = LV_FILE1

DATA_SHEET_NAME = 'SUMMARY'

TABLES

DATA_TAB = IT_EXCEL_SUMMARY

EXCEPTIONS

FILE_NOT_EXIST = 1

FILENAME_EXPECTED = 2

COMMUNICATION_ERROR = 3

OLE_OBJECT_METHOD_ERROR = 4

OLE_OBJECT_PROPERTY_ERROR = 5

INVALID_FILENAME = 6

INVALID_PIVOT_FIELDS = 7

DOWNLOAD_PROBLEM = 8

OTHERS = 9.

IF SY-SUBRC <> 0.

ENDIF.

Reward points If information is helpful

Regards

Amole

Re: internal table to excel

Former Member — Mon, 09 Jan 2006 13:11:41 GMT

HI.

try this FM.

MS_EXCEL_OLE_STANDARD_DAT .

In this FM, the header can also be given separately.

Thanks,

Maheshwari.V

Re: internal table to excel

Former Member — Mon, 09 Jan 2006 13:24:11 GMT

Hi i dont think using gui_download is a good option for handling Excel file.

Try this one out: SAP_CONVERT_TO_XLS_FORMAT

Re: internal table to excel

Former Member — Mon, 09 Jan 2006 14:19:32 GMT

Hi Hema,

Pass the exporting parameter WRITE_FIELD_SEPARATOR as 'X' for GUI_DOWNLOAD and it should work...

Regards,

Srikanth