用于Excel工作簿的OleDb方案不显示模式中的行(OleDb scheme for excel workbook not showing rows in schema)

 发生什么事 
 
 跑完后： 
 
prePickNumbers(four, 4, 40, 20, 1);
 
 ... four.myArraysCombined的值是： 
 
[[[2, 17, 20, 1], [7, 2, 20, 11], [7, 14, 3, 16], [12, 17, 3, 8]]]
 
 换句话说，这不是你声称它的结果。 在继续之前，您应该验证您是否具有您认为在流程的每个步骤中执行的结果。 就目前而言，您没有扁平阵列。 您需要先修复它，然后继续迭代和求和。 
 
 为什么会这样 
 
 最终结构的原因从prePickNumbers中的以下行开始： 
 
tempMyArraysCombined.push(objName.myArray[x]);
 
 您每次都将数组推入另一个数组，因此循环后的结果是数组数组。 但是，然后，您将该结果推送到另一个数组： 
 
objName.myArraysCombined.push(tempMyArraysCombined);
 
 所以最终的结果实际上是一个包含数组数组的数组（注意上面输出中额外的括号组）。 问题是你在整个过程中的每个步骤都将整个数组推送到输出中，这会产生嵌套的混乱。 你应该推动每个数组的元素 ，而不是数组本身。 
 
 如何解决它 
 
 这是一个可能的解决方案。 用以下函数替换prePickNumbers ： 
 
function prePickNumbers(objName, theNum, theSumNum, theMaxNum, theMinNum) {
    var tempMyArraysCombined = [];
    for (var x = 0; x < theNum; x += 1) {
        pickNumbers(objName.myArray[x], theNum, theSumNum, theMaxNum, theMinNum);
        for (var j = 0; j < objName.myArray[x].length; j++) {
            objName.myArraysCombined.push(objName.myArray[x][j]);
        }
    }
}

What is happening
 
After running:
 
prePickNumbers(four, 4, 40, 20, 1);
 
...the value of four.myArraysCombined is:
 
[[[2, 17, 20, 1], [7, 2, 20, 11], [7, 14, 3, 16], [12, 17, 3, 8]]]
 
In other words, it is not the result that you claim it is. You should verify that you have the result that you think you do at each step of the process, before moving on. As it stands, you do not have a flattened array. You need to fix that first and then move on to iterating and summing.
 
Why this is happening
 
The reason for the final structure starts at the following line in prePickNumbers:
 
tempMyArraysCombined.push(objName.myArray[x]);
 
You're pushing an array into another array each time, so the result after the loop is an array of arrays. But, then, you push that result into another array:
 
objName.myArraysCombined.push(tempMyArraysCombined);
 
So the final result is actually an array containing an array of arrays (notice the extra set of brackets in the output above). The problem is that you're pushing an entire array into your output at each step in the process, which is creating a nested mess. You should be pushing elements of each array, not the arrays themselves.
 
How to fix it
 
Here is one possible solution. Replace prePickNumbers with the following function:
 
function prePickNumbers(objName, theNum, theSumNum, theMaxNum, theMinNum) {
    var tempMyArraysCombined = [];
    for (var x = 0; x < theNum; x += 1) {
        pickNumbers(objName.myArray[x], theNum, theSumNum, theMaxNum, theMinNum);
        for (var j = 0; j < objName.myArray[x].length; j++) {
            objName.myArraysCombined.push(objName.myArray[x][j]);
        }
    }
}