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

List in Excel

Former Member — Tue, 30 May 2006 08:23:18 GMT

Hi all,

Can any one tell me the function module to display

my output list in Excel.

and

How can i set the path for excel sheet globally.i.e.,where ever may be the excel sheet but the

data should get into that.

Thanks,

-Reddy.

Re: List in Excel

Former Member — Tue, 30 May 2006 08:27:05 GMT

go though this link u got lots of idea....

Re: List in Excel

Former Member — Tue, 30 May 2006 08:27:10 GMT

chk this

RH_START_EXCEL_WITH_DATA

Re: List in Excel

Former Member — Tue, 30 May 2006 08:29:30 GMT

Hi,

I think ur looking for desktop integration ;

Please Refer this link it contains complete details for it.

download the PDF ; its very good

OLE

http://www.sapgenie.com/abap/ole.htm

http://help.sap.com/saphelp_46c/helpdata/en/59/ae3f2e488f11d189490000e829fbbd/frameset.htm

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCIOFFI/BCCIOFFI.pdf

http://help.sap.com/saphelp_47x200/helpdata/en/59/ae3cac488f11d189490000e829fbbd/content.htm

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE6/BCFESDE6.pdf

Re: List in Excel

Former Member — Tue, 30 May 2006 08:30:01 GMT

Try GUI_DOWNLOAD

Re: List in Excel

Former Member — Tue, 30 May 2006 08:34:25 GMT

Hi,

check this sample code...

REPORT  ZTEST_EXCEL                   .

 

INCLUDE ole2incl.

DATA: application TYPE ole2_object,

       workbook TYPE ole2_object,

       sheet TYPE ole2_object,

       cells TYPE ole2_object.

CONSTANTS: row_max TYPE i VALUE 256.

DATA index TYPE i.

 

DATA: BEGIN OF itab1 OCCURS 0,

 first_name(10),

 last_name(10),

 END OF itab1.

 

 

START-OF-SELECTION.
 itab1-first_name = '123445'.
 itab1-last_name = 'tesst'.
 append itab1.
 clear itab1.

 

 itab1-first_name = '123446'.
 itab1-last_name = 'tesst'.
 append itab1.
 clear itab1.

 

  CREATE OBJECT application 'excel.application'.
  SET PROPERTY OF application 'visible' = 1.
  CALL METHOD OF application 'Workbooks' = workbook.
  CALL METHOD OF workbook 'Add'.

 

* Create first Excel Sheet

  CALL METHOD OF application 'Worksheets' = sheet

                               EXPORTING #1 = 1.

  CALL METHOD OF sheet 'Activate'.
  SET PROPERTY OF sheet 'Name' = 'Sheet1'.

  LOOP AT itab1.
    index = row_max * ( sy-tabix - 1 ) + 1. " 1 - column name
    CALL METHOD OF sheet 'Cells' = cells EXPORTING #1 = index.
    SET PROPERTY OF cells 'Value' = itab1-first_name.
        index = index + 1. " 1 - column name
    CALL METHOD OF sheet 'Cells' = cells EXPORTING #1 = index.
    SET PROPERTY OF cells 'Value' = itab1-last_name.
  ENDLOOP.


* Save excel speadsheet to particular filename

  CALL METHOD OF sheet 'SaveAs'

                  EXPORTING #1 = 'c:tempexceldoc1.xls'     "filename

                            #2 = 1.                          "fileFormat

Regards

vijay

Re: List in Excel

Former Member — Tue, 30 May 2006 09:30:40 GMT

thank u for your source code vijay.