public void XmlReadDataTableUnit()
{
string path = Path.Combine(resource, "test.xlsx");
ReadExcelKit excelKit = new ReadExcelKit(path);
excelKit.AddConfig(config =>
{
config.SheetIndex = 1;
//config.ColumnNameRow = 1;
config.StartRow = 2;
//config.EndRow = 100;
config.ColumnSetting = new[] {
new ColumnConfig()
{
ColumnName = "Id", ColumnType = typeof(int), NormalType = ColumnNormal.Increment
},
new ColumnConfig()
{
ColumnName = "UniqueNo", ColumnType = typeof(Guid), NormalType = ColumnNormal.Guid
},
new ColumnConfig()
{
ColumnName = "CreateTime", ColumnType = typeof(DateTime), NormalType = ColumnNormal.NowDate
},
new ColumnConfig()
{
ColumnName = "测试1", ColumnType = typeof(string), Column = "A"
},
new ColumnConfig()
{
ColumnName = "测试2", ColumnType = typeof(string), Column = "B"
},
};
});
DataTable dt = excelKit.XmlReadDataTable();
}
