ACE oleDb 驱动程序无法处理巨大的 Excel 文件

发布于 2024-10-17 01:52:36 字数 920 浏览 3 评论 0原文

ACE OLEDB 驱动程序对于较大的文件是否存在任何已知问题？我使用下面的代码检索 400Mb xls 文件中的工作表，

public string[] GetWorkSheets()
{
    var connectionString  = "Provider=Microsoft.ACE.OleDb.12.0; data source=c:\filepath\filename.xls; Extended Properties=\"Excel 8.0;IMEX=1;HDR=YES;\"";
    DataTable dataTable;
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        connection.Open();//Exception thrown here for large files
        dataTable = connection.GetSchema("Tables");
    }

    int lenght = dataTable.Rows.Count;
    string[] worksheets = new string[lenght];
    for (int i = 0; i < lenght; i++)
    {
        worksheets[i] = dataTable.Rows[i]["TABLE_NAME"].ToString();
    }
    return worksheets;
}

我收到 OleDbException，其中包含消息系统资源超出。在到达此处之前，我不会循环调用此函数，也不会打开任何其他连接。此代码非常适合较小的文件。

我的系统有 4Gb RAM。在 Windows 7 64 位上运行。 Ace 驱动程序也是 64 位的。

知道可以做些什么来解决这个问题吗？

原文

Does ACE OLEDB drivers have any known issues with larger files?
I am using the below code to retrieve the worksheets in a 400Mb xls file

public string[] GetWorkSheets()
{
    var connectionString  = "Provider=Microsoft.ACE.OleDb.12.0; data source=c:\filepath\filename.xls; Extended Properties=\"Excel 8.0;IMEX=1;HDR=YES;\"";
    DataTable dataTable;
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        connection.Open();//Exception thrown here for large files
        dataTable = connection.GetSchema("Tables");
    }

    int lenght = dataTable.Rows.Count;
    string[] worksheets = new string[lenght];
    for (int i = 0; i < lenght; i++)
    {
        worksheets[i] = dataTable.Rows[i]["TABLE_NAME"].ToString();
    }
    return worksheets;
}

I receive a OleDbException with the message System resource exceeded. I am not calling this function in loops, or opening any other connection before I reach here. This code works perfectly for smaller files.

My system has 4Gb RAM.Runs on Windows 7 64Bit. The Ace driver is also 64bit.

Any idea what can be done on fix this issue?

分享到QQ

分享到微博