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 XLSX file.
Inputs
| Type | Name | Default | Description |
|---|---|---|---|
| ExternData.Types.ExternXLSXFile | xlsx | External Excel XLSX file object | |
| String | col | "A" | Column |
| String | sheetName | "" | Sheet name |
| Integer | startRow | 2 | Start row |
| Integer | endRow | ExternData.Functions.XLSX.getArrayRows2D(sheetName = sheetName, xlsx = xlsx) | End row |
Outputs
| Type | Name | Default | Description |
|---|---|---|---|
| Real | colSum | Column sum |