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:designer:menus:accueil:nouvellerequete:restitution:excel [2020/09/25 14:31] sylvainair [Excel file] |
en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel [2021/02/01 16:44] (current) sylvainair [Mandatory parameters] |
||
|---|---|---|---|
| Line 37: | Line 37: | ||
| - | ===== Running from Excel by adapting the Macro ===== | ||
| - | [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel:exemplemacro|Macro example to be completed]] | ||
| ===== Running from Excel / Calling up external data ===== | ===== Running from Excel / Calling up external data ===== | ||
| - | The call of a Vigilens query from Excel is done through the menu''Data''→''External Data''→''From web''. \\ {{:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200702-135346.png?nolink&400}} | + | The call of a Vigilens query from Excel is done through the menu''Data''→''Get & transform data''→''From web''. \\ |
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200925-143334.png?nolink&650}} | ||
| + | |||
| + | url exemple : ''http://my-server/vigilens/table.php?vglCtrlName="%2FDEMO%2F01%20Fiche%20CLIENT"&vglOutput="XLTable"&CLIENT=4245&vglNumFormat="%2C%2E"&vglUserName="srivier"'' | ||
| + | |||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200925-143828.png?nolink&650}} | ||
| + | |||
| + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:pasted:20200925-143941.png?nolink&650}} | ||
| ==== Mandatory parameters ==== | ==== Mandatory parameters ==== | ||
| Line 59: | Line 65: | ||
| <WRAP round tip> | <WRAP round tip> | ||
| - | It is possible to automate this processing by using Excel macros. Here is an example of a macro to be adapted according to the needs:[[v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel:exemplemacro|Example macro]] | + | It is possible to automate this processing by using Excel macros. Here is an example of a macro to be adapted according to the needs:[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel:exemplemacro|Example macro]] |
| </WRAP> | </WRAP> | ||