Problem with excel download using XXL_FULL_API

Former Member · ‎2009 Nov 05

Hi All,

I am trying to download data in excel using FM XXL_FULL_API .

I am unable to view data in the excel file(2007) after the execution of program.

The excel file is opened but without data.

Where as the output can be viewed in my friends system which is installed with MS excel 2003.

Any Help for the same will be higly appreciated.

Former Member · ‎2009 Nov 05

Hi,

Try using the FM GUI_DOWNLOAD....FILENAME=file.xls,filetype = DAT. will download your data into excel file on the presentation server.

Hope this will help you.

Pooja

Former Member · ‎2009 Nov 05

Hi Pooja,

Thanks for the reply.

But, I am trying to download pivot table data in the excel which is not possible with GUI_DOWNLOAD.

Former Member · ‎2009 Nov 05

Hi,

The requirement was not clear from your post, so i posted as per the understanding on the provided query.

I searched the net and got soemthing on it.

I hope this is not violating the rules, and hoping your problem will be solved.

Pooja

Former Member · ‎2009 Nov 05

Hi,

Thanks for your time and also the reply.

I have already seen this.If you see the code the author has created some custom FM

CALL FUNCTION 'ZJNC_START_EXCEL'

IMPORTING

SPREADSHEETINTF = SPREADSHEETINTF

DOCUMENTINTF = DOCUMENTINTF.

This is not present in my system.

My program with FM 'XXL_FULL_API' is working with excel 2003.

I am looking for the settings in MS excel 2007 which can be activated for the program to work.

Thanks in advance.