Download data to excel

[Former Member]

Hi,

Is it possible to download the output of a test script or configuration to a excel or text file. If possible,please tell me the steps.

Thanks,

Aparna.

[rodrigo_paisante3]

Hi,

See this thread, it help you in your question.

Regards

[Former Member]

Hi Aparna,

Please follow the below steps to download variants.

1)Go to transaction SECATT.

2)Choose the Test Configuration.

3)From the Menu-Edit-Download variants.

4)You can choose the location on where to download.

5)It will be stored in the form of text file.

6)You can open the text file and edit values/open the file using excel and edit values without changing the format.

7)You can again upload the variants and save it test configuration.

Hope this solves your query.

Regards,

Senthil.

[Former Member]

Hello ,

As per my knowledge its not possible to store the log information into an external file , however the log itself can be archived by selecting the archiving option.

As the logs are deleted every biweekly the executed logs disappears after sometime , so if you need the logs to view for future reference then go to the log then to Edit option and select Archiving On/Off option. Once set you will get the message saying Archiving On.

Thus log will be avaliable for future refrence.

Hope it answers your question.

Thanks and Best regards,

Ajay

[Vny12]

Hi all,

we can store the log for future reference in a local file

In a TXT file or HTML...etc...etc...

1.Goto log which you are interested to download,

2.Menu -> Log display -> print preview.

3.In print preview screen..Select menu path.

System->List->save->Local file...

choose the format

save and enjoy...

regards

vinay

[Former Member]

Hi,

Check the following link:

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

Regards,

Anki Reddy.

[Former Member]

Check out this link..

it may help you..

-

---

check fhis function module

EXCEL_OLE_STANDARD_DAT

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

EXPORTING

file_name = filename

• CREATE_PIVOT = 0

• DATA_SHEET_NAME = ' '

• PIVOT_SHEET_NAME = ' '

• PASSWORD = ' '

• PASSWORD_OPTION = 0

TABLES

• PIVOT_FIELD_TAB = PIVOT_FIELD_TAB

data_tab = it_final1[]

fieldnames = heading

EXCEPTIONS

file_not_exist = 1

filename_expected = 2

communication_error = 3

ole_object_method_error = 4

ole_object_property_error = 5

invalid_pivot_fields = 6

download_problem = 7.

in DATA_SHEET_NAME you can pass sheet no dynamically.

try it it will work.

-

---

***************************************************************************

***************************************************************************

REPORT ZOLE_TUTOR_EXAMPLE_MS_EXCEL NO STANDARD PAGE HEADING.

***************************************************************************

***************************************************************************

*****************************

INITIALIZATION.

*****************************

TABLES : SCARR , SPFLI , SFLIGHT.

INCLUDE OLE2INCL .

DATA: GS_EXCEL TYPE OLE2_OBJECT ,

GS_WBOOKLIST TYPE OLE2_OBJECT ,

GS_APPLICATION TYPE OLE2_OBJECT ,

GS_WBOOK TYPE OLE2_OBJECT ,

GS_ACTIVESHEET TYPE OLE2_OBJECT ,

GS_SHEETS TYPE OLE2_OBJECT ,

GS_NEWSHEET TYPE OLE2_OBJECT ,

GS_CELL1 TYPE OLE2_OBJECT ,

GS_CELL2 TYPE OLE2_OBJECT ,

GS_CELL3 TYPE OLE2_OBJECT ,

GS_CELL4 TYPE OLE2_OBJECT ,

GS_CELL5 TYPE OLE2_OBJECT ,

GS_CELL6 TYPE OLE2_OBJECT ,

GS_CELLS TYPE OLE2_OBJECT ,

GS_RANGE TYPE OLE2_OBJECT ,

GS_FONT TYPE OLE2_OBJECT ,

GS_INTERIOR TYPE OLE2_OBJECT ,

GS_COLUMNS TYPE OLE2_OBJECT ,

GS_CHARTS TYPE OLE2_OBJECT ,

GS_CHART TYPE OLE2_OBJECT ,

GS_CHARTTITLE TYPE OLE2_OBJECT ,

GS_CHARTTITLECHAR TYPE OLE2_OBJECT ,

GS_CHARTOBJECTS TYPE OLE2_OBJECT .

