topic Re: Transfer Data to Spreadsheet in Application Development and Automation Discussions

Transfer Data to Spreadsheet

Former Member — Mon, 25 May 2009 08:57:06 GMT

How do I export SAP data to Excel when SAP goes down?

Re: Transfer Data to Spreadsheet

Former Member — Mon, 25 May 2009 09:09:27 GMT

Try Function module "KCD_EXCEL_OLE_TO_INT_CONVERT"

Re: Transfer Data to Spreadsheet

Former Member — Mon, 25 May 2009 09:40:07 GMT

Dear,

Can you elaborate your problem little more so that we can understand exact problem.

Regards,

Vijay

Re: Transfer Data to Spreadsheet

Former Member — Mon, 25 May 2009 09:47:50 GMT

Ok, I am looking for code to export data from a table which is live to a spreadsheet when SAP goes down. For the information to be available even when SAP is down.

I hope it makes sense and thanks.

Re: Transfer Data to Spreadsheet

Former Member — Mon, 25 May 2009 10:13:44 GMT

Hi,

Please try below URL.

/people/kathirvel.balakrishnan2/blog/2006/05/08/data-upload-into-sap-from-microsoft-excel-150-abap-part

Regards

Pugal.

Re: Transfer Data to Spreadsheet

Former Member — Tue, 26 May 2009 09:46:24 GMT

This example is more than 25char so i give in multiple thread

REPORT ZOLE_ABAP.

INCLUDE ole2incl.

TYPES: BEGIN OF ty_spfli,

kunnr TYPE kna1-kunnr,

land1 TYPE kna1-land1,

NAME1 TYPE KNA1-NAME1,

ORT01 TYPE KNA1-ORT01,

REGIO TYPE KNA1-REGIO,

ADRNR TYPE KNA1-ADRNR,

END OF ty_spfli.

TYPES: BEGIN OF ty_titles,

title(20) TYPE c,

field(20) TYPE c,

END OF ty_titles.

DATA: t_spfli TYPE STANDARD TABLE OF ty_spfli,

t_titles TYPE STANDARD TABLE OF ty_titles.

FIELD-SYMBOLS: <fs_spfli> LIKE LINE OF t_spfli,

<fs_titles> LIKE LINE OF t_titles,

<fs> TYPE ANY.

DATA: w_tabix TYPE sy-tabix,

w_titles TYPE sy-tabix,

w_line TYPE sy-tabix,

w_field TYPE string,

filename TYPE string,

path TYPE string,

fullpath TYPE string.

DATA: data_titles TYPE REF TO data.

DATA: e_sheet TYPE ole2_object,

e_activesheet TYPE ole2_object,

e_newsheet TYPE ole2_object,

e_appl TYPE ole2_object,

e_work TYPE ole2_object,

e_cell TYPE ole2_object,

e_color TYPE ole2_object,

e_bold TYPE ole2_object.

SELECTION-SCREEN BEGIN OF BLOCK b1.

PARAMETERS: p_file TYPE rlgrap-filename.

SELECTION-SCREEN END OF BLOCK b1.

START-OF-SELECTION.

PERFORM get_titles.

PERFORM get_data.

PERFORM create_excel.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL METHOD cl_gui_frontend_services=>file_save_dialog

EXPORTING

window_title = 'Select archivo'

default_extension = 'xls'

file_filter = '*.xls'

CHANGING

filename = filename

path = path

fullpath = fullpath.

IF sy-subrc EQ 0.

p_file = fullpath.

ENDIF.

Re: Transfer Data to Spreadsheet

Former Member — Tue, 26 May 2009 09:47:04 GMT

FORM get_titles.

CREATE DATA data_titles TYPE ty_titles.

ASSIGN data_titles->* TO <fs_titles>.

<fs_titles>-title = 'Customer Number 1'.

<fs_titles>-field = 'KUNNR'.