请教各位一个问题
var wk = new XSSFWorkbook(@"C:\Users\Administrator\Desktop\1.xlsx");
var st = wk.GetSheetAt(0);
for (var i = 0; i <= st.LastRowNum; i++)
{
var currentCell = st.GetRow(i).GetCell(0);
var realFlux = currentCell.NumericCellValue;
}
上面是我读取excel文件的代码,realFlux有4个double型的数值,
var sel = uiDoc.Selection.GetElementIds();
foreach (var item in collector)
{
Pipe pipe = item as Pipe;
IList<Parameter> parameters = pipe.GetParameters("设计流量");
foreach (var flux in parameters)
{
double designedFlux = flux.AsDouble();
if (designedFlux > 200)
{
sel.Add(item.Id);
}
}
}
uiDoc.Selection.SetElementIds(sel);
return Result.Succeeded;
这是我读取参数的代码,designedFlux也是有4个double型的数。但是我把第一个for循环放在下面的foreach中也就是
var sel = uiDoc.Selection.GetElementIds();
foreach (var item in collector)
{
Pipe pipe = item as Pipe;
IList<Parameter> parameters = pipe.GetParameters("设计流量");
foreach (var flux in parameters)
{
double designedFlux = flux.AsDouble();
for (var i = 0; i <= st.LastRowNum; i++)
{
var currentCell = st.GetRow(i).GetCell(0);
var realFlux = currentCell.NumericCellValue;
if (designedFlux - realFlux > 200)
{
sel.Add(item.Id);
}
}
}
}
uiDoc.Selection.SetElementIds(sel);
return Result.Succeeded;
我想让designedFlux和 realFlux的4个数做一个减法得到差值,发现每个变量都是16个数了。这个问题要怎么解决啊