DATA : CNTL TYPE I VALUE 0.

DATA GV_SHEET_NAME(20) TYPE C .

DATA GV_OUTER_INDEX LIKE SY-INDEX .

DATA GV_INTEX(2) TYPE C .

DATA GV_LINE_CNTR TYPE I . "line counter

DATA GV_LINNO TYPE I . "line number

DATA GV_COLNO TYPE I . "column number

DATA GV_VALUE TYPE I . "data

DATA R_NUM TYPE I VALUE 0. " row number

DATA : IT_SCARR TYPE STANDARD TABLE OF SCARR,

WA_SCARR TYPE SCARR,

IT_SPFLI TYPE STANDARD TABLE OF SPFLI,

WA_SPFLI TYPE SPFLI,

IT_SFLIGHT TYPE STANDARD TABLE OF SFLIGHT,

WA_SFLIGHT TYPE SFLIGHT.

*****************************

START-OF-SELECTION .

*****************************

SELECT * FROM SCARR INTO TABLE IT_SCARR.

SELECT * FROM SPFLI INTO TABLE IT_SPFLI.

SELECT * FROM SFLIGHT INTO TABLE IT_SFLIGHT WHERE CARRID = 'AA'.

DO 3 TIMES .

CNTL = CNTL + 1.

*--Forming sheet name

GV_INTEX = SY-INDEX .

GV_OUTER_INDEX = SY-INDEX .

CONCATENATE 'Excel Sheet #' GV_INTEX INTO GV_SHEET_NAME .

*--For the first loop, Excel is initiated and one new sheet is added

IF SY-INDEX = 1 .

CREATE OBJECT GS_EXCEL 'EXCEL.APPLICATION' .

SET PROPERTY OF GS_EXCEL 'Visible' = 1 .

GET PROPERTY OF GS_EXCEL 'Workbooks' = GS_WBOOKLIST .

GET PROPERTY OF GS_WBOOKLIST 'Application' = GS_APPLICATION .

SET PROPERTY OF GS_APPLICATION 'SheetsInNewWorkbook' = 1 .

CALL METHOD OF GS_WBOOKLIST 'Add' = GS_WBOOK .

GET PROPERTY OF GS_APPLICATION 'ActiveSheet' = GS_ACTIVESHEET .

SET PROPERTY OF GS_ACTIVESHEET 'Name' = GV_SHEET_NAME .

*--For the rest of loops, other sheets are added

ELSE .

GET PROPERTY OF GS_WBOOK 'Sheets' = GS_SHEETS .

CALL METHOD OF GS_SHEETS 'Add' = GS_NEWSHEET .

SET PROPERTY OF GS_NEWSHEET 'Name' = GV_SHEET_NAME .

ENDIF .

GV_LINE_CNTR = 1 . "line counter

*Code Part C.2 Looping and initializing, adding new worksheets

*Step3 -> Write the title and format it.

*--Title

*--Selecting cell area to be merged.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL1

EXPORTING

#1 = 1

#2 = 1.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL2

EXPORTING

#1 = 1

#2 = 4.

CALL METHOD OF GS_EXCEL 'Range' = GS_CELLS

EXPORTING

#1 = GS_CELL1

#2 = GS_CELL2.

CALL METHOD OF GS_CELLS 'Select' .

*--Merging

CALL METHOD OF GS_CELLS 'Merge' .

*--Setting title data

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL1

EXPORTING

#1 = GV_LINE_CNTR

#2 = 1.

SET PROPERTY OF GS_CELL1 'Value' = 'TITLE' .

*--Formatting the title

GET PROPERTY OF GS_CELL1 'Font' = GS_FONT .

SET PROPERTY OF GS_FONT 'Underline' = 2 .

SET PROPERTY OF GS_FONT 'Bold' = 1 .

SET PROPERTY OF GS_CELL1 'HorizontalAlignment' = -4108 .

GET PROPERTY OF GS_CELL1 'Interior' = GS_INTERIOR .

SET PROPERTY OF GS_INTERIOR 'ColorIndex' = 15 .

SET PROPERTY OF GS_INTERIOR 'Pattern' = -4124 .

SET PROPERTY OF GS_INTERIOR 'PatternColorIndex' = -4105 .

