Heading Excel Sheet

[Former Member]

Hi

I want to output the some data to excel sheet.

But my requirement is that it should be displayed in such manner that first line should have the Heading i.e Name of the Excel Sheet.

Skip the second Row (empty)

In new Row : Again some data(text) skip some coloumns Data

in say G column.

Then the internal data ( which i am able to get)

I need only the data before the Internal Data output :

Eg:

ABC COMPANY LTD 12 Mar 08

BANK NAME Ref no: ###

[Former Member]

Hi Friend,

Which function module you are using....

In ALSM_EXCEL_INTERNAL_TABLE we have option from which to which row you wan to fetch from file.

try with that.

Regards

Krishnendu

[piyush_mathur]

Hi Dude...

Best way...Create on internal atbel with data type string.

Now first add you first line header.

After that append blank line.

Noe again append second header.

After that append blank line.

Aftet this loop on your internal table which contain date and pass the data into above internal table and download using GUI_DOWNLOAD FM.

Thanks

Piyush Mathur

[Former Member]

Thanks