topic Re: Heading Excel Sheet in Application Development and Automation Discussions

Heading Excel Sheet

Former Member — Thu, 05 Jun 2008 11:48:01 GMT

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 — Fri, 06 Jun 2008 08:50:59 GMT

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 — Fri, 06 Jun 2008 08:59:41 GMT

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 — Wed, 18 Mar 2009 05:26:39 GMT

Thanks