de.hk.exceldemo.business.service.ExcelAdapterTest.java Source code

Introduction

Here is the source code for de.hk.exceldemo.business.service.ExcelAdapterTest.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package de.hk.exceldemo.business.service;

import de.hk.exceldemo.BaseTest;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Iterator;
import org.apache.poi.POIXMLException;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.After;
import org.junit.AfterClass;
import org.junit.Before;
import org.junit.Test;
import static org.junit.Assert.*;
import org.junit.BeforeClass;

/**
 *
 * @author palmherby
 */
public class ExcelAdapterTest extends BaseTest {

    private ExcelAdapter cut;

    @BeforeClass
    public static void setUpClass() throws Exception {
    }

    @AfterClass
    public static void tearDownClass() throws Exception {
    }

    @Before
    public void setUp() {
        cut = new ExcelAdapter();
    }

    @After
    public void tearDown() throws Exception {
    }

    @Test
    public void loadXSSFSheetTest() throws IOException, InvalidFormatException {
        FileInputStream file = new FileInputStream(new File(FILE_BEITRAGSAENDERUNG));
        Sheet sheet = this.cut.getSheet(file, 0);
        assertNotNull(sheet);
    }

    @Test(expected = IOException.class)
    public void loadXSSFSheetFailureTest() throws IOException, InvalidFormatException {
        FileInputStream file = new FileInputStream(new File(FILE_NOT_EXISTING));
        this.cut.getSheet(file, 0);
    }

    @Test(expected = POIXMLException.class)
    public void loadXSSFSheetFailureOldFormatTest() throws IOException, InvalidFormatException {
        FileInputStream file = new FileInputStream(new File(FILE_OLD_FORMAT));
        this.cut.getSheet(file, 0);
    }

    @Test
    public void addCell() {
        XSSFWorkbook wb1 = new XSSFWorkbook();
        Sheet sheet1 = wb1.createSheet("testSheet1");
        Row newRow1 = sheet1.createRow(0);
        Cell cell1 = newRow1.createCell(0);
        cell1.setCellValue("jawoi");

        XSSFWorkbook wb2 = new XSSFWorkbook();
        Sheet sheet2 = wb2.createSheet("testSheet2");
        Row newRow2 = sheet2.createRow(0);

        cut.addCell(newRow2, 0, cell1);

        Iterator<Cell> celltIt = newRow2.cellIterator();
        assertEquals("jawoi", celltIt.next().getStringCellValue());
    }
}