OLEDB External table is not in the expected format.

[shps951023]

[michelebastione]

@shps951023 I've tried the following and it worked without any problems:

var path = PathHelper.GetFile("xlsx/TestTypeMapping.xlsx");
var connString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={path};Extended Properties=\"Excel 12.0;HDR=YES\"";
using var conn = new OleDbConnection(connString);
conn.Open();
        
var schema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
var sheet = schema.Rows[0]["TABLE_NAME"].ToString();
        
using var cmd = conn.CreateCommand();
cmd.CommandText = $"SELECT * FROM [{sheet}]";
        
using var reader = cmd.ExecuteReader();
MiniExcel.SaveAs(@"c:\users\computer\desktop\tmp.xlsx", reader);

Maybe there's something irregular in your excel file?

[shps951023]

@michelebastione this issue from China's gitee https://gitee.com/dotnetchina/MiniExcel/issues/I53AVX (there're 221 issues 😅)

Issue code :
demo.zip

[shps951023]

using MiniExcelLibs;
using System.Data;
using System.Data.OleDb;

class Program
{
    static void Main()
    {
        var path = Path.GetTempPath() + Guid.NewGuid() + ".xlsx";
        var list = Enumerable.Range(0, 1000).Select(s => new { val = Guid.NewGuid(), val2 = Guid.NewGuid() });
        MiniExcel.SaveAs(path, list);
        Console.WriteLine(path);

        string connectionString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={path};Extended Properties=\"Excel 12.0 Xml;HDR=YES\";";

        try
        {
            using (OleDbConnection conn = new OleDbConnection(connectionString))
            {
                conn.Open();

                var schema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                var sheet = schema.Rows[0]["TABLE_NAME"].ToString();

                using var cmd = conn.CreateCommand();
                cmd.CommandText = $"SELECT * FROM [{sheet}]";

                using (var reader = cmd.ExecuteReader())
                {
                    for (int i = 0; i < reader.FieldCount; i++)
                    {
                        Console.Write($"{reader.GetName(i)}  ");
                    }
                    Console.WriteLine();
                }
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"Error：{ex.Message}");
        }
    }
}

[michelebastione]

Mmh ok I understand. I assume this is due to the fact that the generated xml even though it follows the openxml specifications is not quite "microsoft compliant".