xPage Export to Excel using Lotus Script:

Export to Excel using Lotus Script:  Yes, export to excel using your lotus script on the xPage , as earlier we said xPages supports Lotus Script agent ,this is the one of the example.

Here we will see how we can export viewpanel documents to excel using our lotus script.
We are sure that as a lotus notes developer, you have been using this technique for many years to export documents using lotus script, here the same technique we are now applying on xPage.
Yes, the same technique on xPage! 

In earlier article we think you have seen export to excel using client side JavaScript. If not, please look at once - here is the link "Export to excel using JavaScript". In this JavaScript export we have used "content type" method to export documents in excel, but it has some drawbacks as this i.e. JavaScript content type technique is not supportive to all browsers. But here, i.e. with Lotus Script we will try to cover all your limitations and will try to provide foolproof export to excel using LotusScript.  

So let’s find out the examples.
First we will explain the concepts behind this-
We have added the "view Panel" on xPage and then one "export to excel" button control on the top of the viewPanel. 

Now here we need one help from client side JavaScript. So we will add client side JavaScript on the button control to call the Lotus Script agent, we think you are aware of this technique.
Now let’s start with steps-


2. Add below client side JavaScript code on the button control to call Lotus script agent.
window.open('http://<server_name>/<database_name>/exportToexcel?OpenAgent');
     
Simple!