/** * name. * * @throws Exception if occur */ @Test public void extractName() throws Exception { ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor(); Sheet sheet = sheet("name.xls"); assertThat(extractor.extractName(sheet.getRow(3)), is("value")); assertThat(extractor.extractName(sheet.getRow(4)), is("a")); assertThat(extractor.extractName(sheet.getRow(5)), is("very_long_name")); }
/** * name - invalid type. * * @throws Exception if occur */ @Test(expected = ExcelRuleExtractor.FormatException.class) public void extractName_invalid() throws Exception { ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor(); Sheet sheet = sheet("name.xls"); extractor.extractName(sheet.getRow(8)); }
/** * name - blank cell. * * @throws Exception if occur */ @Test public void extractName_blank() throws Exception { ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor(); Sheet sheet = sheet("name.xls"); assertThat(extractor.extractName(sheet.getRow(7)), is(nullValue())); }