topic Re: ALV to Excel problems in Application Development and Automation Discussions

ALV to Excel problems

Former Member — Fri, 09 Jul 2010 07:02:44 GMT

I have created an ALV report with 87 fields in it. Whenever I am trying to download that report into excel the number of column breaks into 2 rows. In this case, The downloaded file contains 57 Columns in 1 row and remaining 29 Columns in second row. Can anyone please help me in understanding why this is happening while downloading this report into excel file and what will be the solution to correct it.

Thanks,

Sreekanth.G

Re: ALV to Excel problems

Former Member — Fri, 09 Jul 2010 08:21:08 GMT

Hi,

Dont Post the Same thread of yours for different Times. By doing this you are violating the SCN Rules.Please refer the SCN Rules before Posting.

With Regards,

Sumodh.P

Re: ALV to Excel problems

Former Member — Fri, 09 Jul 2010 08:31:47 GMT

Hi,

why don't you use excel-inplace?

Regards, Dieter

Re: ALV to Excel problems

Former Member — Fri, 09 Jul 2010 08:38:11 GMT

Hi,

Excel will support you till 256 columns..

May i know how you are downloading the data using sap to excel if any function module please try to check the interface of the function module any parameter will help you or let me know the function module name.

Regards

Satish Boguda

Re: ALV to Excel problems

Former Member — Sat, 10 Jul 2010 04:15:22 GMT

HI friend,

I have not used any function module but i directly used the tool bar icon of ALV which are inbuilt.

thanks,

Sreekanth.G

Re: ALV to Excel problems

Former Member — Sat, 10 Jul 2010 04:19:05 GMT

it was unfortunatly clicked.that is the reason i am trying mark it as unansered.

Re: ALV to Excel problems

Former Member — Sat, 10 Jul 2010 05:10:57 GMT

Try this,

HEADING FOR EXCEL SHEET

DATA: BEGIN OF IT_EXCEL1 OCCURS 0,

SAPID LIKE PERNR-PERNR,

UNAME LIKE SY-UNAME,

END OF IT_EXCEL1.

assigning column names in excel sheet

IT_EXCEL1-SAPID = 'Personnel number'.

IT_EXCEL1-UNAME = 'User Name'.

APPEND IT_EXCEL1.

to get desktop path

DATA : DESKTOP TYPE STRING.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>GET_DESKTOP_DIRECTORY

CHANGING

DESKTOP_DIRECTORY = DESKTOP

EXCEPTIONS

CNTL_ERROR = 1

ERROR_NO_GUI = 2

NOT_SUPPORTED_BY_GUI = 3

OTHERS = 4.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

CALL METHOD CL_GUI_CFW=>FLUSH

EXCEPTIONS

CNTL_SYSTEM_ERROR = 1

CNTL_ERROR = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

CONCATENATE DESKTOP '\filename.xls' INTO DESKTOP.

to download into excel sheet

FOR TITLES

CALL FUNCTION 'GUI_DOWNLOAD' " for titles

EXPORTING

BIN_FILESIZE =

FILENAME = DESKTOP

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = IT_EXCEL1.

FOR DATA

CALL FUNCTION 'GUI_DOWNLOAD' " for data

EXPORTING

FILENAME = DESKTOP

FILETYPE = 'ASC'

APPEND = 'X'

WRITE_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = IT_DOWNLOAD.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>EXECUTE

EXPORTING

DOCUMENT = DESKTOP

APPLICATION =
PARAMETER =
DEFAULT_DIRECTORY =
MAXIMIZED =
MINIMIZED =
SYNCHRONOUS =

OPERATION = 'OPEN'

EXCEPTIONS
CNTL_ERROR = 1
ERROR_NO_GUI = 2
BAD_PARAMETER = 3
FILE_NOT_FOUND = 4
PATH_NOT_FOUND = 5
FILE_EXTENSION_UNKNOWN = 6
ERROR_EXECUTE_FAILED = 7
SYNCHRONOUS_FAILED = 8
NOT_SUPPORTED_BY_GUI = 9
OTHERS = 10

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.