Excel file

• File Type: Excel file type to be used to output the data:
  • Excel Template (*.xlt, *.xltx, *.xltm).
  • Classeur Excel (*.xls, *.xlsx, *.xlsm​).

• Define a file: define the name of the file and the location where the result of the query will be saved.

• Model: the file specified as a template allows you to use Excel to finalize the formatting of the query data (pivot table, graph, conditional formatting etc.) it is advisable to store the template in the shared directory of Vigilens to be sure that it is accessible during the execution of the query (especially in case of Web type execution).

• Location : Defines the location where Vigilens will deposit the result of the query (often used with templates to ensure consistency between the result obtained from Vigilens and the formatting done by Excel).

• Apply format set at Vigilens Level: Keeps the formatting defined in Vigilens (format, conditional formatting).

• Macro to launch: Automatic execution of a macro at the end of editing. For the macro to run, remember to uncheck the box “Remove personal information from file properties when saving” in the Excel options when saving the model.

Macro example to be completed

The call of a Vigilens query from Excel is done through the menuData→External Data→From web.

• Root Adress: http://<ServeurWeb>/vigilens/table.php?​
• vglOutput=XLTable&​
• vglCtrlName=<NomDeLaRequête>&
• vglUserName=<NomUtilisateur>​

See url syntax guide

You can keep formats by checking the box Format Text Only in the import options.

Once result imported into Excel, it is possible to refresh data with Update button.

For each parameter: ParameterCode = ParameterValue

Les valeurs numériques restituées utiliseront le premier caractère précisé comme séparateur de décimales, le second précisé comme séparateur de milliers.​