.ExternData.Examples.XLSTest.computeColSum

Information

This function computes the column sum of a given column and sheet of an Excel XLS file.

Interface

function computeColSum
  extends Modelica.Icons.Function;
  input ExternData.XLSFile dataSource "Excel XLS file record";
  input String col = "A" "Column";
  input String sheetName = "" "Sheet name";
  input Integer startRow = 2 "Start row";
  input Integer endRow = ExternData.Functions.XLS.getArrayRows2D(sheetName = sheetName, xls = dataSource.xls) "End row";
  output Real colSum "Column sum";
end computeColSum;