Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook getNumberOfSheets

List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook getNumberOfSheets

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFWorkbook
  6. getNumberOfSheets

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFWorkbook getNumberOfSheets.

Prototype

@Override
public int getNumberOfSheets()

Source Link

Document

get the number of spreadsheets in the workbook (this will be three after serialization)

Usage

From source file:uk.co.spudsoft.birt.emitters.excel.tests.BasicReportTest.java

License:Open Source License

@Test
public void testRunReportWithJpegXlsZerosRenderOption() throws BirtException, IOException {

    displayZeros = false;/*from  www.ja va  2 s.  co m*/
    InputStream inputStream = runAndRenderReport("SimpleWithJpeg.rptdesign", "xls");
    assertNotNull(inputStream);
    try {
        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Simple Test Report", workbook.getSheetAt(0).getSheetName());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(false, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.BasicReportTest.java

License:Open Source License

@Test
public void testRunReportWithJpegXlsZerosReport() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("SimpleWithJpegHideZeros.rptdesign", "xls");
    assertNotNull(inputStream);/*w  w w .  j a  va2s  .c om*/
    try {
        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Simple Test Report", workbook.getSheetAt(0).getSheetName());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(false, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.BigCrosstabTest.java

License:Open Source License

@Test
public void testXls() throws Exception {

    InputStream inputStream = runAndRenderReport("BigCrosstab.rptdesign", "xls");
    assertNotNull(inputStream);//from   w w  w .ja  va  2 s  . c o m
    try {

        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(33, workbook.getNumCellStyles());
        assertEquals("Big Crosstab Report 1", workbook.getSheetAt(0).getSheetName());

        assertEquals(60, workbook.getSheetAt(0).getRow(1).getCell(2).getCellStyle().getRotation());
        assertEquals(60, workbook.getSheetAt(0).getRow(2).getCell(2).getCellStyle().getRotation());
        assertEquals(60, workbook.getSheetAt(0).getRow(2).getCell(3).getCellStyle().getRotation());
        assertEquals(0, workbook.getSheetAt(0).getRow(3).getCell(2).getCellStyle().getRotation());

        assertTrue(runTime - startTime < 4000L);
        assertTrue(renderTime - runTime < 4000L);

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(236, firstNullRow(sheet));

        assertEquals(28, greatestNumColumns(sheet));

    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Borders1ReportTest.java

License:Open Source License

@Test
public void testRunReportXls() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("Borders1.rptdesign", "xls");
    assertNotNull(inputStream);/*from ww  w. j a va 2 s  .c om*/
    try {

        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Borders Test Report 1", workbook.getSheetAt(0).getSheetName());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(12, firstNullRow(sheet));

        int i = 0;
        assertBorder(sheet, i++, 0, CellStyle.BORDER_THIN, CellStyle.BORDER_THIN, CellStyle.BORDER_THIN,
                CellStyle.BORDER_THIN);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_THICK, CellStyle.BORDER_THICK, CellStyle.BORDER_THICK,
                CellStyle.BORDER_THICK);

        assertBorder(sheet, i++, 0, CellStyle.BORDER_DOTTED, CellStyle.BORDER_DOTTED, CellStyle.BORDER_DOTTED,
                CellStyle.BORDER_DOTTED);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_DOTTED, CellStyle.BORDER_DOTTED, CellStyle.BORDER_DOTTED,
                CellStyle.BORDER_DOTTED);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_DOTTED, CellStyle.BORDER_DOTTED, CellStyle.BORDER_DOTTED,
                CellStyle.BORDER_DOTTED);

        assertBorder(sheet, i++, 0, CellStyle.BORDER_DASHED, CellStyle.BORDER_DASHED, CellStyle.BORDER_DASHED,
                CellStyle.BORDER_DASHED);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_MEDIUM_DASHED, CellStyle.BORDER_MEDIUM_DASHED,
                CellStyle.BORDER_MEDIUM_DASHED, CellStyle.BORDER_MEDIUM_DASHED);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_MEDIUM_DASHED, CellStyle.BORDER_MEDIUM_DASHED,
                CellStyle.BORDER_MEDIUM_DASHED, CellStyle.BORDER_MEDIUM_DASHED);

        assertBorder(sheet, i++, 0, CellStyle.BORDER_DOUBLE, CellStyle.BORDER_DOUBLE, CellStyle.BORDER_DOUBLE,
                CellStyle.BORDER_DOUBLE);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_DOUBLE, CellStyle.BORDER_DOUBLE, CellStyle.BORDER_DOUBLE,
                CellStyle.BORDER_DOUBLE);
        assertBorder(sheet, i++, 0, CellStyle.BORDER_DOUBLE, CellStyle.BORDER_DOUBLE, CellStyle.BORDER_DOUBLE,
                CellStyle.BORDER_DOUBLE);

    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Borders3ReportTest.java

