AnsweredAssumed Answered

Create variables from Excel

Question asked by dagefo on Aug 20, 2014
Latest reply on Aug 20, 2014 by dagefo

Hello. I have an excel table which contains a list of wind turbine IDs and their associated sound power levels at various octave bands.

The table roughly looks like this...




Previous I have manually input the variables for each turbine as an array in the following format

T19 = [79.4, 89.4, 98.1, 100.2, 100.5, 97.9, 96.0, 90.2]


Now I am looking of a way to automate many lines from an excel table to automatically create a variable like I have done manually. I have successfully been able to print the data in the correct format but obviously this isn't setting it as a variable.


Does anyone have any ideas how I could achieve this?


Many thanks for your help