functioncomputeColSum
Compute column sum
Extends from Modelica.Icons.Function (Icon for functions).
Information
This function computes the column sum of a given column and sheet of an Excel XLS file.
Inputs
| Type | Name | Default | Description |
|---|---|---|---|
| ExternData.Types.ExternXLSFile | xls | External Excel XLS file object | |
| String | col | "A" | Column |
| String | sheetName | "" | Sheet name |
| Integer | startRow | 2 | Start row |
| Integer | endRow | ExternData.Functions.XLS.getArrayRows2D(sheetName = sheetName, xls = xls) | End row |
Outputs
| Type | Name | Default | Description |
|---|---|---|---|
| Real | colSum | Column sum |