topic Re: About function module in Application Development and Automation Discussions

About function module

Former Member — Mon, 04 Aug 2008 05:01:41 GMT

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.

Re: About function module

naveen_inuganti2 — Mon, 04 Aug 2008 05:07:33 GMT

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.

Re: About function module

narin_nandivada3 — Mon, 04 Aug 2008 05:07:33 GMT

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

Re: About function module

Former Member — Mon, 04 Aug 2008 05:11:22 GMT

Hi Abhijeet,

Check this thread for the solution:

Regards,

Chandra Sekhar

Re: About function module

Former Member — Mon, 04 Aug 2008 05:12:32 GMT

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

Re: About function module

Former Member — Mon, 04 Aug 2008 05:12:53 GMT

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
          .

Re: About function module

Former Member — Mon, 04 Aug 2008 05:14:46 GMT

hiii

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

regards

twinkal

Re: About function module

Former Member — Mon, 04 Aug 2008 05:20:46 GMT

hi,

if u want automaticallu use GUI_DOWNLOAD or WS_DOWNLOAD

OR by manually

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

Re: About function module

former_member787646 — Mon, 04 Aug 2008 05:23:20 GMT

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

Hope it helps.

Murthy