Question:
Q: Where or how can I change the formatting of the Excel template which is used to format data which is downloaded from the web command to save as Excel (<SAP_BW_URL DATA_PROVIDER='DATAPROVIDER_1' CMD='EXPORT' FORMAT='XLS'>)
Essentialy, I am looking to change the default template globally so it is formatted nicer. I thought there was a way I could at least do this for the default excel template for everyone, but even that does not seem to be the case.
I can change the default excel template I use in BEx, but it only affects me as the default, I can't seem to find anything about changing this globally and I thought there was a way to do this.
I could use a macro in Excel to change the formatting after the fact, but that is not the optimal solution. I would prefer to change the template which is used globally for exporting from the web and I would also like to globally affect the change in the default Excel template in BEx as well.
I can't seem to find information anywhere on this. Any help would be greatly appreciated.
Background: I have looked in Notes, Help.Sap.com, /BW Documentation and How To Guides, and SDN. I also searched this forum and looked through the majority of the postings on Excel. I have not been able to find information on this. -If you think there is something I missed in one of these areas, please suggest it.
Thanks,
Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
Dear Bobcat,
I read your postings regularly. I am little hesitant to post a reply on a subject where you are trying it hard to find a solution.
I have very little to offer .lets see, it may be of help to you.
I am thinking of an idea where the web report can have a default template for all users.
how about finding out the 'code line' which directs the web content to this BW default excel., and change it to divert to a default page(giving its path by keeping this page where in all users have access permissions) which we think is nicer than BW default screen?
just for a thought.( are you trying to do the same?).
have a nice day
rao duttaluri
Answer:
correction:
I am thinking of an idea where the web report can have a "default template" for all users.
i intended to write:"'Default 'excel template for download'."
Answer:
Hello there
I am almost sure (not 100 pct. ) that the global template is a part of the GUI package. Or at least I can not find it on the server.
Try to look at <Drive>:\....SAP\FrontEnd\Bw\sapbexs.xla.
Best regards
/L2L
Answer:
Yes that is the case for users who have that part of the SAPGUI installed on their machine. And I believe I can affect a change by replacing this template (I will test latter today) with another template.
However, for web reporting, I believe this is generated on the server, as it could be generated for ppl who don't have the SAPGUI installed. (I realize in your writing this that I don't know that I have tested behavior on a machine w/o SAPGUI, which I will also be looking at later today.)
Thank you for your suggestions. I appreciate the effort.
I am hesitant to try and trace the code execution via ST01 or in debug mode as its not a strong point I have.
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
Bobcat,
There is no default template used for the Excel download, the data is transferred to the client in XML for MS office format and the header for the HTML is set to application/ms-excel so that it will open in a MS Excel.
Thanks.
Answer:
There is no default template used for the Excel download, the data is transferred to the client in XML for MS office format and the header for the HTML is set to application/ms-excel so that it will open in a MS Excel.
Do you know where I could review this, or if there is a way I could affect a change via an exit or something?
Thanks,
Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
There is not much info available on this. You can look at the BEx ICM handler class and try writing a new handler which suits your needs. Again any changes with the SPs for the ICM handler should be tracked.
Thanks.
Answer:
There is not much info available on this. You can look at the BEx ICM handler class and try writing a new handler which suits your needs.
Thanks for that information. I could not find a BEx ICM handler class, but through some investigation I found the following classes through notes:
CL_RSR_WWW_VIEW EXPORT_DATA. It looks like this calls the CSV, and Excel download options. The Excel portion calls, RSR_XLS_EXPORT_VIEW.
CL_RSR_WWW_HTTP
RSAH_BIW_CALL_SERVER
CL_RSR_XLS_GRID
I am slowly getting an idea of what is happening with these, but it is going to take me a lot more time to sift through this all.
I am not a programmer (well, not ABAP anyway) other then basic class creation for the table api or the creation of customer exits for variables. Can you provide any information on helping me to understand how I might go about changing or enhancing these? Or as this is SAP delivered, would it be adviseable to possibly write my own class to call in a web template to export the data?
Can anyone offer up any suggestions or solutions they have used in this case? [I can't believe I am the only one - or the first - who has needed to change this.]
I'm not above begging for code
Thanks again,
Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
Hi SBobcat,
did you find a solution to your problem.
I have a similar requirement where I need to change the font size, margin settings and change the page orientation to landscape when the user is exporting it to Excel.
With the help of the above replies I have found that it is using a style sheet to format the excel file. Within the style sheet I can change the font size but I dont think the other two are feasible.
The Class used is CL_RSR_XLS_GRID and the method is GET_STYLEDECL. Here I can see the font definition
regards
Poonam
Answer:
Changes made to styles in this program control the export to excel format. I have successfully made changes here and exporting to the web from excel is cleaner...
LRSR_XLS_EXPORTF01
Prakash
Answer:
Changes made to styles in this program control the export to excel format. I have successfully made changes here and exporting to the web from excel is cleaner...
LRSR_XLS_EXPORTF01
Prakash
Prakash,
Thank you. This looks promising. Could you provide an example or two of some of the modificaitons you have made to this?
Thanks,
Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
Hi Prakash,
we also have a need to change porgram that downloads web report into excel. if you are still around, we appreciate if you could let us know what changes you have successfully made to program LRSR_XLS_EXPORTF01 .
thanks
Answer:
Q: Where or how can I change the formatting of the Excel template which is used to format data which is downloaded from the web command to save as Excel (<SAP_BW_URL DATA_PROVIDER='DATAPROVIDER_1' CMD='EXPORT' FORMAT='XLS'>)
Essentialy, I am looking to change the default template globally so it is formatted nicer. I thought there was a way I could at least do this for the default excel template for everyone, but even that does not seem to be the case.
I can change the default excel template I use in BEx, but it only affects me as the default, I can't seem to find anything about changing this globally and I thought there was a way to do this.
I could use a macro in Excel to change the formatting after the fact, but that is not the optimal solution. I would prefer to change the template which is used globally for exporting from the web and I would also like to globally affect the change in the default Excel template in BEx as well.
I can't seem to find information anywhere on this. Any help would be greatly appreciated.
Background: I have looked in Notes, Help.Sap.com, /BW Documentation and How To Guides, and SDN. I also searched this forum and looked through the majority of the postings on Excel. I have not been able to find information on this. -If you think there is something I missed in one of these areas, please suggest it.
Thanks,
Stephen