OleDB导入Excel报错：Microsoft.ACE.OLEDB.12.0未注册，.xlsx无法导入求方案

Hey there, let's work through this problem together. Since you can't install the ACE provider, and .xls files import fine but .xlsx ones don't, here are some actionable workarounds that don't require extra tool installations:

1. Switch your project to compile as x86 (quick fix if 32-bit ACE exists) #

The error often pops up because your app is running in 64-bit mode, but the ACE provider is only installed as 32-bit (common if you have 32-bit Office). You can fix this without installing anything:

• Right-click your project in Visual Studio → Properties
• Go to the Build tab
• Set Platform target to x86
• Rebuild and test. If your system has the 32-bit ACE driver (from 32-bit Office), this should resolve the issue.

2. Use a pure .NET library like EPPlus (no OLEDB required) #

If you can add NuGet packages (assuming "can't install tools" refers to the ACE driver, not NuGet), libraries like EPPlus let you read/write .xlsx files directly without relying on OLEDB. Here's a concise example (under 100 lines):

using OfficeOpenXml;
using System.Data;
using System.IO;

// Set license context (required for newer EPPlus versions)
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

var filePath = @"C:\path\to\your\file.xlsx";
using (var package = new ExcelPackage(new FileInfo(filePath)))
{
    var worksheet = package.Workbook.Worksheets.First();
    DataTable dataTable = new DataTable();

    // Load column headers
    for (int col = 1; col <= worksheet.Dimension.End.Column; col++)
    {
        dataTable.Columns.Add(worksheet.Cells[1, col].Text);
    }

    // Load data rows
    for (int row = 2; row <= worksheet.Dimension.End.Row; row++)
    {
        DataRow dataRow = dataTable.NewRow();
        for (int col = 1; col <= worksheet.Dimension.End.Column; col++)
        {
            dataRow[col - 1] = worksheet.Cells[row, col].Text;
        }
        dataTable.Rows.Add(dataRow);
    }

    // Use dataTable for your import logic here
}

3. Read .xlsx directly with .NET's System.IO.Packaging (no external libraries) #

If you can't use NuGet at all, you can parse the Open XML format (which .xlsx uses) with .NET's built-in System.IO.Packaging namespace. It's a bit more verbose but works without any installs:

using System.IO;
using System.IO.Packaging;
using System.Xml;

var filePath = @"C:\path\to\your\file.xlsx";
using (Package package = Package.Open(filePath, FileMode.Open))
{
    // Get the first worksheet's XML part
    Uri sheetUri = PackUriHelper.CreatePartUri(new Uri("/xl/worksheets/sheet1.xml", UriKind.Relative));
    PackagePart sheetPart = package.GetPart(sheetUri);

    XmlDocument doc = new XmlDocument();
    doc.Load(sheetPart.GetStream());

    XmlNamespaceManager nsManager = new XmlNamespaceManager(doc.NameTable);
    nsManager.AddNamespace("sp", "http://schemas.openxmlformats.org/spreadsheetml/2006/main");

    // Iterate through rows and cells
    XmlNodeList rows = doc.SelectNodes("//sp:row", nsManager);
    foreach (XmlNode row in rows)
    {
        XmlNodeList cells = row.SelectNodes("sp:c", nsManager);
        foreach (XmlNode cell in cells)
        {
            XmlNode cellValue = cell.SelectSingleNode("sp:v", nsManager);
            Console.WriteLine(cellValue?.InnerText ?? "Empty cell");
        }
    }
}

Bonus: Add error logging since your error window won't open #

Since you can't access the error window, wrap your code in a try-catch block to log details to a file or console:

try
{
    // Your import logic here
}
catch (Exception ex)
{
    // Write error to a log file
    File.WriteAllText("import_error.log", $"Message: {ex.Message}\nStack Trace: {ex.StackTrace}");
    // Or print to console if applicable
    Console.WriteLine($"Error occurred: {ex.Message}");
}

These solutions all avoid relying on the ACE OLEDB provider, and all code stays under 100 lines. Pick the one that fits your environment best!

内容的提问来源于stack exchange，提问作者Gabriel Falieri