Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Reg : export data from ALV to excel file

Former Member
0 Kudos
63

Hi All,

I am using REUSE_ALV_GRID_DISPLAY to display the output. I have total 73 columns getting displayed in output but when i export the data to the excel file using (ctrlshiftF9) I am getting only first 43 columns in the first row and from 44th column on wards the data is populated in the 1st column of second row.

Please let me know is there any particular setting by which I can get all the 73 columns in a single row.

Thanks in advance.

VIJAY

1 ACCEPTED SOLUTION

Wil_Wilstroth
Active Participant
0 Kudos
40

Hi vijay,

You can try setting your line width to 255 in your abap program.

Otherwise, you can try an alternative:

1. Put a customize button on the ALV toolbar.

2. Go to se41 to create th buttons

2. do i_callback_program in ALV function. or SET PF_STATUS

3. Then in sy-ucomm, use 'GUI_DOWNLOAD' to xls.

Hope this helps you.

Thanks

William Wilstroth

Edited by: william wilstroth on Dec 18, 2007 5:06 PM

William Wilstroth
1 REPLY 1

Wil_Wilstroth
Active Participant
0 Kudos
41

Hi vijay,

You can try setting your line width to 255 in your abap program.

Otherwise, you can try an alternative:

1. Put a customize button on the ALV toolbar.

2. Go to se41 to create th buttons

2. do i_callback_program in ALV function. or SET PF_STATUS

3. Then in sy-ucomm, use 'GUI_DOWNLOAD' to xls.

Hope this helps you.

Thanks

William Wilstroth

Edited by: william wilstroth on Dec 18, 2007 5:06 PM

William Wilstroth