//TODO: Make this method more generic...! public static WorkType ExcelDataToWorkTypeObjectMapper(RowItem excelData) { int index = 0; WorkType wt = new WorkType { Name = excelData.Columns.Select(x => x.ColumnValue).First(), UnitOfWorkTime = new MeasurementUnits(double.Parse(excelData.Columns.ElementAt(++index).ColumnValue), excelData.Columns.ElementAt(++index).ColumnValue), }; return(wt); }
public static List <RowItem> ParseDataToRowItemsFromExcelFile(string filename) { List <RowItem> outList = new List <RowItem>(); using (var stream = File.Open(filename, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { var dataSet = GetDataSetFromExcelDataReader(reader); var dataTable = dataSet.Tables[0]; for (var i = 2; i < dataTable.Rows.Count; i++) { RowItem ri = new RowItem(i); for (var j = 0; j < dataTable.Columns.Count; j++) { ri.Columns.Add(new ColumnItem(dataTable.Rows[i][j].ToString())); } outList.Add(ri); } } } return(outList); }