Skip to Content
0
Former Member
Oct 19, 2005 at 03:53 PM

Excel Download from Portal

36 Views

I have a requirement to download R/3 data to MS Excel from a portal page. I have developed a JSPDynPage iView to allow various user parameters to be entered, and retrieve data from R/3 by executing a remote function module (using JCA). I've reviewed most forum articles which describe downloading R/3 data to MS Excel and have concluded the following:

1) Use POI or html tables to transfer data to Excel (I’m using html tables currently)

2) Excel should be invoked from an AbstractPortalComponent rather than a JSPDynPage.

3) Launch the AbstractPortalComponent from an event within the JSPDynPage (using EPCM.doNavigate or response.write("<script>window.open('" + url + "')</script>")

My question is; how is the best way to transfer data between the JSPDynPage and AbstractPortalComponent? I have tried passing an IRecordSet using the Session Context:

JSPDynPage:

IPortalComponentSession mySession = request.getComponentSession();

mySession.putValue("personnelData", personnelData);

AbstractPortalComponent:

IPortalComponentSession mySession = request.getComponentSession();

personnelData = (IRecordSet) mySession.getValue("personnelData");

However, when I try to access the IRecordSet and launch Excel from the AbstractPortalComponent, I receive what looks like a portal sign-on screen within the Excel document. I have tried both IPortalComponentSession and HTTP Session to transfer the data.

Any assistance will be greatly appreciated.

Thanks.

Mark