WAD reports: download to excel


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 mechanism exist that can say that the data is original when you download it via the web report?
Thanks in advance!


as u said u r downloading the data to excel from wad
now the output is stored  in excel and if user changes this data then this change will reflect at local pc of ur user
wat i meant to say is
lets say ur query is runing thru webtemplate ww
now ur user x download the query execution thru excel to his pc xx
now if user changes this excel it will only happen at his pc xx
now if user forwards this changed excel then and only then this change spreads
otherwise watever the query execution is going to be it will remain same at all pc's
in short user can change excel at their respective pc's
if it is assigned to u to send the downloaded excel from wad to different user communities
then after downloading u can secure the excel document
u can download say result aa on day 1
after downloading use Tools in tabs and then select Options and then in dialog box u can select Security and set the password to open the document, to change the document etc.
u can set password to edit the document
this way ur forwarded excel will not get changed
or if ur doubt is if user change data in excel dowloaded from wad , does it change data at infoprovider then the answer is NO.
the data at infoprovider will not be changed.

October 11, 2015

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

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,

WAD report export to excel formatting not preserved

Hi, when i export BI 7.1 WAD template to excel and copy to another excel sheet cell formatting changes.color formatting is not preserved when we copy to another excel sheet.I tried resetting the "preserve visual appearance of workbook" to the ex

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

Password when downloading WAD report to Excel

Hello, When i download a WAD report in MS Excel the Excel program ask the me for a password. Is there a way to cancel the password varification in Excel? Thanks, DavidTry setting up a anonymous user for the mime objects service in SICF. Thanks.Read o

Limit the number of record to download to excel from a report

I am just wondering if there is a way to limit the number of rows that I want to download to excel from a report in apex, right now when I click download to excel it downloads all records. If I am displaying 15 records on report page I want the abili

Cuts off leading zeros in a report column when "Download to Excel" function

Hello When a text column contains leading zeros for example "000250" the download to Excel stores the string as "250" in the spreadsheet. I am using a column which is a string.(varchar) Can somebody suggest me , how to go ahead with it

Is it possible to download to excel when a report running in background

Dear All, I tried to execute one ALV report in foreground and background. In foreground the report is giving excel download but in background no excel download is coming. Is there any specific reason for that? Thanks and regards, AtanuAtanu dey, If y

Oracle report to Microsoft excel

Hello friends, I want to send the data from oracle report to Microsoft Excel from the report builder it self or from the Form Builder.so plz elp me out from this situation Regards, Sourav...Hi Sourav, You can refer to Section D.1.9 "Displaying Report

Download to Excel 2000 Functionality

Hi, I use the "Download to Excel 2000" functionality in OBIEE. When i see the output in Excel,columns B and C of excel get merged and display the second column in my report The point here is the first column in the report also has the same prope

ALV download to Excel onto desktop using OLE concept.

Hi Experts, I requriement is , through my se38 program i need to download report output to excel. i did this using OLE concepts code and excel is being downloaded good. But problem is all columns data is dumped into First column. But in my ALV i have

Displaying images along with data on downloading from excel

Hi All, I need to show images along with data in the excel sheet when user clicks downld to excel button.  Is there possible way to show the images in excel sheet if, kindly help. Thanks & Regards Jaspreet KaurHi Vinod Basically I have a report which

Download an excel file in background mode

Hi All, I need to download a file from a ABAP  report to the local workstation in background mode. I tried GUI_DOWNLOAD but it is failing in the background. Is there any way to download the excel file in the background. I am thinking of generating th

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

Download to Excel.

Hi, I have to download data into excel . Now this data is not predefined .. as in its picked up from custom table . If no of records selected from custom table is 6 then 6 columns in final_itab. If 10 records selcted then 10 columns . Now I have mana

ALV / Download to Excel - columns transposed

A developer on my team has this problem: We have a ALV report that gives the user the option to download to excel. The report has columns. A,B,C,D (for example) but when the user exports to excel ("List > Export > Spreadsheet > Table")

Download to Excel comes blank

Hello Gurus: I am having an issue when I try to download a particular report to excel. It is a pivot table, and It only displays some rows when I download it to Excel. It doesnt display all the rows. Most of the rows are column formulas, those are th

NO header detail appears when downloading to excel from web template

When we run our queries via a web template and through the portal we get the results which shows the query title and report details. When we try to download this to excel the header(report title etc. )information doesn't come down but all the rest of

Download to Excel Function in ALV

Hai Friends, I am using the following methods to download the report to an Excel Sheet from ALV. CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_SAVE_DIALOG CALL FUNCTION 'GUI_DOWNLOAD' The report is downloaded to Excel but the Column names are not displa