Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private IEnumerable<TEntity> ReadExcel ()
- using (var stream = File.Open(path, FileMode.Open, FileAccess.Read))
- {
- using (var reader = ExcelReaderFactory.CreateReader(stream))
- {
- var result = reader.AsDataSet(new ExcelDataSetConfiguration()
- {
- UseColumnDataType = true,
- ConfigureDataTable = (data) => new ExcelDataTableConfiguration()
- {
- UseHeaderRow = true
- }
- });
- DataTableCollection tables = result.Tables;
- DataTable resultTable = tables[typeof(TEntity).Name];
- List<ChildFromJson> dataList = (from DataRow dr in resultTable.Rows
- select new ChildFromJson()
- {
- Uuid = dr["Uuid"].ToString(),
- Name = dr["Name"].ToString(),
- Titel = dr["Titel"].ToString(),
- Number= Convert.ToBoolean(dr["Number"]),
- Manual = Convert.ToBoolean(dr["Manual"]),
- Parent = dr["Parent"].ToString(),
- }).ToList();
- //To poniżej jak zrobić tak by było dobrze :)
- var klasser = dataList
- .Select(klasse => new TEntity
- {
- Uuid = class.Uuid,
- Name= class.Name,
- Titel = class.Titel,
- Number= class.Number,
- Manual = class.Manual,
- Parent = class.Parent
- });
- return klasser;
- }
- private class ParentFromJson
- {
- public IEnumerable<ChildFromJson> UnderClass{ get; set; }
- }
- private class ChildFromJson
- {
- public string Uuid { get; set; }
- public string Name{ get; set; }
- public string Titel { get; set; }
- public bool Number{ get; set; }
- public bool Manual { get; set; }
- public string Parent { get; set; }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement