topic Re: ALV Problem in Application Development and Automation Discussions

ALV Problem

arvind_soni — Fri, 20 Oct 2006 06:55:15 GMT

I want a button on the tool bar of the ALV on which When i click the data in the ALV gets transported to the Excel sheet.

I know the Feature is there in the ALV,but when i click on the existing button it asks for the options as shown below :

In which format should the

be saved ?

unconverted

Spreadsheet

Rich text format

HTML Format

Copy to Clipboard

I want the functionality such that when the user click on the button it directly transports the file to the Excel spreadsheet.

I dont know much about the OOABAP,So please provide the solution using the classical ABAP only.

Thanks in advance.

Re: ALV Problem

FredericGirod — Fri, 20 Oct 2006 06:57:47 GMT

Hi,

add the button to the toolbar,

manage the code at the button event,

and use the following function to save the table in Excel file: SAP_CONVERT_TO_XLS_FORMAT

Rgd

Fred

Re: ALV Problem

dani_mn — Fri, 20 Oct 2006 06:59:10 GMT

HI,

use the function 'GUI_DOWNLOAD' to download the data to the excel sheet.

if you want button in application tool bar then you have to use OO method. In classical it is not possible.

Regards,

Re: ALV Problem

Former Member — Fri, 20 Oct 2006 07:01:48 GMT

Yes the Feature is there in ALV. Here you need to select <b>spreadsheet</b> format, then it will be saved as excel sheet.

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: ALV Problem

Former Member — Fri, 20 Oct 2006 07:29:21 GMT

Hi Arvind,

use ALV-GRID, there is an EXCEL-Button wich show the

Output direct in EXCEL-Format. You can use this

Excel-Format as default.

Regards, Dieter

Re: ALV Problem

Former Member — Fri, 20 Oct 2006 07:49:25 GMT

Hi Arvind,

Have u got answer for the query? If not please revert back else please close the thread.

Best Regards,

Vibha

<b>*Please mark all the helpful answers</b>

Re: ALV Problem

arvind_soni — Fri, 20 Oct 2006 08:54:29 GMT

Hi Girod,

In the Function module:

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

I_FIELD_SEPERATOR =
I_LINE_HEADER =

i_filename = 'C:/'

I_APPL_KEEP = ' '

tables

i_tab_sap_data = 'IT_OUTPUT'

CHANGING
I_TAB_CONVERTED_DATA =

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2

i have given the internal table name in tables i_tab_sap_data and the file path in the filename.But it is showing the error as 'it is not the standard table'

please reply

Re: ALV Problem

Former Member — Fri, 20 Oct 2006 09:05:12 GMT

Hi Arvind,

What u were doing earlier was correct. U just have to mention the formar as speadsheet when u are using the feature provided by SAP.

Have you checked it Arvind? I think no changes are necessary.

Just try it out...

Best Regards,

Vibha

*Please mark all the helpful answers

Re: ALV Problem

arvind_soni — Fri, 20 Oct 2006 09:14:00 GMT

Hi guys !!

Its working now but the only thing left is that when the data is transported to the excel sheet the field label from the data dictionary should also come on the Excel sheet.

Do I need to make some changes in the internal table like the field label inclusion at the time of data fetching.

Thanx.

Re: ALV Problem

Former Member — Fri, 20 Oct 2006 09:29:07 GMT

Arvind,

Really it is not necessary to use the FM SAP_CONVERT_TO_XLS_FORMAT.

Using SPREADSHHET FORMAT was the simplest solution to ur problem.If you can use ur earlier method there will not be any problem of labels also.

Best Regards,

Vibha

*Please mark all the helpful answers