.ExternData.Examples.XLSXTest.computeColSum

Information

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

Interface

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