[lixinjun]

Hi everyone!
My objective is read some temperature-pressure dependent parameters to Fluent from some Excels in every iteration.
I have three Excels (“parameter_1.xlsx”, “parameter_2.xlsx” and “parameter_3.xlsx”) to describe these temperature-pressure dependent parameters.
Each Excel file have the "T", "P" and "parameter_n".
The excel date format is like,
T 10 20 30 40 50 …
P 0.1 0.2 0.3 0.4 0.5
10 0.1 0.4 0.2 0.2 0.8
20 0.3 0.2 0.5 0.2 0.9
30 0.5 0.2 0.1 0.1 0.2
40 0.7 0.2 0.8 0.3 0.4
50 0.1 0.2 0.2 0.6 0.2
…
In every iteration, I need to read these 3 parameters for each node by interpolation, based on excels.
Do anyone know a simple way to solve this problem?

I am waiting for an answer.
Thank you very much!

[thedal]

Originally Posted by lixinjun

Hi everyone!
My objective is read some temperature-pressure dependent parameters to Fluent from some Excels in every iteration.
I have three Excels (“parameter_1.xlsx”, “parameter_2.xlsx” and “parameter_3.xlsx”) to describe these temperature-pressure dependent parameters.
Each Excel file have the "T", "P" and "parameter_n".
The excel date format is like,
T 10 20 30 40 50 …
P 0.1 0.2 0.3 0.4 0.5
10 0.1 0.4 0.2 0.2 0.8
20 0.3 0.2 0.5 0.2 0.9
30 0.5 0.2 0.1 0.1 0.2
40 0.7 0.2 0.8 0.3 0.4
50 0.1 0.2 0.2 0.6 0.2
…
In every iteration, I need to read these 3 parameters for each node by interpolation, based on excels.
Do anyone know a simple way to solve this problem?

I am waiting for an answer.
Thank you very much!

Hi, Have you found answer to this question?