When reading Excel, can return IDataReader and DataTable to facilitate the import of database. Like ExcelDataReader provide reader.AsDataSet()

[yfl8910]

No description provided.

[shps951023]

v 0.13.5 support this

e.g

            var path = PathHelper.GetNewTemplateFilePath();
            var value = new[] { new { Test1="1",Test2=2 }, new { Test1 = "3", Test2 = 4 } };
            MiniExcel.SaveAs(path, value);

            {
                var dt = MiniExcel.QueryAsDataTable(path, true);
                var columns = dt.Columns;
                Assert.Equal("Test1", dt.Columns[0].ColumnName);
                Assert.Equal("Test2", dt.Columns[1].ColumnName);
                Assert.Equal("1", dt.Rows[0]["Test1"]);
                Assert.Equal((double)2, dt.Rows[0]["Test2"]);
                Assert.Equal("3", dt.Rows[1]["Test1"]);
                Assert.Equal((double)4, dt.Rows[1]["Test2"]);
            }

            {
                var dt = MiniExcel.QueryAsDataTable(path, false);
                Assert.Equal("Test1", dt.Rows[0]["A"]);
                Assert.Equal("Test2", dt.Rows[0]["B"]);
                Assert.Equal("1", dt.Rows[1]["A"]);
                Assert.Equal((double)2, dt.Rows[1]["B"]);
                Assert.Equal("3", dt.Rows[2]["A"]);
                Assert.Equal((double)4, dt.Rows[2]["B"]);
            }