Excel-DNA：一维数组限制为 65536 行

Excel-DNA是一款用于在Excel中扩展功能的工具。它为用户提供了更多的自由度，使其能够通过编写自定义函数和宏来实现更多的操作。然而，使用Excel-DNA时需要注意一维数组的限制，即一维数组的最大行数为65536行。在本文中，我们将介绍Excel-DNA的一维数组限制，并提供一个案例代码来说明这一限制的影响。

csharp
using ExcelDna.Integration;
public class ArrayExample
{
    [ExcelFunction(Description = "Sum of an array")]
    public static double ArraySum(double[] array)
    {
        double sum = 0;
        foreach (double value in array)
        {
            sum += value;
        }
        return sum;
    }
}

csharp
using ExcelDna.Integration;
public class ArrayExample
{
    [ExcelFunction(Description = "Sum of a large array")]
    public static double LargeArraySum(double[] array)
    {
        double sum = 0;
        int batchSize = 65536;
        int iterations = array.Length / batchSize;
        for (int i = 0; i < iterations; i++)
        {
            double[] subArray = new double[batchSize];
            Array.Copy(array, i * batchSize, subArray, 0, batchSize);
            sum += ArraySum(subArray);
        }
        int remainder = array.Length % batchSize;
        if (remainder > 0)
        {
            double[] subArray = new double[remainder];
            Array.Copy(array, iterations * batchSize, subArray, 0, remainder);
            sum += ArraySum(subArray);
        }
        return sum;
    }
    [ExcelFunction(Description = "Sum of an array")]
    private static double ArraySum(double[] array)
    {
        double sum = 0;
        foreach (double value in array)
        {
            sum += value;
        }
        return sum;
    }
}