About function module

[Former Member]

Hi to all,

Can anybody tell me the function module to bring the output of a report in excel sheet in Microsoft Office 2007.

I have the function module which can print the output in Office 2003 but that FM is not working in case of office 2007.

Thanks in advance.

[naveen_inuganti2]

Hi...

You can use... GUI_DOWNLOAD function module.

and pass the following importing parameters..,

> FILENAME = p_file

> FILETYPE = 'DAT'

> WRITE_FIELD_SEPARATOR = 'X'

If every thing is ok...! Thats other setting problem. Because we can down load Excel 2007 with above function module..!

Thanks,

Naveen Inuganti.

[narin_nandivada3]

Hi Abhijeet,

Please go through this thread.. there are SAP Notes provided in this thread.. go through them...

Searched in the forum and found that some settings has to be made..

Please check this link for the settings...

Hope this may help you.

Good luck

Narin

[Former Member]

Hi Abhijeet,

Check this thread for the solution:

Regards,

Chandra Sekhar

[Former Member]

Hi

Use this

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
  EXPORTING
   i_field_seperator          = 'X'
*   I_LINE_HEADER              =
    i_filename                 = p_pcfile
*   I_APPL_KEEP                = 'X'
  TABLES
    i_tab_sap_data             = it_excel
* CHANGING
*   I_TAB_CONVERTED_DATA       =
 EXCEPTIONS
   conversion_failed          = 1
   OTHERS                     = 2
          .

[Former Member]

Hi Abhijeet.

I would like to suggest a couple of references,

[SDN Library - Standard Reference - PDF - Creating Reports with Microsoft Office 2007 Data Files|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/105142f1-8f1e-2b10-ddac-dbbd038ba53b]

[SDN - Reference - MS Office 2007 and ALV queries download to excel|;

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

[Former Member]

hiii

which FM you are using? i think GUI_DOWNLOAD will work here.try using that.

regards

twinkal

[Former Member]

hi,

if u want automaticallu use GUI_DOWNLOAD or WS_DOWNLOAD

OR by manually

Execute the report goto LIST--> save/send --> office

[former_member787646]

Hi

Use the function module "SAP_CONVERT_TO_XLS_FORMAT" to upload the data to an excel file.

Hope it helps.

Murthy