Skip to Content
0
Former Member
Jan 15, 2008 at 02:45 PM

PROBLEM WITH BSP AND EXCEL

22 Views

Hello Friends.

I have a BSP that shows all the client data and generate a file when a boton is push.

What I need to know is; how can i made that the system generate a file for each client without having the internet explorer pup-up for download each time, furthermore, I want that these files to be located at the local unit C:\.

The code i have is as follow:

DATA: fichero TYPE string.

CONCATENATE 'F' vnomfich '.xls' INTO vnomfich.

  • some Browsers have caching problems when loading Excel format

response->delete_header_field( name = if_http_header_fields=>cache_control ).

response->delete_header_field( name = if_http_header_fields=>expires ).

response->delete_header_field( name = if_http_header_fields=>pragma ).

  • start Excel viewer either in the Browser or as a separate window

response->set_header_field( name = if_http_header_fields=>content_type

value = 'application/vnd.ms-excel' ).

CONCATENATE ' attachment; filename= ' vnomfich INTO fichero.

response->set_header_field( name = 'Content-Disposition'

value = fichero ).

  • finally display Excel format in Browser

response->set_cdata( data = l_output ).

  • do not process Layout, response has been rendered

navigation->response_complete( ).