@Test public void testReadFixedRows() throws Exception { ExcelRange range = ExcelRange.sheetIndex(0).rowFrom(1).rowTo(2).columnRange("A", "G"); ExcelRangeData data = instance.readRange(range); assertEquals(2, data.getRowCount()); assertEquals("suilink", data.getString(0, 0)); assertEquals("广州穗灵通讯科技有限公司", data.getString(0, 1)); assertTrue(DateUtils.isSameDay(data.getDate(0, 2), parseDate(2002, 7, 1))); assertNull(data.getDate(0, 3)); assertEquals(1, data.getInt(0, 4).intValue()); assertEquals(1L, data.getLong(0, 4).longValue()); assertEquals(1.0, data.getDouble(0, 4).doubleValue(), 0.0001); assertNull(data.getDate(0, 5)); assertFalse(data.getBoolean(0, 6)); assertTrue(data.getBoolean(1, 6)); }
@Test(expected = IllegalStateException.class) public void testWrongDate() { ExcelRange range = ExcelRange.sheetIndex(0).rowFrom(1).rowTo(2).columnRange("A", "G"); ExcelRangeData data = instance.readRange(range); data.getDate(0, 1); }