public void OpenXmlRead()
{
ReadExcelKit excelKit = new ReadExcelKit(@"C:\Users\zbb58\Desktop\test.xlsx");
excelKit.AddConfig(config =>
{
config.SheetIndex = 1;
config.ColumnNameRow = 1;
config.StartRow = 2;
});
DataTable dt = excelKit.ReadDataTable();
}
public void XmlReadSetUnit()
{
string path = Path.Combine(resource, "test.xlsx");
ReadExcelKit excelKit = new ReadExcelKit(path);
excelKit.AddConfig(config =>
{
config.SheetIndex = 1;
config.StartRow = 1;
//config.EndRow = 100;
//config.StartColumn = "B";
//config.EndColumn = "B";
});
var rows = excelKit.XmlReaderSet();
}
public void XmlReadDictionaryUnit()
{
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.StartColumn = "B";
//config.EndColumn = "B";
});
var dics = excelKit.XmlReaderDictionary();
}
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();
}
