//get excel A1 ~ A26 cells' data
Excel.Range ColumnOne = xlsworksheet.get_Range("A1","A5");foreach (object element in ColumnOne.Value2)
{
// I wanna do something here
}Error:
foreach statement cannot operate on variables of type 'object' because 'object' does not contain a public definition for 'GetEnumerator'ColumnOne.Value2的定义及数值
Value2 {object[1..5, 1..1]} [1,1]= null
[2,1]= Hello
[3,1] = null
[4,1] = 123
[5,1] = 1.224foreach 如何遍历这个数组?
Excel.Range ColumnOne = xlsworksheet.get_Range("A1","A5");foreach (object element in ColumnOne.Value2)
{
// I wanna do something here
}Error:
foreach statement cannot operate on variables of type 'object' because 'object' does not contain a public definition for 'GetEnumerator'ColumnOne.Value2的定义及数值
Value2 {object[1..5, 1..1]} [1,1]= null
[2,1]= Hello
[3,1] = null
[4,1] = 123
[5,1] = 1.224foreach 如何遍历这个数组?
if (a is Array)
foreach (var o in (object[])a)
........
esle
........
这要写多少废代码[resolved]foreach (object element in (object[,])ColumnOne.Value2)
{
// I wanna do something here
}
想要弱类型可以去找js一类的脚本语言.