Bael 623 v2 (eugenp#1119)

lor6 · KevinGilmore · commit 47889bc227fd · 2017-02-06T17:03:00.000-06:00
* helper classes for excel processing, tests

* fix imports

* list declaration

* shorten examples, add excel files
diff --git a/apache-poi/pom.xml b/apache-poi/pom.xml
@@ -37,16 +37,6 @@
             <groupId>org.apache.poi</groupId>
             <artifactId>poi-ooxml</artifactId>
             <version>${poi.version}</version>
-        </dependency>
-		 <dependency>
-            <groupId>org.apache.poi</groupId>
-            <artifactId>poi</artifactId>
-            <version>${poi.version}</version>
-        </dependency>
-		 <dependency>
-            <groupId>org.apache.poi</groupId>
-            <artifactId>poi-ooxml-schemas</artifactId>
-            <version>${poi.version}</version>
         </dependency>
         <dependency>
             <groupId>org.jxls</groupId>
diff --git a/apache-poi/src/main/java/com/baeldung/jexcel/JExcelHelper.java b/apache-poi/src/main/java/com/baeldung/jexcel/JExcelHelper.java
@@ -62,12 +62,7 @@ public void writeJExcel() throws IOException, WriteException {
             sheet.addCell(cellLabel);
             Number cellNumber = new Number(1, 2, 20, cellFormat);
             sheet.addCell(cellNumber);
-
-            cellLabel = new Label(0, 3, "Ana Johnson", cellFormat);
-            sheet.addCell(cellLabel);
-            cellNumber = new Number(1, 3, 30, cellFormat);
-            sheet.addCell(cellNumber);
-
+			
             workbook.write();
         } finally {
             if (workbook != null) {
diff --git a/apache-poi/src/main/java/com/baeldung/poi/excel/ExcelPOIHelper.java b/apache-poi/src/main/java/com/baeldung/poi/excel/ExcelPOIHelper.java
@@ -110,15 +110,6 @@ public void writeExcel() throws IOException {
             cell.setCellValue(20);
             cell.setCellStyle(style);
 
-            row = sheet.createRow(3);
-            cell = row.createCell(0);
-            cell.setCellValue("Ana Johnson");
-            cell.setCellStyle(style);
-
-            cell = row.createCell(1);
-            cell.setCellValue(30);
-            cell.setCellStyle(style);
-
             File currDir = new File(".");
             String path = currDir.getAbsolutePath();
             String fileLocation = path.substring(0, path.length() - 1) + "temp.xlsx";
diff --git a/apache-poi/src/test/java/com/baeldung/jexcel/JExcelTest.java b/apache-poi/src/test/java/com/baeldung/jexcel/JExcelTest.java
@@ -51,12 +51,6 @@ public void whenParsingJExcelFile_thenCorrect() throws IOException, BiffExceptio
             .get(0));
         assertEquals("20", data.get(2)
             .get(1));
-
-        assertEquals("Ana Johnson", data.get(3)
-            .get(0));
-        assertEquals("30", data.get(3)
-            .get(1));
-
     }
 
 }
diff --git a/apache-poi/src/test/java/com/baeldung/poi/excel/ExcelTest.java b/apache-poi/src/test/java/com/baeldung/poi/excel/ExcelTest.java
@@ -48,12 +48,6 @@ public void whenParsingPOIExcelFile_thenCorrect() throws IOException {
             .get(0));
         assertEquals("20", data.get(1)
             .get(1));
-
-        assertEquals("Ana Johnson", data.get(2)
-            .get(0));
-        assertEquals("30", data.get(2)
-            .get(1));
-
     }
 
 }
diff --git a/apache-poi/temp.xls b/apache-poi/temp.xls
diff --git a/apache-poi/temp.xlsx b/apache-poi/temp.xlsx

Original file line number	Diff line number	Diff line change
`@@ -51,12 +51,6 @@ public void whenParsingJExcelFile_thenCorrect() throws IOException, BiffExceptio`
`51`	`51`	`.get(0));`
`52`	`52`	`assertEquals("20", data.get(2)`
`53`	`53`	`.get(1));`
`54`		`-`
`55`		`- assertEquals("Ana Johnson", data.get(3)`
`56`		`- .get(0));`
`57`		`- assertEquals("30", data.get(3)`
`58`		`- .get(1));`
`59`		`-`
`60`	`54`	`}`
`61`	`55`
`62`	`56`	`}`
Original file line number	Diff line number	Diff line change
`@@ -48,12 +48,6 @@ public void whenParsingPOIExcelFile_thenCorrect() throws IOException {`
`48`	`48`	`.get(0));`
`49`	`49`	`assertEquals("20", data.get(1)`
`50`	`50`	`.get(1));`
`51`		`-`
`52`		`- assertEquals("Ana Johnson", data.get(2)`
`53`		`- .get(0));`
`54`		`- assertEquals("30", data.get(2)`
`55`		`- .get(1));`
`56`		`-`
`57`	`51`	`}`
`58`	`52`
`59`	`53`	`}`