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