void test_createworkbook() { FileStream sw = new FileStream("input//1.xls", FileMode.Open, FileAccess.ReadWrite); IWorkbook iw = CIReportExcel.createworkbook(sw); Debug.Assert(iw.GetType() == typeof(HSSFWorkbook)); iw.Close(); sw.Close(); sw = new FileStream("input//1.xlsx", FileMode.Open, FileAccess.ReadWrite); iw = CIReportExcel.createworkbook(sw); Debug.Assert(iw.GetType() == typeof(XSSFWorkbook)); iw.Close(); sw.Close(); sw = new FileStream("input//LEURFV.xml", FileMode.Open); iw = CIReportExcel.createworkbook(sw); Debug.Assert(iw == null); sw.Close(); }
/// <summary> /// check this test result need check excel file in Debug. /// </summary> void test_generateExcel() { List <LEU> leus = new List <LEU>(); List <LEU_filtered_values.leu> leuinfos = new List <LEU_filtered_values.leu>(); for (int i = 0; i < 5; ++i) { LEU leu = new LEU($"leu{i}", i, $"CI{i % 2}"); leus.Add(leu); LEU_filtered_values.leu leuinfo = FileLoader.Load <LEU_filtered_values.leu>("input//LEURFV.xml"); leuinfo.NAME = new StringData(leu.Name); leuinfos.Add(leuinfo); } CIReportExcel excel = new CIReportExcel("..//..//..//BMGenTool//bin//Debug//Config//CI-LEU一致性测试报告 CI-LEU correspondence test report.xlsx", ".//", leus, leuinfos); using (FileStream sw = new FileStream("CI-LEU一致性测试报告 CI-LEU correspondence test report.xlsx", FileMode.Open, FileAccess.ReadWrite)) { IWorkbook workBook = CIReportExcel.createworkbook(sw); for (int pagei = 0; pagei < 2; ++pagei) { ISheet sheet = workBook.GetSheetAt(workBook.NumberOfSheets - 1 - pagei); for (int rowi = 16; rowi < 30; ++rowi) { IRow row = sheet.GetRow(rowi); if (null != row && row.Cells.Count() == 8) { haschecked = true; ICell cell = row.GetCell(0); Debug.Assert(0 == cell.StringCellValue.IndexOf("leu")); } } Debug.Assert(haschecked == true); haschecked = false; } workBook.Close(); sw.Close(); } }