Excel Client:CopRun: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
No edit summary
No edit summary
 
(7 intermediate revisions by 3 users not shown)
Line 1: Line 1:
==CopRun(Executable, <nowiki>[</nowiki>Parameter1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Parameter10<nowiki>]</nowiki>)==
==[[Excel_Client:Functions_(Formulas)|Function]]==
 
<span {{CoPFormel}}>CopRun(Executable, <nowiki>[</nowiki>Parameter1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Parameter10<nowiki>]</nowiki>)</span>


The [[Excel_Client:Functions_(Formulas)|function]] CopRun can be used to use or influence various functions in the CoPlanner [[Excel Client|Excel Client]].  
The [[Excel_Client:Functions_(Formulas)|function]] CopRun can be used to use or influence various functions in the CoPlanner [[Excel Client|Excel Client]].  


===Parameter===
{| class="wikitable" width={{{breite|80%}}}
 
|- {{Tabellentitel}}
{| class="wikitable" width={{{breite|50%}}}
| width="150px"|Parameter
| Description
|-
|-
|width="200pt" style=background-color:#f6f6f6 |'''Executable''' 
|Executable
|Defines the function that must be executed.
|Defines the function that must be executed.
:*Transfer - Executes a transfer object ([[Framework:Imports|import object]]) on the server.
:*ReadValue - Corresponds to [[Excel_Client:CellRead|CellRead]]; however, the value is loaded from the server immediately without being cached in the client.
:*ReadSessionValue - Corresponds to the function CopExpression; however, the expression is sent to the server immediately, evaluated, and returned, without being cached.
|-
|-
|style=background-color:#f6f6f6 |'''ParameterX'''
|Parameter1..10
|Optional parameters.
|Optional parameters.
|}
|}


==Example==
<code>"CopRun"("Transfer:Auszufuerender_Import", "Filtername1:=Filterwert1", …)</code></br>
<code>"CopRun"("Transfer:Auszufuerender_Import")</code></br>
<code>"CopRun"("ReadValue:Umsatzerlose“, "Menge", 2Filtername1:=Filterwert1", …)</code></br>
<code>"CopRun"("ReadSessionValue:@Session_Plan_ID@")</code></br>
<code>"CopRun", "Macro:mkr_8393", ""</code>


===The following options are available===
{| class="wikitable" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''Transfer''' 
|Executes a transfer object ([[Framework:Imports|import object]]) on the server.
|-
|style=background-color:#f6f6f6 |'''ReadValue'''
|Corresponds to [[Excel_Client:CellRead|CellRead]]; however, the value is loaded from the server immediately without being cached in the client.
|-
|style=background-color:#f6f6f6 |'''ReadSessionValue'''
|Corresponds to the function CopExpression; however, the expression is sent to the server immediately, evaluated, and returned, without being cached.
|}
===Example===
{| class="wikitable" width={{{breite|50%}}}
|- {{Tabellentitel}}
|Function
|-
|CopRun(„Transfer:Auszufuerender_Import“, „Filtername1:=Filterwert1“, …)
|-
|CopRun(„Transfer:Auszufuerender_Import“)   
|-
|CopRun(„ReadValue:Umsatzerlose“, „Menge“, „Filtername1:=Filterwert1“, …)   
|-
|CopRun(„ReadSessionValue:@Session_Plan_ID@“)
|}


__NOTOC__


__NOEDITSECTION__
__NOEDITSECTION__
[[Category:Excel_Client_Formulas|CopRun]]
[[Category:Excel_Client_Formulas|CopRun]]
[[de:Excel_Client:CopRun]]
[[de:Excel_Client:CopRun]]

Latest revision as of 15:03, 9 April 2025

Function

CopRun(Executable, [Parameter1], …, [Parameter10])

The function CopRun can be used to use or influence various functions in the CoPlanner Excel Client.

Parameter Description
Executable Defines the function that must be executed.
  • Transfer - Executes a transfer object (import object) on the server.
  • ReadValue - Corresponds to CellRead; however, the value is loaded from the server immediately without being cached in the client.
  • ReadSessionValue - Corresponds to the function CopExpression; however, the expression is sent to the server immediately, evaluated, and returned, without being cached.
Parameter1..10 Optional parameters.

Example

"CopRun"("Transfer:Auszufuerender_Import", "Filtername1:=Filterwert1", …)
"CopRun"("Transfer:Auszufuerender_Import")
"CopRun"("ReadValue:Umsatzerlose“, "Menge", 2Filtername1:=Filterwert1", …)
"CopRun"("ReadSessionValue:@Session_Plan_ID@")
"CopRun", "Macro:mkr_8393", ""