topic Re: Internal Table To Excel in Application Development and Automation Discussions

Internal Table To Excel

Former Member — Tue, 11 Apr 2006 14:31:22 GMT

Hello everyone,

I am downloading an internal table using the FM

SAP_CONVERT_TO_XLS_FORMAT. Is there another FM which

would allow me to specify a range of columns??

There are currently 300 columns in my table

and because of the limitation of excel i.e. 255 columns

I need to extract the data twice e.g. Cols 1 to 200

and Cols 201 300

Re: Internal Table To Excel

Former Member — Tue, 11 Apr 2006 14:34:30 GMT

How about using the GUI_DOWNLOAD method of CL_GUI_FRONTEND_SERVICES class.

Re: Internal Table To Excel

Former Member — Tue, 11 Apr 2006 14:36:30 GMT

use <b>GUI_DOWNLOAD</b> FM

data : filename type string,

fl_type type char10 value 'ASC'.

FILENAME ' 'C:\TEST.xls'.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

FILENAME = FILENAME

FILETYPE = 'ASC'

APPEND = ' '
WRITE_FIELD_SEPARATOR = ' '
HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
IMPORTING
FILELENGTH =

TABLES

DATA_TAB = ITAB

FIELDNAMES =

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22

IF SY-SUBRC <> 0.

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

ENDIF.

Re: Internal Table To Excel

Former Member — Tue, 11 Apr 2006 14:39:14 GMT

HI,

you can use GUI_DOWNLOAD Function module.

-Rakesh

Re: Internal Table To Excel

Former Member — Tue, 11 Apr 2006 14:41:07 GMT

Hi,

you can do with normal GUI_DOWNLOAD.

give the file name as 'abc.xls'.

regards

vijay

Re: Internal Table To Excel

Former Member — Tue, 11 Apr 2006 14:48:34 GMT

Cheers guys.

Thanks for taking the time out to reply.

Many thanks