Versions Compared

Old Version 21

changes.mady.by.user Hees, Maarten van

Saved on

compared with

New Version 22

changes.mady.by.user Hees, Maarten van

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

EXCEL# returns the result of an EXCEL spreadsheet calculation in TeLiTab format

Syntax

EXCEL#(Mode%, SourceSheet$, TargetSheet$, TelitabInput$, InputScript$, OutputScript$, [InpVar])

Arguments

  • Mode% controls the modus of EXCEL (0 if you don't want to see the sheet, 1 if you want the sheet to be visible).
  • SourceSheet$ is the file name of the Excel sheet.
    • If no path is included in the string for SourceSheet$, the file is expected to be in the applications directory of the knowledge base (see also Directory structure ).
    • If "NullString" is provided as value for SourceSheet$, the sheet has to be embedded in the expression using the right mouse option "Include Binary in frame...".
  • TargetSheet$ is the name under which the created Excel sheet will be saved.
    • If no path is included in the string for TargetSheet$, the file is saved on the current Report/Project (..\My knowledge\Project\..) directory of this project (see also Directory structure ).
    • If "NullString" is provided as value, the sheet will not be saved at all.
  • TelitabInput$ is the dataset that can be used as input for the calculation (not required as long as all data required for InputScript$ is available).
  • InputScript$ is the input script (in TeLiTab format) in which the positions in the spreadsheet are stated.
  • OutputScript$ is the output script (in TeLiTab format) in which the positions are given of the data in the sheet to be presented as Telitab$ output of the parameter using the EXCEL#() function.
    Parameters in OutputScript$ should also be defined in InputScript$ with an empty spreadsheet position when you want to receive these values as input for Quaestor. This means that Quaestor will deal with these values provided as input in the solution, while these values where originally not provided but only given to in the spreadsheet. (see also examples).
  • InpVar is an optional list of parameters or expessions. The list may contain one or more parameters required by the InputScript$ of the EXCEL#() function when these are not included in TelitabInput$. In such event, the current case values of the parameters presented in InputScript$ (and included in InpVar or computed earlier) are used as input for the EXCEL file.

...