matlab循环数组里的数据库,数组 – for循环中的MATLAB和单元数组处理

我是MATLAB的新手,想从我从数据库中获取的单元格数据中提取数据：

sensors =

[ 1] [23] [1] [ 0] [0.1000] [1x29 char]

[ 2] [23] [1] [120] [0.1000] [1x43 char]

[ 3] [23] [1] [120] [0.1000] [1x42 char]

[ 4] [23] [1] [ 15] [0.1000] 'Air Temp Grey Box'

[ 5] [23] [1] [120] [0.1000] [1x34 char]

[ 6] [23] [1] [120] [0.1000] [1x33 char]

[ 7] [23] [1] [120] [0.1000] 'Pool Water Temp'

[ 8] [23] [2] [ 0] [0.1000] [1x28 char]

[ 9] [23] [1] [ 30] [0.1000] [1x22 char]

[10] [23] [1] [ 30] [0.1000] [1x22 char]

[11] [23] [1] [ 30] [0.1000] [1x21 char]

[12] [23] [1] [ 15] [0.1000] [1x20 char]

[13] [23] [1] [ 15] [0.1000] [1x23 char]

[14] [23] [1] [ 30] [0.1000] [1x22 char]

[15] [23] [1] [ 15] [0.1000] 'Ground Air '

[16] [23] [1] [ 5] [0.1000] 'Boiler Cold Water'

[17] [23] [1] [ 5] [0.1000] 'Boiler Hot Water'

[18] [23] [1] [ 5] [0.1000] 'Boiler CH Flow'

[19] [23] [1] [ 5] [0.1000] 'Boiler CH Return'

现在我想抓住第一列,即数字1到19以及最后一列中的相应名称,并在for循环中使用它们,例如：

for ID=xxxx

str = num2str(ID);

SQLcommand = strcat('SELECT FROM data where ID=',str);

answer = database.exec(SQLcommand);

......

end

我已经尝试了几次不同的尝试,但从未成功获得其中一个元素.

感谢帮助:),提前谢谢.

轴突