Indirect adressing in DB or in Array

[Dentim]

Hi everyone.
I need some help with a problem I'm having. Any help is greatly appreciated.

situation: I need a way to program a data table of integers in S7 STL. It's a table with 3 columns and 100 rows that I have available in Excel. When I ask for a specific row (from the row-number as integer), the three values need to be copied to MW's.

How can I use indirect adressing to load these values? Is it easier to use an array or three different DB's? Is there a fast way to get the values from Excel into the DB?

Thanks in advance and greetings,

Tim

 

[L D[AR2P#0.0]]

I would use three DBs, one for each column.

Example progam attached:

 

[Dentim]

Thanks alot! I don't think I would have figured that out on my own. Than you very much.