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 (Im 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