topic Re: Download data in Application Development and Automation Discussions

Download data

Former Member — Thu, 09 Nov 2006 14:18:27 GMT

Hello friends,

I have downloaded data from Internal table to text file. But my requirement wants it to download in excel sheet.

are there any FM that download data in excel sheet.

Shejal.

Re: Download data

Former Member — Thu, 09 Nov 2006 14:20:34 GMT

Hi shejal,

1. This text file can be opened in excel.

regards,

amit m.

Re: Download data

Former Member — Thu, 09 Nov 2006 14:22:11 GMT

Shejal,

try 'EXCEL_OLE_STANDARD_DAT'.

-Anu.

Re: Download data

Former Member — Thu, 09 Nov 2006 14:22:33 GMT

hi Shejal,

data lv_file name type string.

data download1 type table (your internal table)

call function 'GUI_FILE_SAVE_DIALOG'

EXPORTING

WINDOW_TITLE = 'Enter File Name'

DEFAULT_EXTENSION = 'XLS'

DEFAULT_FILE_NAME = 'shejal.xls'

IMPORTING

FULLPATH = lv_filename.

call function 'GUI_DOWNLOAD'

exporting

filename = lv_filename

FILETYPE = 'DAT'

tables

data_tab = download1.

This code will download the file in tab delimited form..but will be open with excel...

you can change the delimeter option...by including the file_separator export parameter to gui

_download functin module.

Hope this helps.

Sajan.

Re: Download data

Former Member — Thu, 09 Nov 2006 14:24:17 GMT

Hi Shejal,

Try this:

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.

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

Reward points if this helps.

Manish

Message was edited by: Manish Kumar

Re: Download data

Former Member — Thu, 09 Nov 2006 14:29:50 GMT

Thanks for all the suggestions,

right now i am downloading the file in tab delimited and opening it in EXCEL.

But the business people dont want to do this. They want it to be downloaded in excel itself.

there anr many files that will be created every hour, so dont want to convert the text file to excel manually.

However I am having one more problem in text file.

Eg- suppose I am downloading two fields,

Kunnr and matnr

when I download they dont want any leading zeros.

so I am having problem with alingment for different rows if the number of char are different,

my output file looks like this.

12345 5632

1234567 5234

125 854889

So I am having problems cnverting into excel.

any suggestions,

Shejal.

Re: Download data

Former Member — Thu, 09 Nov 2006 14:30:13 GMT

Hi Shejal,

You can use FM GUI_DOWNLOAD.

data: it001 type table of t001 with header line. 

select * into table it001 from t001. 
call function 'GUI_DOWNLOAD'     
  exporting          
    filename              = 'C:test.xls'
    write_field_separator = 'X'     
  tables          
    data_tab              = it001.

Regards,

Ferry Lianto