meta data for this page
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:v8_0_0:installation:setupexcel [2020/07/23 13:49] sylvainair [Configuration for running Excel] |
en:v8_0_0:installation:setupexcel [2020/09/14 10:08] (current) sylvainair [Rights management] |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| The use of "Excel file" output type requires the execution of Excel via DCOM. | The use of "Excel file" output type requires the execution of Excel via DCOM. | ||
| + | |||
| + | <WRAP round info> | ||
| + | Since version 7.5, it is possible to generate "Excel file" type restitutions without using the MS Excel application. | ||
| + | To do this, you must choose to generate a document of the ''Excel 2007 Workbook'' type (without specifying a macro or requesting the updating of fields after data insertion). | ||
| + | </WRAP> | ||
| + | |||
| By default, DCOM is configured so that Excel is launched by the executing user. However, this is a problem when the call to Excel is made from a Windows service (case of the Vigilens Web interface) or from the task scheduler. | By default, DCOM is configured so that Excel is launched by the executing user. However, this is a problem when the call to Excel is made from a Windows service (case of the Vigilens Web interface) or from the task scheduler. | ||
| Line 21: | Line 27: | ||
| This setup is not documented by Microsoft</WRAP> | This setup is not documented by Microsoft</WRAP> | ||
| - | However, from our experience, it is functional and has the advantage of allowing MS Excel output in all cases, without having to modify the DCOM configuration for Excel : | + | However, from our experience, it is functional and **has the advantage** of allowing MS Excel output **in all cases**, without having to modify the DCOM configuration for Excel : |
| * whether there is an active Windows session or not on the server where Vigilens Web is installed (or on the computer/server where the scheduled requests are executed). | * whether there is an active Windows session or not on the server where Vigilens Web is installed (or on the computer/server where the scheduled requests are executed). | ||
| * In Web mode as in Windows mode (Vigilens Designer) | * In Web mode as in Windows mode (Vigilens Designer) | ||
| Line 28: | Line 34: | ||
| <WRAP round alert> | <WRAP round alert> | ||
| - | Sur une machine 64 bits, il peut s’avérer nécessaire de créer le répertoire suivant : ''C:\Windows\SysWOW64\config\systemprofile\Desktop'' </WRAP> | + | On a 64-bit machine, it may be necessary to create the following directory: ''C:\Windows\SysWOW64\config\systemprofile\Desktop'' </WRAP> |
| <WRAP round info> | <WRAP round info> | ||
| Line 34: | Line 40: | ||
| </WRAP> | </WRAP> | ||
| ==== Changing the DCOM settings ==== | ==== Changing the DCOM settings ==== | ||
| + | === For a given user === | ||
| + | |||
| <WRAP round important> | <WRAP round important> | ||
| This option has the advantage of allowing MS Excel reports even when no Windows session is active on the server where Vigilens Web is installed or on the computer/server where the scheduled requests are executed.</WRAP> | This option has the advantage of allowing MS Excel reports even when no Windows session is active on the server where Vigilens Web is installed or on the computer/server where the scheduled requests are executed.</WRAP> | ||
| Line 92: | Line 100: | ||
| * Giving the rights to this directory to users profiles | * Giving the rights to this directory to users profiles | ||
| * Modify the system variables TEMP and TMP so that they use a directory that is already accessible by users profiles. | * Modify the system variables TEMP and TMP so that they use a directory that is already accessible by users profiles. | ||
| + | |||