Create Alv Border

[Former Member]

Hi all,

I want to create a alv with some rows.For this i have some requirements:

In every row contains different numbers of columns.

Which will be displaying like an excel file with differeny columns in different rows.

Sugess How is it possible?

Points will be sured.

Thanks

Sanket Sethi

[Former Member]

Hi this will help u.

DOWNLOAD ALV LIST TO EXCEL AUTOMATICALLY

TYPES:

BEGIN OF ty_upload,

field1 TYPE c length 12,

field2 TYPE c length 12,

field3 TYPE c length 12,

END OF ty_upload.

DATA it_upload TYPE STANDARD TABLE OF ty_upload WITH DEFAULT KEY.

DATA wa_upload TYPE ty_upload.

DATA itab TYPE STANDARD TABLE OF alsmex_tabline WITH DEFAULT KEY.

FIELD-SYMBOLS: <wa> type alsmex_tabline.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = filename

i_begin_col = 1

i_begin_row = 1

i_end_col = 3

i_end_row = 65535

TABLES

intern = itab.

LOOP AT itab ASSIGNING <wa>.

CASE <wa>-col.

WHEN '0001'.

wa_upload-field1 = <wa>-value.

WHEN '0002'.

wa_upload-field2 = <wa>-value.

WHEN '0003'.

wa_upload-field3 = <wa>-value.

ENDCASE.

APPEND wa_upload TO it_upload.

CLEAR wa_upload.

ENDLOOP.

********************************************************************************

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

• I_FIELD_SEPERATOR =

• I_LINE_HEADER =

i_filename =

• I_APPL_KEEP = ' '

tables

i_tab_sap_data =

• CHANGING

• I_TAB_CONVERTED_DATA =

• EXCEPTIONS

• CONVERSION_FAILED = 1

• OTHERS = 2

.

IF sy-subrc <> 0.

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

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

ENDIF.

Another FM –

MS_EXCEL_OLE_STANDARD_DAT

A simple option:

a) form download_file .

call function 'WS_EXCEL'

importing

filename = excel_name

tables

data = itab.

b) call function 'WS_DOWNLOAD'

exporting

filename = o_file

filetype = 'DAT'

tables

data_tab = i_tab

exceptions

file_open_error = 1

file_write_error = 2

invalid_filesize = 3

invalid_type = 4

no_batch = 5

unknown_error = 6

invalid_table_width = 7

gui_refuse_filetransfer = 8

customer_error = 9

no_authority = 10

others = 11.

if sy-subrc = 0.

message 'File is downloaded successfully' type 'I'.

endif.

with regards,

Hema Sundara.

pls give points if it helps u.

[Former Member]

Hi Hema,

Actually i am not pick that from an Excel file. I only give the example that it look likes an excel sheet file.

Sanket

[Former Member]

hi

good

go through this link ,hope this would help you to give some idea about the ALV borders.

thanks

mrutyun^

[Former Member]

Hi Mrutyunjaya,

Send the link again plz.

Sanket

[Former Member]

closed.