/// <summary> /// DataTable to list /// </summary> public void ToListTest() { var filePath = "..\\..\\TestUseFile\\TestExport.xlsx"; var excelHelperTwo = new NpoiHelper(filePath); string message; var tableTwo = excelHelperTwo.ExcelToDataTable(null, true, out message); List <PersonGattScheduleInfoDto> tableToList = DataTypeConvertHelper.ToList <PersonGattScheduleInfoDto>(tableTwo); tableTwo.Rows.Count.IsEqualTo(tableToList.Count); }
/// <summary> /// list to datatable slowly /// </summary> public void ToDataTableSlowlyTest() { var filePath = "..\\..\\TestUseFile\\TestExportLessData.xlsx"; var excelHelperTwo = new NpoiHelper(filePath); string message; var tableTwo = excelHelperTwo.ExcelToDataTable("sheet1", true, out message); List <PersonGattScheduleInfoDto> personGantScheduleInfoDtosList = DataTypeConvertHelper.ToList <PersonGattScheduleInfoDto>(tableTwo); var storgeTable = DataTypeConvertHelper.ToDataTable(personGantScheduleInfoDtosList); tableTwo.Rows.Count.IsEqualTo(storgeTable.Rows.Count); var i = 5; var j = 4; tableTwo.Rows[i][j].IsEqualTo(storgeTable.Rows[i][j]); }