Excel Export error

[Former Member]

Hi,

When I am exporting data from a standard table it is coming horizontally in one row. Please help me is there any settings to export data vertically(in tabular form).

Thanks in advance.

Regards,

Prashant Singh

[Former Member]

explain more clear plz....

[Former Member]

Hi Ganesh,

In T code SE16 when I export data for any standard table e.g. USR02, there are 300 rows in that table in SAP but after exporting all 300 rows come in single row(top row). I want data to be exported in tabular form only. Please help.

Thanks in advance.

Regards,

Prashant

[Former Member]

Try using the parameter "APPEND " = X in the FM GUI_DOWNLOAD , this should work . Else please provide a screenshot of the code where you are using this FM .

[Former Member]

Hi Debojyoti,

USR02 is a standard table. I have not written any code for it.

[Former Member]

hiii,

you can use the follwing funcrion to download the file in a particular format :

call function 'GUI_DOWNLOAD'

exporting

filename = 'C:\Documents and Settings\akshayr2403\Desktop\docs\rep.xls'

filetype = 'WK1'

write_field_separator = 'X'

tables

data_tab = it_vbak

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.

regards,

akshay ruia

[Former Member]

Hi,

No much setting avialable in standard one way out it export in .txt file(Plain text) and take to excel

or if you know excel well just manupulate little bit and get the value.

Regards

Bikas

[Former Member]

Try to download data from internal table using 'save as local file' option in debugging mode for SE16.

Check if this works for you.

[Former Member]

Hi Prashant,

If you have using ALV Grid Display

1) Click on the Button Local File just above the grid

2) Choose option Spreadsheet and save.

If you are using ALV List or SE16 standard list

1) Menu Item System -> List -> Save -> Local File

2) Choose option Spreadsheet and save

Regards,

Jovito