Change your model as follows:

Then add two lines to the beginning of your .xlsx file:

#1

double currentdata(151,2)

See the attached files. You can also enter the 151 value as a formula by having the spreadsheet calculate the number of rows (I just typed it). Save your file and then do a Save As and choose "Space Delimited Text". This file can be directly loaded in the combiTimeTable.

Your Combi TimeTable should look like this:

Regards

Neil

Attachments:

RCCurrentSource.xlsx

Dear Sergio, and all,

Tx very much, I'll check it out. For safety however I've uploaded my files, so communication is easier what I'm talking about. My model is RCGrid.mo. The tableCurrent component is located in the red square in the model. The data source is currently a list, but I would like to assign my external RCCurrentSource.xlsx data source the easiest way to it. (The list data and the Excel data are identical.)

Tx for all your nice help, best regards Andras

Attachments:

RCCurrentSource.xlsx

RCGrid.mo

Dear Sergio and Neil,

Tx very much for the kind reply. Just one more question: can I do it directly in System Modeler without Mathematica, or I have to use also Mathematica?

Tx very much in advance, best regards.

Andras

Dear Jan,

Yes, but how I do it? E.g. I open my RC System Modeler model, I click on the tableCurrent component, and under Parameters at the bottom I see table[:;:] . I suppose this is the place, where I could specify my external input, but I don't know, how. So far I was able to specify here a list only, which worked fine, but not an external Excel file (which would be more convenient for me.) So this is my question: is it possible to specify here an external Excel file as a times series data source for tableCurrent?

Tx for the kind advice in advance, best regards

Andras

ConnectSystemModelComponents, CreateSystemModel, SystemModel and SetSystemModel allow the possibility of providing parameter values and initial values in the process of model creation.

You can, for instance, make a copy of the Modelica.Electrical.Analog.Sources.TableCurrent component and give a value for the table parameter in a single step. Let's say you have already imported the two column excel table into Mathematica in the symbol currentData, which for the purpose of this example I am just going to write as a Table:

currentData = Table[{k, k}, {k, 0, 10}];

Then with

SystemModel[
 "Modelica.Electrical.Analog.Sources.TableCurrent",
 <|
  "ModelName" -> "ExampleOfTableCurrent",
  "ParameterValues" -> {"table" -> currentData}
  |>
 ]

you create a copy of the TableCurrent component with the name "ExampleOfTableCurrent" and with currentData as the value for the table parameter. Now you can use this component in any other model as you wish.

Dear Sergio,

Thank you very much, I'll follow your instructions. I learned a lot, tx indeed.

Tx for the kind help, all the best

Andras

Dear Sergio,

Thank you very much for the kind help. This is great! Pls. give me some time to explore it, many unknown stuff here for me. So you say these commands will put some files to a directory (where?) and I can open them with System Modeler's Open command, and run it? Which one should I open?

Tx very much for the kind help once again, best regards Andras

WOW, this does help me, I also have the same problem before and still got no answer on how. THANK YOU