Doubt on ALV report download to EXCEL


Hi All,
i have written a report with ALV_GRID FM, by default we get the option to download the output to excel. But when we click on the download to excel, it displays the output
in the frist page, but it also opens so many pages like
format, header, pivot,sub1,sub1....etc.
Pls. check the SAP standard report BCALV_TEST_FULLSCREEN, does the same thing when we do download to excel.
How can i avoid opening so many pages in excel?
Thanks for the help.


Hi ,
prabhu here , i think check the FM wheather u r passing all these to FM. for Excel keep export.param: --> i_save only and check.

October 11, 2015

Doubt on ALV report download to EXCEL

Hi All, i have written a report with ALV_GRID FM, by default we get the option to download the output to excel. But when we click on the download to excel, it displays the output in the frist page, but it also opens so many pages like format, header,

Problem when dowloading the ALV report output to Excel Sheet.

Hi , I am dowloading the ALV report output to Excel Sheet. There is field Condition Unit(KOMP-KMEIN) in the output of the ALV, this has values PC and CSE , but when I download to Excel Sheet, CSE is appearing as CSE ,but PC is appearing as ******. Ca

Using download button in ALV to download to excel

Hi, Please provide me the solution on using download button in Hierarchial List ALV to download to excel.I need to download the Header and Item details in a single line (in one line)in the Excel sheet. Please suggest the solution and sample code ASAP

Alv output download to excel sheet spliting into three line

hi, i have developed alv report with 62 fields (62 colums).when i download this output into excel sheet each line spliting into three line.each field has 20 char length.i want download each row as single line. i am using local file  (ctrl + shift+F9)

Problem in ALV grid download to excel

Hello Gurus, I have a ALV report which has 40 columns but at a time it will only display 100 records(max). when I am trying to download it into excel (by using standard funcationality) only headings are getting downloaded. I checked out standard tabl

WAD reports: download to excel

Hi, When you download your report data to excel, is there some kind of option available so that the user cannot change the data inside the excel? Or some kind of thing in the document that states that this data is original/changed. Does such a mechan

ALV Report Export to Excel

Hi experts, I generated ALV report with proper data information but when I export it to excel with this path List->Export->Local File->Spreadsheet. All the data I get perfectly expecting the Mobile no. filed. In my ALV report I got mobile no fiel

ALV output download to excel with top of page

Hi, i want to download ALV grid output to excel sheet including the top of page. i am using the icon in application tool bar. but only data's are download to excel sheet. i cannot download the top of page. with out write coding in program can we down

Dump for the ALV report for the excel.

HI, We are having a ALV report. We are using REUSE_ALV_FIELDCATALOG_MERGE and REUSE_ALV_GRID_DISPLAY. After we run the report we get the output on the screen properly. When we choose the "Local File" button it goes to the dump. The following mes

ALV colouring download to excel sheet

Hi Experts , I have a requirement in which I have coloured the cells of the ALV display , in order to highlight them. I have made use of 'REUSE_ALV_GRID_DISPLAY' FM for displaying ALV. When I  download this output to an excel sheet , the colour fille

ALV Tree download to Excel (CL_GUI_LIST_TREE )

Hi All,      I have created a report for displaying the ALV tree. The flow of the code is sth like this: Report -> Calls Screen 9000 -> Initialize container type CL_GUI_CUSTOM_CONTAINER -> Tree Class CL_GUI_LIST_TREE displays the ALV tree. Now wh

Alv report...excel view

Hi All, The standard full screen function highlighted below is not working. The report is a grid display and when want to use this button to convert to excel format i get a blank excel sheet. Application Toolbar            STANDARD_FULLSCREEN Items 

Oracle Reports Download to Excel

Can my users download an Oracle report under 6.0 to MSExcel? Do I need to specify a particular report file format to facilitate this?hi there is a way to download to csv (comma seperated) file and that is by specifying the file format as DELIMITED an

Cost center / Element report downloadable to excel

Hi does anybody know of a cost center/elements total report by period? s_alr_87013613 has the information but can not get both values (cost center and elements) in columns that it is usable for excel. I looked deeply and could not find anything. I se

How to download ALV report having more than 200 columns to Excel

Dear Experts, I am facing the issue of line break during downloading ALV report into excel. I referred the lot of forums but i didn't get the proper solution to solve this issue..Please guide me to solve this issue.... My output in ALV header1 header

Regarding excel download from ALV report tree

Hi Experts, I have a ALV report tree program. In that i need the functionality to download report output in excel file. Can any body suggest how can i achieve download to excel functionality in it. Any useful suggestion will be appreciated. Thanks in

Problem in downloading ALV report to Excel

hi All, i am facing the problem when i am trying to download the ALV report to Excel format i should have the option to  save as  the Excel file from the dropdown where as instead of it i am getting the option to save as XML file. is it something rel

Excel Download to ALV report

Hi Guys, I’m facing a peculiar problem. When I try to download an ALV report in excel format using (list ->export -> local file-> soread sheet )I’m not able to download complete set of records. Same is happening with ws_download,  even though the

No excel downloading icon or submenu is coming in alv report

hi,     i am not getting excel or spreadsheet download icon in my alv report through my login but this is working fine in any other login id. so please if any one faced the same problem , please assist me. Thanks and Regards vijay dwivedi <REMOVED BY

Problem in excel download of ALV report

Hi All, I have created an ALV report with 87 fields in it. Whenever I am trying to download that report into excel the number of column breaks into 2 rows. In this case, The downloaded file contains 57 Columns in 1 row and remaining 29 Columns in sec