Example usage for org.apache.poi.xssf.usermodel XSSFSheet getSheetName

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFSheet getSheetName.

Prototype

@Override
public String getSheetName() 

Source Link

Document

Returns the name of this sheet

Usage

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("Grouping.rptdesign", "xlsx");
    assertNotNull(inputStream);/*from  w  ww.  j  av  a2  s .  co  m*/
    try {

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

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 1, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 1, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, i == 1 ? 0 : 1,
                            sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, i == 1 ? 0 : 1,
                            sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 1, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 1, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    disableGrouping = Boolean.TRUE;
    InputStream inputStream = runAndRenderReport("Grouping.rptdesign", "xlsx");
    disableGrouping = null;//from  w w w  .  j a v  a  2  s  . c o  m
    assertNotNull(inputStream);
    try {

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

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("GroupingDisabledAtReport.rptdesign", "xlsx");
    assertNotNull(inputStream);//from   w w w  . j  a va  2  s .  co m
    try {

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

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("GroupingDisabledAtTable.rptdesign", "xlsx");
    assertNotNull(inputStream);/* ww w.  j a v a2s  .c o  m*/
    try {

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

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 1, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, i == 1 ? 0 : 1,
                            sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

From source file:WeeklyOPD.Department.java

License:Open Source License

public static void mainCreateExcelAndInitialize() {
    file1 = null;//  ww w .j ava 2  s.co m
    file2 = null;
    fileOldIn = null;
    try {

        file1 = new FileInputStream(new File(path + "new.xlsx"));

        XSSFWorkbook workbook1 = new XSSFWorkbook(file1);

        //Get first sheet from the workbook1
        sheetAll = workbook1.getSheetAt(0);
        //Get second sheet from the workbook1
        sheetFemale = workbook1.getSheetAt(1);

        file2 = new FileInputStream(new File(path + "children.xlsx"));

        XSSFWorkbook workbook2 = new XSSFWorkbook(file2);

        //Get first sheet from the workbook2
        sheetChildren = workbook2.getSheetAt(0);

        fileOldIn = new FileInputStream(new File(path + "old.xlsx"));
        workbookOld = new XSSFWorkbook(fileOldIn);

    } catch (Exception e) {
        System.err.println("Error opening files for reading.");
        e.printStackTrace();
    }

    //For writing
    workbook = new XSSFWorkbook();
    sheetNew = workbook.createSheet("Generated File - Do not edit");
    //Create a new row in current sheet for heading.
    Row row = sheetNew.createRow(0);
    //Create a new cell in current row
    Cell cell = row.createCell(0);
    //Set value to new value
    cell.setCellValue("Department");
    cell = row.createCell(1);
    cell.setCellValue("Patient Type");
    cell = row.createCell(2);
    cell.setCellValue("CR No.");
    cell = row.createCell(3);
    cell.setCellValue("Name");
    cell = row.createCell(4);
    cell.setCellValue("Guardian's Name");
    cell = row.createCell(5);
    cell.setCellValue("Relation");
    cell = row.createCell(6);
    cell.setCellValue("AgeYrs");
    cell = row.createCell(7);
    cell.setCellValue("Gender");
    cell = row.createCell(8);
    cell.setCellValue("Address");
    cell = row.createCell(9);
    cell.setCellValue("City");
    cell = row.createCell(10);
    cell.setCellValue("State");

    //Fill depttToOldSheetsMap
    Iterator<XSSFSheet> oldSheetsIter = workbookOld.iterator();
    //Skip 1st sheet which contains all old patients
    oldSheetsIter.next();
    depttToOldSheetsMap = new HashMap<>();
    while (oldSheetsIter.hasNext()) {
        XSSFSheet oldSheet = oldSheetsIter.next();
        depttToOldSheetsMap.put(oldSheet.getSheetName(), new OldDepttSheet(oldSheet));
    }

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• »