Export report to xls

[Former Member]

Hi,

I need to export the BW report data to xls, BW provides a standard way of doing it, left click on the report data --> Enhanced Menu --> Export as xls ...

However, the file name and the automatically choosen directory to save are quite bizzare and long. Would it be possible to have a shorter and more meaningful name?, if so, how?.

Regards,

Nagendra.

[Former Member]

Hi Nagendra,

You can use Excel Macros with a predefined path to save. You can incorporate the macros in the workbook.

Bye

Dinesh

[athavanraja]

if you want this webtemplate you can just add the following line of code in the webtemplate , upon clicking excel will bring up a popup to open/save . click open and then save it using saveas whereever you want.

<A href="<SAP_BW_URL CMD='EXPORT' FORMAT='XLS' DATA_PROVIDER='DATAPROVIDER_1'>"><IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="T77"> <SAP_BW_TEXT program="SAPLRRSV" key="T72">" src="Mime/BEx/Icons/S_X_XLS.gif" border=0 ></A>

Regards

Raja

[Former Member]

Hi Nagendra,

Use the ABAP prigram WRITEQUERY and save it as excel file.

Bye

Dinesh

[Former Member]

Hi,

I do not want to give any access of any report program (writequery) to the user. The user is satisfied with the standard export functionality. Only change required is instead of long unfriendly file name proposed by the system on exporting the report, if we could define our own file name and location (in some ini or other setup file) would be nice.

Regards,

Nagendra.