@Test public void testReadCells() throws Exception { KSheet sheet = getSampleSheet(); KCell cell = sheet.getCell( 1, 2 ); assertEquals( "One", cell.getValue() ); assertEquals( KCellType.LABEL, cell.getType() ); cell = sheet.getCell( 2, 2 ); assertEquals( KCellType.DATE, cell.getType() ); assertEquals( new Date( 1283817600000L ), cell.getValue() ); cell = sheet.getCell( 1, 3 ); assertEquals( "Two", cell.getValue() ); assertEquals( KCellType.LABEL, cell.getType() ); }
@Test public void testReadData() throws Exception { KSheet sheet1 = getSampleSheet(); assertEquals( 5, sheet1.getRows() ); KCell[] row = sheet1.getRow( 2 ); assertEquals( KCellType.LABEL, row[ 1 ].getType() ); assertEquals( "One", row[ 1 ].getValue() ); assertEquals( Double.valueOf( "75" ), row[ 5 ].getValue() ); row = sheet1.getRow( 3 ); assertEquals( KCellType.LABEL, row[ 1 ].getType() ); assertEquals( "Two", row[ 1 ].getValue() ); assertEquals( Double.valueOf( "117" ), row[ 5 ].getValue() ); row = sheet1.getRow( 4 ); assertEquals( KCellType.LABEL, row[ 1 ].getType() ); assertEquals( "Three", row[ 1 ].getValue() ); row = sheet1.getRow( 5 ); fail( "No out of bounds exception thrown when expected" ); } catch ( ArrayIndexOutOfBoundsException e ) {
for ( int j = 0; j < nrSheets; j++ ) { KSheet sheet = workbook.getSheet( j ); String sheetname = sheet.getName();
@Test public void testReadEmptyRow() throws Exception { KSheet sheet1 = getSampleSheet(); KCell[] row = sheet1.getRow( 0 ); assertEquals( "empty row expected", 0, row.length ); }