topic Re: Microsoft Excel option is not pulling data. in Application Development and Automation Discussions

Microsoft Excel option is not pulling data.

Former Member — Wed, 01 Jul 2009 07:24:53 GMT

Hi Friends..

I have created ALV report, When I click the option "Export to Excel" Excel sheet is opened, but no data is there.

if I choose Local file----> Excel..its working fine. But customer required the Export to Excel option.

anybody help me to get the data through Export to Excel option.

Thanks

Gowrishankar

Re: Microsoft Excel option is not pulling data.

Former Member — Wed, 01 Jul 2009 07:40:51 GMT

Data might be more than the XLS file can capture. So please check your report and reduce the data for output as per selection criteria.

Regds,

Anil

Re: Microsoft Excel option is not pulling data.

Former Member — Wed, 01 Jul 2009 08:29:36 GMT

can you tell me the gui status is it the standard one or you had used any custom gui status

and can you also tell what is the ucomm for export to excel ? is it &XXL.

Re: Microsoft Excel option is not pulling data.

Former Member — Wed, 01 Jul 2009 08:34:06 GMT

Hi,

In your PF status pass this parameters:

function Code: &VEXCEL

function Text: Microsoft Excel

icon name: ICON_XLS

info text: Microsoft Excel View

fastpath: M

Thanks,

Krishna

Re: Microsoft Excel option is not pulling data.

Former Member — Wed, 01 Jul 2009 08:35:54 GMT

check your catalog fields matchs with your internal table fields

Re: Microsoft Excel option is not pulling data.

Former Member — Wed, 01 Jul 2009 10:19:37 GMT

Hi Gowrishankar,

Open Excel in your system, go to the menu Tools-> Macro-> Security. Tab Trusted Publishers - make sure that both "Trust all installed add ins and templates" and "trust access to Visual Basic Project" are checked.

Regards,

Sai