*Code Part C.3 Writing and formatting the title

*Step 4 -> Write some additional data for the title area and format them.

GV_LINE_CNTR = GV_LINE_CNTR + 1 .

*--Writing some additional data for the title

CASE CNTL.

WHEN 1.

PERFORM SHEET_NUMBER_1.

WHEN 2.

PERFORM SHEET_NUMBER_2.

WHEN 3.

PERFORM SHEET_NUMBER_3.

ENDCASE.

ENDDO.

*****************************

END-OF-SELECTION.

*****************************

&----

---

*& Form SHEET_NUMBER_1

&----

---

• text

-

---

• --> p1 text

• <-- p2 text

-

---

FORM SHEET_NUMBER_1 .

R_NUM = 3.

LOOP AT IT_SCARR INTO WA_SCARR.

R_NUM = R_NUM + 1.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL1

EXPORTING

#1 = R_NUM

#2 = 1.

SET PROPERTY OF GS_CELL1 'Value' = WA_SCARR-CARRID .

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL2

EXPORTING

#1 = R_NUM

#2 = 2.

SET PROPERTY OF GS_CELL2 'Value' = WA_SCARR-CARRNAME .

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL3

EXPORTING

#1 = R_NUM

#2 = 3.

SET PROPERTY OF GS_CELL3 'Value' = WA_SCARR-CURRCODE.

ENDLOOP.

ENDFORM. " SHEET_NUMBER_1

&----

---

*& Form SHEET_NUMBER_2

&----

---

• text

-

---

• --> p1 text

• <-- p2 text

-

---

FORM SHEET_NUMBER_2 .

R_NUM = 3.

LOOP AT IT_SPFLI INTO WA_SPFLI.

R_NUM = R_NUM + 1.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL1

EXPORTING

#1 = R_NUM

#2 = 1.

SET PROPERTY OF GS_CELL1 'Value' = WA_SPFLI-CARRID .

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL2

EXPORTING

#1 = R_NUM

#2 = 2.

SET PROPERTY OF GS_CELL2 'Value' = WA_SPFLI-CONNID .

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL3

EXPORTING

#1 = R_NUM

#2 = 3.

SET PROPERTY OF GS_CELL3 'Value' = WA_SPFLI-COUNTRYFR.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL4

EXPORTING

#1 = R_NUM

#2 = 4.

SET PROPERTY OF GS_CELL4 'Value' = WA_SPFLI-CITYFROM.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL5

EXPORTING

#1 = R_NUM

#2 = 5.

SET PROPERTY OF GS_CELL5 'Value' = WA_SPFLI-COUNTRYTO.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL6

EXPORTING

#1 = R_NUM

#2 = 6.

SET PROPERTY OF GS_CELL6 'Value' = WA_SPFLI-CITYTO.

ENDLOOP.

ENDFORM. " SHEET_NUMBER_1

&----

---

*& Form SHEET_NUMBER_3

&----

---

• text

-

---

• --> p1 text

• <-- p2 text

-

---

FORM SHEET_NUMBER_3 .

R_NUM = 3.

LOOP AT IT_SFLIGHT INTO WA_SFLIGHT.

R_NUM = R_NUM + 1.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL1

EXPORTING

#1 = R_NUM

#2 = 1.

SET PROPERTY OF GS_CELL1 'Value' = WA_SFLIGHT-CARRID .

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL2

EXPORTING

#1 = R_NUM

#2 = 2.

SET PROPERTY OF GS_CELL2 'Value' = WA_SFLIGHT-CONNID.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL3

EXPORTING

#1 = R_NUM

#2 = 3.

SET PROPERTY OF GS_CELL3 'Value' = WA_SFLIGHT-FLDATE.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL4

EXPORTING

#1 = R_NUM

#2 = 4.

SET PROPERTY OF GS_CELL4 'Value' = WA_SFLIGHT-PRICE.

CALL METHOD OF GS_EXCEL 'Cells' = GS_CELL5

EXPORTING

#1 = R_NUM

#2 = 5.

SET PROPERTY OF GS_CELL5 'Value' = WA_SFLIGHT-CURRENCY.

ENDLOOP.

ENDFORM. " SHEET_NUMBER_1