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