Export Documents Selected on viewPanel into Excel

HCL Domino Domino Forum
1

I am trying to develop an export into Excel routine for documents selected from a viewPanel in the Notes client. And am using a dijit.form.Button.

I can pass a selected id by using the following type of code:

However, this only passes the ID one by one, and runs the LotusScript agent to launch Excel and populate the spreadsheet for each document selected. I can’t figure out how to gather all the IDs and pass them together.

I have also tried to use Chris Toohey’s excel function which uses this type of information:

var exCon = facesContext.getExternalContext();

 var writer = facesContext.getResponseWriter(); 

 var response = exCon.getResponse(); 

  response.setContentType("application/vnd.ms-excel");

  response.setHeader("Cache-Control", "no-cache");

  response.setHeader("Content-disposition", "attachment; filename=projects.xls");

but it doesn’t do anything for me, or generate any error messages, and I can’t quite figure out from what I’m reading on the web what exactly this is doing. I’m thinking this is Java and not JavaScript? Or am I wrong?

Has anybody created an export to Excel function which works with selections made from a viewPanel? Or have any idea how this can be done?

Thanks very much for any suggestions!

2

Subject: is an LS agent an option?

or must it be js?

Uwe

3

Subject: Calling LotusScript Agent

I’m calling a LotusScript agent, but I need to use JavaSCript to grab the viewpanel and get selected Ids from it.

4

Subject: Haven’t tested this but… have you tried passing the entire Array to the agent?

Like so, perhaps… (removed the loop and changed the parameter passed to the agent). Again, I haven’t tried, but it seems logical.