Support Query As DataTable

[shps951023]

e.g

stream.Query<DataTable>()

[shps951023]

Q: How to Query as DataTable

Note : There will be no advantage whatsoever in using MiniExcel for a scenario involving DataSet or DataTable.

public static DataTable QueryAsDataTable(string path)
{
    var rows = MiniExcel.Query(path, true);
    var dt = new DataTable();
    var first = true;
    foreach (IDictionary<string, object> row in rows)
    {
        if (first)
        {
            foreach (var key in row.Keys)
            {
                var type = row[key]?.GetType() ?? typeof(string);
                dt.Columns.Add(key, type);
            }

            first = false;
        }
        dt.Rows.Add(row.Values.ToArray());
    }
    return dt;
}