You need to store the "parameters" to a session scoped variable and then read those values from the intermediate XPage.

As far as the button not working a second time add the following code to the link/buttons CLIENT SIDE event 

   setTimeout(function() { XSP.allowSubmit() }, 1000);

then you can submit multiple times. 

FYI, if you do a full refresh from the button then you don't need the intermediate XPage (XAGENT) as you can simply put all of the ssjs code in the link event 

 Paul - 

What does this code mean / do? 

Is that a common solution to some behavior or specific to exporting to Excel?

Thanks! 

 I'm not sure what the "default" timeout is, but it allows for being abile to click a submit button multiple times without having to refresh the page.

Doesn't have anything to do with the apache poi at all, more the workflow of calling an XAgent from a submit button. 

 

Excellent Paul.
 This XSP.allowsubmit() works fine... I was curious to check what this line does and researched a bit on this method. Found something which might be helpful to others.

-----------------------

legacy Client Side JavaScript
code or libraries your application uses might be performing page submission using
The Public XSP Client Side JavaScript Object Functions
document.forms[0].submit() or the like. Therefore, consider revising this
code to avoid page submission, instead favoring XPages’ own features or alternatively
modifying such code to use the XSP.canSubmit(), XSP.allowSubmit(), and XSP.
validateAll() functions to provide a more robust page submission behavior.
If the page is not submitted after a call to XSP.canSubmit(), this function should be
called to reenable the page submission mechanism

--------------------------- 
 

Thanks very much Paul. This forum is awesome!