topic Re: Header in EXCEL Sheet in Application Development and Automation Discussions

Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 04:33:19 GMT

Hi all,

I'm trying to download the file into excel sheet getting data into excel but header is missing in SAP4.7 version , when i check my code in ECC6.0 then the header is coming. Below is my code.

TYPES: BEGIN OF it_int,

sales(3) TYPE n,

name(30) TYPE c,

END OF it_int.

DATA: t_int TYPE STANDARD TABLE OF it_int,

fs_int TYPE it_int.

DATA:

BEGIN OF t_header OCCURS 0,

header(50) TYPE c,

END OF t_header.

fs_int-sales = 001.

fs_int-name = 'Urea'.

APPEND fs_int TO t_int.

CLEAR fs_int.

fs_int-sales = 002.

fs_int-name = 'Ammonia'.

APPEND fs_int TO t_int.

CLEAR fs_int.

t_header-header = 'Sales'.

APPEND t_header.

t_header-header = 'ItemName'.

APPEND t_header.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename =

'C:\SAELS.xls'

filetype= 'ASC'

append = 'X'

write_field_separator = 'X'

TABLES

data_tab = t_int

fieldnames = t_header.

What needs to be done to get header in SAP4.7 version ?

Thanks in Advance.

Regards

VENk@

Re: Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 04:50:35 GMT

This message was moderated.

Re: Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 04:50:51 GMT

This message was moderated.

Re: Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 05:15:19 GMT

HI I have already gone through the given sites but no use.

Regards

VEnk@

Re: Header in EXCEL Sheet

GauthamV — Fri, 19 Mar 2010 05:25:35 GMT

Check if you were able to download the same to a txt file in 4.7 version.

I don't have the 4.7 version now to check it.

Re: Header in EXCEL Sheet

venkat_o — Fri, 19 Mar 2010 05:26:31 GMT

Hi Venkat reddy, <li>Try this way .I tried to change your program. it works


REPORT ztest.
TYPES: BEGIN OF it_int,
        sales(3) TYPE n,
        name(30) TYPE c,
       END OF it_int.

DATA: t_int TYPE STANDARD TABLE OF it_int,
      fs_int TYPE it_int.

DATA:BEGIN OF t_header OCCURS 0,
        field1(50) TYPE c,
        field2(50) TYPE c,
     END OF t_header.

fs_int-sales = 001.
fs_int-name = 'Urea'.
APPEND fs_int TO t_int.
CLEAR fs_int.
fs_int-sales = 002.
fs_int-name = 'Ammonia'.
APPEND fs_int TO t_int.
CLEAR fs_int.

t_header-field1 = 'Sales'.
t_header-field2 = 'ItemName'.
APPEND t_header.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    filename              = 'C:\SAELS.xls'
    filetype              = 'ASC'
*    append                = 'X'
    write_field_separator = 'X'
  TABLES
    data_tab              = t_header.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    filename              = 'C:\SAELS.xls'
    filetype              = 'ASC'
    append                = 'X'
    write_field_separator = 'X'
  TABLES
    data_tab              = t_int.

Thanks Venkat.O

Re: Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 05:35:55 GMT

HI,

I have tried this to download in text file but didnt worked.

Regards

VEnk@

Re: Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 05:38:27 GMT

HI Venkat,

Its almost reached but not correctly, I'm Getting SALES and ITEMNAME in the same line i need to be in 2 different columns.

Any suggestions.

REgards

VEnk@

Re: Header in EXCEL Sheet

venkat_o — Fri, 19 Mar 2010 05:41:56 GMT

Hi Venkat, <li>I dont know whether you copied portion of code or executed the code i pasted. But try to copy the code I changed and paste it. Its absolutely working. Thanks Venkat.

Re: Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 05:47:32 GMT

HI Venkat,

Its working fine thks for a good concept. When i'm trying to assign marks to you its getting error as "An error has occured while assigning makrs. Please refresh the thread view and try again.

". Also one more question from me can we use this GUI_DOWNLOAD to schedule in background and generate excel sheet in the back ground.

Regards

VEnk@

Re: Header in EXCEL Sheet

GauthamV — Fri, 19 Mar 2010 05:49:21 GMT

You cannot use GUI function modules in background.

Re: Header in EXCEL Sheet

venkat_o — Fri, 19 Mar 2010 05:50:17 GMT

Hi Venkat, <li>We can not use any GUI* Function in background processing. Thanks Venkat.O

Re: Header in EXCEL Sheet

Former Member — Fri, 19 Mar 2010 05:53:48 GMT

Ok VEnk@ and Gautham can u suggest me which F.M shall i use to generate a EXCEL sheets in the background.

Regards

VEnk@

Re: Header in EXCEL Sheet

praveen_hannu — Fri, 19 Mar 2010 05:57:13 GMT

In background you cant save any file on local pc. You need to create the file in application server.

Using data sets, from there onwards, you can download anything to your local machine.

Re: Header in EXCEL Sheet

GauthamV — Fri, 19 Mar 2010 05:59:51 GMT

[Download excel in background|http://www.sap-img.com/abap/download-in-background-in-excel-format.htm]

This is one approach which you can try.

Re: Header in EXCEL Sheet

Former Member — Mon, 22 Mar 2010 08:01:12 GMT

Answered