License:Open Source License

@Test
public void testRunReportXls() throws BirtException, IOException {

    debug = false;//from   w w  w.  jav  a  2s.  c om
    removeEmptyRows = false;
    InputStream inputStream = runAndRenderReport("Borders3.rptdesign", "xls");
    assertNotNull(inputStream);
    try {

        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Borders Test Report 3", workbook.getSheetAt(0).getSheetName());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(26, firstNullRow(sheet));

        Borders2ReportTest.assertBorder(sheet, 0, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 0, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 0, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 0, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 0, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 0, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 0, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 0, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 1, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 1, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 1, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 1, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 1, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 1, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 1, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 1, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 2, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 2, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 2, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 2, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 2, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 2, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 2, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 2, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 0, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 6, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 3, 7, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 4, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 5, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 5, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 5, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 5, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 5, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 5, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 5, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 5, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 6, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 6, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 6, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 6, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 6, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 6, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 6, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 6, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 7, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 8, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 9, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 9, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 9, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 9, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 9, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 9, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 9, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 9, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 10, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 11, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 11, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 11, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 11, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 11, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 11, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 11, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 11, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 12, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 13, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 14, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 15, 0, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 15, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 15, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 15, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 15, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 15, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 15, 6, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 15, 7, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 16, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 16, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 16, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 16, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 16, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 16, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 16, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 16, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 17, 0, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 17, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 17, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 17, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 17, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 17, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 17, 6, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 17, 7, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 0, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 4, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 6, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 18, 7, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 19, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 19, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 19, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 19, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 19, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 19, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 19, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 19, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 20, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 21, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 21, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 21, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 21, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 21, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 21, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 21, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 21, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 22, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 22, 1, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 22, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 22, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 22, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 22, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 22, 6, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 22, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 23, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 23, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 23, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 23, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 23, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 23, 5, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 23, 6, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 23, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 24, 0, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 24, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 24, 2, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 24, 3, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 24, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 24, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 24, 6, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 24, 7, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 25, 0, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM);
        Borders2ReportTest.assertBorder(sheet, 25, 1, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 25, 2, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 25, 3, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 25, 4, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 25, 5, CellStyle.BORDER_NONE, CellStyle.BORDER_NONE,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 25, 6, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_MEDIUM,
                CellStyle.BORDER_NONE, CellStyle.BORDER_NONE);
        Borders2ReportTest.assertBorder(sheet, 25, 7, CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE,
                CellStyle.BORDER_MEDIUM, CellStyle.BORDER_NONE);

    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.CurrencyFormatsTest.java

License:Open Source License

@Test
public void testRunReportXls() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("CurrencyFormats.rptdesign", "xls");
    assertNotNull(inputStream);/*from  www.  j  ava 2s.c  o  m*/
    try {

        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Currency Formats Test Report", workbook.getSheetAt(0).getSheetName());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(5, this.firstNullRow(sheet));

        DataFormatter formatter = new DataFormatter();

        assertEquals("3141.59", formatter.formatCellValue(sheet.getRow(1).getCell(1)));
        assertEquals("$3141.59", formatter.formatCellValue(sheet.getRow(2).getCell(1)));
        assertEquals("3141.59", formatter.formatCellValue(sheet.getRow(3).getCell(1)));
        assertEquals("3141.59", formatter.formatCellValue(sheet.getRow(4).getCell(1)));
    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.GridsTests.java

License:Open Source License

@Test
public void testRunReportXls() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("CombinedGrid.rptdesign", "xls");
    assertNotNull(inputStream);/*from w  ww .  j av a  2 s .c o  m*/
    try {

        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Combined Grid Report", workbook.getSheetAt(0).getSheetName());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(3, this.firstNullRow(sheet));

        DataFormatter formatter = new DataFormatter();

        assertEquals(
                "This is a label\nHeading 1\nThis is text\nHeading 2\nStyles\nBold, Italic, Bold and italic and finally Underline.\n Oh\n Dear\nIsle of Mann\nPlain text.\nAnd this is a label",
                formatter.formatCellValue(sheet.getRow(0).getCell(1)));
        assertEquals(CellStyle.ALIGN_GENERAL, sheet.getRow(0).getCell(1).getCellStyle().getAlignment());
        assertEquals(13, sheet.getRow(0).getCell(1).getRichStringCellValue().numFormattingRuns());
        assertEquals("Hello", formatter.formatCellValue(sheet.getRow(1).getCell(0)));
        assertEquals("End", formatter.formatCellValue(sheet.getRow(2).getCell(0)));

    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.HyperlinksTest.java

License:Open Source License

@Test
public void testHyperlinksXls() throws BirtException, IOException {

    debug = false;/*  www . j a  v a 2s. co  m*/
    InputStream inputStream = runAndRenderReport("Hyperlinks.rptdesign", "xls");
    assertNotNull(inputStream);
    try {
        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(2002, this.firstNullRow(sheet));

        for (int i = 1; i < 2000; ++i) {
            assertEquals("http://www.spudsoft.co.uk/?p=" + i,
                    sheet.getRow(i).getCell(0).getHyperlink().getAddress());

            assertEquals("_BK" + (i + 1000), sheet.getRow(i).getCell(1).getHyperlink().getAddress());
        }

    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue26.java

License:Open Source License

@Test
public void testMultiRowEmptinessXls() throws BirtException, IOException {

    debug = false;/*from ww  w  .java  2 s . c om*/
    InputStream inputStream = runAndRenderReport("Issue26.rptdesign", "xls");
    assertNotNull(inputStream);
    try {
        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(3, this.firstNullRow(sheet));

        assertEquals("Hello\n\nMatey", sheet.getRow(1).getCell(0).getStringCellValue());
        assertEquals(41.3, sheet.getRow(1).getHeightInPoints(), 0.01);
        assertEquals(55.1, sheet.getRow(2).getHeightInPoints(), 0.01);

    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue29.java

License:Open Source License

@Test
public void testMultiRowEmptinessXls() throws BirtException, IOException {

    debug = false;/*from  w w  w  . j  ava  2s.c  o m*/
    InputStream inputStream = runAndRenderReport("Issue29.rptdesign", "xls");
    assertNotNull(inputStream);
    try {
        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(6, this.firstNullRow(sheet));

        for (int i = 0; i < 4; ++i) {
            for (Cell cell : sheet.getRow(i)) {
                assertEquals(0, cell.getCellStyle().getBorderTop());
                assertEquals(0, cell.getCellStyle().getBorderLeft());
                assertEquals(0, cell.getCellStyle().getBorderRight());
                assertEquals(0, cell.getCellStyle().getBorderBottom());
            }
        }
        assertEquals("Bibble", sheet.getRow(5).getCell(0).getStringCellValue());
        assertEquals(24.0, sheet.getRow(0).getHeightInPoints(), 0.1);

    } finally {
        inputStream.close();
    }
}