topic Re: Header in Excel in Application Development and Automation Discussions

Header in Excel

Former Member — Fri, 07 Sep 2007 03:34:10 GMT

Hi Masters!!

I know this is simple to you all but im having a problem in downloading my summary report in excel. the header doesnt appear in excel only the item data.

could someone here help me.tnx.points will be given. I have 40 fields and not all of them are in type c.

Re: Header in Excel

gopi_narendra — Fri, 07 Sep 2007 03:37:04 GMT

Use the FM : GUI_DOWNLOAD

Check this sample code


    IT_HEADING-TEXT = 'Company Code'.
    append IT_HEADING.
    IT_HEADING-TEXT = 'RFQ Number'.
    append IT_HEADING.
    IT_HEADING-TEXT = 'RFQ Line Item'.
    append IT_HEADING.
    ................
    " You can fill in as many field headings

    call function 'GUI_DOWNLOAD'
      exporting
        FILENAME                = L_FNAME
        FILETYPE                = 'DAT'
      tables
        DATA_TAB                = IT_FINAL
        FIELDNAMES              = IT_HEADING
 " the parameter FIELDNAMES should be used to create the heading

Regards

Gopi

Re: Header in Excel

Former Member — Fri, 07 Sep 2007 03:39:53 GMT

Hi,

Using GUI_DOWNLOAD doesnt download header automatically.

You need to build the logic for the same.

Pass all the HEADER TEXTS to a internal table i_header1 & call gui_download.

ASSIGN PATH FOR FILE DOWNLOAD

l_file = par_unix1.

IF NOT i_header1 IS INITIAL.

DOWNLOAD DATA TO PRESENTATION SERVER

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

filename = l_file

filetype = 'ASC'

append = ' '
WRITE_FIELD_SEPARATOR = ' '
HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '

codepage = '8400'

IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
WK1_N_FORMAT = ' '
WK1_N_SIZE = ' '
WK1_T_FORMAT = ' '
WK1_T_SIZE = ' '
IMPORTING
FILELENGTH =

TABLES

data_tab = i_header1

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.

If not i_item[] is initial.

DOWNLOAD DATA TO PRESENTATION SERVER

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

filename = l_file

filetype = 'ASC'

append = 'X'

WRITE_FIELD_SEPARATOR = ' '
HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '

codepage = '8400'

IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
WK1_N_FORMAT = ' '
WK1_N_SIZE = ' '
WK1_T_FORMAT = ' '
WK1_T_SIZE = ' '
IMPORTING
FILELENGTH =

TABLES

data_tab = i_item

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.

ENDIF.

Re: Header in Excel

Former Member — Fri, 07 Sep 2007 03:43:41 GMT

good

when you r downloading your summary report into the excel select

list->export->Spreadsheet

than you save it in excel format,it ll display the header in the excel sheet,if you dont have header in your report output than it wont display in the excel sheet.

thanks

mrutyun^

Re: Header in Excel

Former Member — Fri, 07 Sep 2007 05:44:28 GMT

How would I declare it_heading?

I declare it as gv_heading type c.

there's an error that occur.

The data object "GV_HEADING" has no structure and therefore no

component called "TEXT". called "TEXT".

Pls. Reply