Ci riprovo vediamo se funge...
Tu hai una form di scelta con un radio button
hai un bottone SUBMIT per procedere
Potresti creare un agente che processa il file excel in questo modo:
Ovviamente il base al document context salvi o meno il file...con un semplice
IF messo all\'interno dell\'agente.
Nel frattempo vedo di trovarti qualcos\'altro....per la tua richiesta
\' You need to create Lotus Script agent and pass the view name ( alias is
preferred ) while calling it.
\' In the agent grab the view name and using the NotesViewEntryCollection class
and NotesViewEntry class
\' you can get the values in the view.
\' Loop through the collection of ViewEntries and print the excel sheet as
required
Print {{*SCRIPT LANGUAGE="JScript"*}}
Print {var ExcelObj = new ActiveXObject("Excel.Application")}
Print {ExcelObj.Visible = true}
Print {var oWB = ExcelObj.Workbooks.Add()}
Print {var ExcelActiveSheet=oWB.ActiveSheet}
Print{ ExcelActiveSheet.cells(1, 1).value ="} + "YOURVIEWNAME" + {";}
Print{ ExcelActiveSheet.cells(1, 1).font.size = 12; }
Print{ ExcelActiveSheet.cells(1, 1).font.bold = true; }
\' Put your loop here and format the contents as required.
\' For more help on formatting content, check the marco in Excel for the objects.
Print {ExcelObj.Visible = true}
Print {ExcelObj.UserControl = true}
Print {var xlFileName = ExcelObj.GetSaveAsFilename("} + "YOURFILENAME" + {",
"Excel files (*.XLS), *.XLS");}
Print {if (xlFileName != "")}
Print {oWB.Saveas(xlFileName)}
Print {{*/SCRIPT*}}
base code is here, u can build on this.
cheers!!
P.S. {* è il tag di apertura HTML
*} è il tag di chiusura HTML
Daniele Grillo - Fondatore di Dominopoint.it
|