topic Re: Excel Export error in Application Development and Automation Discussions

Excel Export error

Former Member — Tue, 11 Jan 2011 04:40:26 GMT

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

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 04:48:40 GMT

explain more clear plz....

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 05:45:13 GMT

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

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 05:46:14 GMT

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 .

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 05:51:04 GMT

Hi Debojyoti,

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

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 05:59:13 GMT

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

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 06:04:57 GMT

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

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 06:29:52 GMT

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

Check if this works for you.

Re: Excel Export error

Former Member — Tue, 11 Jan 2011 10:16:19 GMT

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