I have read this some time ago
(http://www.dominopower.com/issues/issue199901/domexcel001.html), and I've
found more interesting.
Briefly, you can read an HTML table in excel, then a web view, with the web
query tool.
You can deploy this with a excel file, template, or a .iqy file, wich contains
the query parameter.
If you embed the view in a form, and write a table row with formulas like
"=sum(a1:a100)", then you have totals, without write a LotusScript agent.
I love this tool, is a perfect example of power and semplicity.
bye
Francesco
PS: Lotus 1-2-3 also has a similar facility.
PPS: great site, Jack, I love you.
I have read this some time ago (http://www.dominopower.com/issues/issue199901/domexcel001.html), and I've found more interesting.
Briefly, you can read an HTML table in excel, then a web view, with the web query tool. You can deploy this with a excel file, template, or a .iqy file, wich contains the query parameter.
If you embed the view in a form, and write a table row with formulas like "=sum(a1:a100)", then you have totals, without write a LotusScript agent.
I love this tool, is a perfect example of power and semplicity.
bye Francesco
PS: Lotus 1-2-3 also has a similar facility. PPS: great site, Jack, I love you.