Java tutorial
/************************************************************************************* * Copyright (c) 2011, 2012, 2013 James Talbut. * jim-emitters@spudsoft.co.uk * * All rights reserved. This program and the accompanying materials * are made available under the terms of the Eclipse Public License v1.0 * which accompanies this distribution, and is available at * http://www.eclipse.org/legal/epl-v10.html * * Contributors: * James Talbut - Initial implementation. ************************************************************************************/ package uk.co.spudsoft.birt.emitters.excel.tests; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertNotNull; import java.io.IOException; import java.io.InputStream; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.eclipse.birt.core.exception.BirtException; import org.junit.Test; public class Issue61SheetNameWithGroups extends ReportRunner { @Test public void testIssue61() throws BirtException, IOException { debug = false; InputStream inputStream = runAndRenderReport("Issue61SheetNameWithGroups.rptdesign", "xlsx"); assertNotNull(inputStream); try { XSSFWorkbook workbook = new XSSFWorkbook(inputStream); assertNotNull(workbook); assertEquals(327, workbook.getNumberOfSheets()); Sheet firstSheet = workbook.getSheetAt(0); assertEquals(7, this.firstNullRow(firstSheet)); assertEquals("10100", firstSheet.getSheetName()); for (Sheet sheet : workbook) { if (!"Sheet326".equals(sheet.getSheetName())) { assertEquals(Integer.toString((int) sheet.getRow(1).getCell(0).getNumericCellValue()), sheet.getSheetName()); } } } finally { inputStream.close(); } } }