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(); }