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


function computeColSum
  extends Modelica.Icons.Function;
  input ExternData.XLSFile xlsfile "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 = xlsfile.xls) "End row";
  output Real colSum "Column sum";
end computeColSum;

Generated at 2020-06-02T01:38:30Z by OpenModelicaOpenModelica 1.16.0~dev-420-gc007a39 using GenerateDoc.mos