Author: kiwiwings
Date: Mon Apr 20 20:57:37 2020
New Revision: 1876766
URL: http://svn.apache.org/viewvc?rev=1876766&view=rev
Log:
Sonar fix - Suppress "Make sure that command line arguments are used safely
here." for examples
Modified:
poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmbeddedObjects.java
poi/trunk/src/examples/src/org/apache/poi/hwpf/Word2Forrest.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ExcelComparator.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CheckFunctionsSupported.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java
poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/BarChartDemo.java
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/ChartFromScratch.java
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/DataExtraction.java
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/MergePresentations.java
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/PieChartDemo.java
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/tutorial/Step1.java
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/LoadPasswordProtectedXlsxStreaming.java
poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/SavePasswordProtectedXlsx.java
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LoadPasswordProtectedXlsx.java
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/BarChartExample.java
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/ChartFromScratch.java
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/SimpleImages.java
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/UpdateEmbeddedDoc.java
Modified:
poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmbeddedObjects.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmbeddedObjects.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmbeddedObjects.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmbeddedObjects.java
Mon Apr 20 20:57:37 2020
@@ -30,7 +30,7 @@ import org.apache.poi.poifs.filesystem.P
/**
* Demonstrates how you can extract embedded data from a .xls file
*/
-@SuppressWarnings({"java:S106","java:S4823"})
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class EmbeddedObjects {
private EmbeddedObjects() {}
Modified: poi/trunk/src/examples/src/org/apache/poi/hwpf/Word2Forrest.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/hwpf/Word2Forrest.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/hwpf/Word2Forrest.java (original)
+++ poi/trunk/src/examples/src/org/apache/poi/hwpf/Word2Forrest.java Mon Apr 20
20:57:37 2020
@@ -32,6 +32,7 @@ import org.apache.poi.hwpf.usermodel.Cha
import org.apache.poi.hwpf.usermodel.Paragraph;
import org.apache.poi.hwpf.usermodel.Range;
+@SuppressWarnings({"java:S106","java:S4823"})
public final class Word2Forrest
{
Writer _out;
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java
Mon Apr 20 20:57:37 2020
@@ -199,6 +199,7 @@ import org.apache.poi.util.IOUtils;
* 2mm have been noted in testing. Further investigation will
* continue to rectify this issue.
*/
+@SuppressWarnings({"java:S106","java:S4823"})
public class AddDimensionedImage {
// Four constants that determine how - and indeed whether - the rows
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java Mon
Apr 20 20:57:37 2020
@@ -45,8 +45,8 @@ import org.apache.poi.xssf.usermodel.XSS
*
* @author Yegor Kozlov
*/
-@SuppressWarnings("java:S1192")
-public class BusinessPlan {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class BusinessPlan {
private static final String[] titles = {
"ID", "Project Name", "Owner", "Days", "Start", "End"};
@@ -88,6 +88,8 @@ public class BusinessPlan {
null, null, null, null, null, "x", null, null, null, null,
null},
};
+ private BusinessPlan() {}
+
public static void main(String[] args) throws Exception {
Workbook wb;
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java Mon
Apr 20 20:57:37 2020
@@ -17,16 +17,26 @@
package org.apache.poi.ss.examples;
-import org.apache.poi.xssf.usermodel.*;
-import org.apache.poi.ss.util.CellRangeAddress;
-import org.apache.poi.ss.usermodel.*;
-import org.apache.poi.ss.usermodel.Font;
-import org.apache.poi.hssf.usermodel.HSSFWorkbook;
-
import java.io.FileOutputStream;
import java.util.Calendar;
-import java.util.Map;
import java.util.HashMap;
+import java.util.Map;
+
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
+import org.apache.poi.ss.usermodel.BorderStyle;
+import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.CellStyle;
+import org.apache.poi.ss.usermodel.FillPatternType;
+import org.apache.poi.ss.usermodel.Font;
+import org.apache.poi.ss.usermodel.HorizontalAlignment;
+import org.apache.poi.ss.usermodel.IndexedColors;
+import org.apache.poi.ss.usermodel.PrintSetup;
+import org.apache.poi.ss.usermodel.Row;
+import org.apache.poi.ss.usermodel.Sheet;
+import org.apache.poi.ss.usermodel.VerticalAlignment;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.ss.util.CellRangeAddress;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
/**
* A monthly calendar created using Apache POI. Each month is on a separate
sheet.
@@ -37,7 +47,8 @@ import java.util.HashMap;
*
* @author Yegor Kozlov
*/
-public class CalendarDemo {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class CalendarDemo {
private static final String[] days = {
"Sunday", "Monday", "Tuesday",
@@ -47,6 +58,8 @@ public class CalendarDemo {
"January", "February", "March","April", "May", "June","July",
"August",
"September","October", "November", "December"};
+ private CalendarDemo() {}
+
public static void main(String[] args) throws Exception {
Calendar calendar = Calendar.getInstance();
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java
Mon Apr 20 20:57:37 2020
@@ -37,12 +37,15 @@ import org.apache.poi.xssf.usermodel.XSS
/**
* Demonstrates how to read excel styles for cells
*/
-public class CellStyleDetails {
+@SuppressWarnings({"java:S106","java:S4823"})
+public final class CellStyleDetails {
+ private CellStyleDetails() {}
+
public static void main(String[] args) throws Exception {
if(args.length == 0) {
throw new IllegalArgumentException("Filename must be given");
}
-
+
try (Workbook wb = WorkbookFactory.create(new File(args[0]))) {
DataFormatter formatter = new DataFormatter();
@@ -82,7 +85,7 @@ public class CellStyleDetails {
}
}
}
-
+
private static String renderColor(Color color) {
if(color instanceof HSSFColor) {
return ((HSSFColor)color).getHexString();
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java
Mon Apr 20 20:57:37 2020
@@ -57,8 +57,10 @@ import org.apache.poi.xssf.usermodel.XSS
* http://www.contextures.com/xlcondformat03.html
* </p>
*/
-@SuppressWarnings("java:S1192")
-public class ConditionalFormats {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class ConditionalFormats {
+
+ private ConditionalFormats() {}
/**
* generates a sample workbook with conditional formatting,
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
Mon Apr 20 20:57:37 2020
@@ -36,13 +36,16 @@ import org.apache.poi.xssf.usermodel.XSS
/**
* Excel Border Drawing - examples
- *
+ *
* <p>
* Partly based on the code snippets from
* org.apache.poi.ss.examples.ConditionalFormats
* </p>
*/
-public class DrawingBorders {
+@SuppressWarnings({"java:S106","java:S4823"})
+public final class DrawingBorders {
+
+ private DrawingBorders() {}
public static void main(String[] args) throws IOException {
try (Workbook wb = (args.length > 0 && args[0].equals("-xls"))
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ExcelComparator.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ExcelComparator.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/ExcelComparator.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/ExcelComparator.java
Mon Apr 20 20:57:37 2020
@@ -80,7 +80,7 @@ import org.apache.poi.xssf.usermodel.XSS
* }
* </pre>
*/
-@SuppressWarnings("java:S1192")
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public class ExcelComparator {
private static final String CELL_DATA_DOES_NOT_MATCH = "Cell Data does not
Match ::";
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java Mon
Apr 20 20:57:37 2020
@@ -43,12 +43,15 @@ import org.apache.xmlbeans.XmlException;
* Loads embedded resources from Workbooks. Code taken from the website:
* https://poi.apache.org/spreadsheet/quick-guide.html#Embedded
*/
-public class LoadEmbedded {
- public static void main(String[] args) throws IOException,
EncryptedDocumentException, OpenXML4JException, XmlException {
+@SuppressWarnings({"java:S106","java:S4823"})
+public final class LoadEmbedded {
+ private LoadEmbedded() {}
+
+ public static void main(String[] args) throws IOException,
EncryptedDocumentException, OpenXML4JException, XmlException {
Workbook wb = WorkbookFactory.create(new File(args[0]));
loadEmbedded(wb);
}
-
+
public static void loadEmbedded(Workbook wb) throws IOException,
InvalidFormatException, OpenXML4JException, XmlException {
if (wb instanceof HSSFWorkbook) {
loadEmbedded((HSSFWorkbook)wb);
@@ -60,7 +63,7 @@ public class LoadEmbedded {
throw new IllegalArgumentException(wb.getClass().getName());
}
}
-
+
public static void loadEmbedded(HSSFWorkbook workbook) throws IOException {
for (HSSFObjectData obj : workbook.getAllEmbeddedObjects()) {
//the OLE2 Class Name of the object
@@ -92,7 +95,7 @@ public class LoadEmbedded {
}
}
}
-
+
public static void loadEmbedded(XSSFWorkbook workbook) throws IOException,
InvalidFormatException, OpenXML4JException, XmlException {
for (PackagePart pPart : workbook.getAllEmbeddedParts()) {
String contentType = pPart.getContentType();
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java
Mon Apr 20 20:57:37 2020
@@ -45,8 +45,10 @@ import org.apache.poi.xssf.usermodel.XSS
*
* @author Yegor Kozlov
*/
-@SuppressWarnings("java:S1192")
-public class LoanCalculator {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class LoanCalculator {
+
+ private LoanCalculator() {}
public static void main(String[] args) throws Exception {
Workbook wb;
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java
Mon Apr 20 20:57:37 2020
@@ -42,8 +42,10 @@ import org.apache.poi.ss.util.CellRefere
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
-@SuppressWarnings("java:S1192")
-public class SSPerformanceTest {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class SSPerformanceTest {
+ private SSPerformanceTest() {}
+
public static void main(String[] args) throws IOException {
if (args.length < 4) {
usage("need at least four command arguments");
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java
Mon Apr 20 20:57:37 2020
@@ -44,18 +44,20 @@ import org.apache.poi.xssf.usermodel.XSS
*
* @author Yegor Kozlov
*/
-@SuppressWarnings("java:S1192")
-public class TimesheetDemo {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class TimesheetDemo {
private static final String[] titles = {
"Person", "ID", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun",
"Total\nHrs", "Overtime\nHrs", "Regular\nHrs"
};
- private static Object[][] sample_data = {
+ private static final Object[][] sample_data = {
{"Yegor Kozlov", "YK", 5.0, 8.0, 10.0, 5.0, 5.0, 7.0, 6.0},
{"Gisella Bronzetti", "GB", 4.0, 3.0, 1.0, 3.5, null, null, 4.0},
};
+ private TimesheetDemo() {}
+
public static void main(String[] args) throws Exception {
Workbook wb;
Modified: poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java (original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java Mon Apr 20
20:57:37 2020
@@ -129,6 +129,7 @@ import org.apache.poi.ss.usermodel.Workb
* either obeying Excel's or UNIX formatting
* conventions.
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public class ToCSV {
private Workbook workbook;
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CheckFunctionsSupported.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CheckFunctionsSupported.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CheckFunctionsSupported.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CheckFunctionsSupported.java
Mon Apr 20 20:57:37 2020
@@ -45,6 +45,7 @@ import org.apache.poi.ss.util.CellRefere
* files using Apache POI, along with how to handle errors whilst
* doing so.
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public class CheckFunctionsSupported {
public static void main(String[] args) throws Exception {
if (args.length < 1) {
@@ -96,8 +97,8 @@ public class CheckFunctionsSupported {
}
}
- private Workbook workbook;
- private FormulaEvaluator evaluator;
+ private final Workbook workbook;
+ private final FormulaEvaluator evaluator;
public CheckFunctionsSupported(Workbook workbook) {
this.workbook = workbook;
this.evaluator = workbook.getCreationHelper().createFormulaEvaluator();
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java
Mon Apr 20 20:57:37 2020
@@ -16,11 +16,11 @@
==================================================================== */
package org.apache.poi.ss.examples.formula;
-import java.io.File ;
+import java.io.File;
-import org.apache.poi.ss.formula.functions.FreeRefFunction ;
-import org.apache.poi.ss.formula.udf.DefaultUDFFinder ;
-import org.apache.poi.ss.formula.udf.UDFFinder ;
+import org.apache.poi.ss.formula.functions.FreeRefFunction;
+import org.apache.poi.ss.formula.udf.DefaultUDFFinder;
+import org.apache.poi.ss.formula.udf.UDFFinder;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellValue;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
@@ -28,26 +28,29 @@ import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
-import org.apache.poi.ss.util.CellReference ;
+import org.apache.poi.ss.util.CellReference;
/**
* An example class of how to invoke a User Defined Function for a given
* XLS instance using POI's UDFFinder implementation.
*/
-public class UserDefinedFunctionExample {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class UserDefinedFunctionExample {
+
+ private UserDefinedFunctionExample() {}
+
+ public static void main(String[] args ) throws Exception {
- public static void main( String[] args ) throws Exception {
-
if( args.length != 2 ) {
// e.g.
src/examples/src/org/apache/poi/ss/examples/formula/mortgage-calculation.xls
Sheet1!B4
System.out.println( "usage: UserDefinedFunctionExample fileName
cellId" ) ;
return;
}
-
+
System.out.println( "fileName: " + args[0] ) ;
System.out.println( "cell: " + args[1] ) ;
-
+
File workbookFile = new File( args[0] ) ;
try (Workbook workbook = WorkbookFactory.create(workbookFile, null,
true)) {
Modified: poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java Mon
Apr 20 20:57:37 2020
@@ -53,8 +53,8 @@ import org.apache.poi.xssf.usermodel.XSS
* This example shows how to display a spreadsheet in HTML using the classes
for
* spreadsheet display.
*/
-@SuppressWarnings("java:S1192")
-public class ToHtml {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class ToHtml {
private final Workbook wb;
private final Appendable output;
private boolean completeHTML;
Modified:
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/BarChartDemo.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/BarChartDemo.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/BarChartDemo.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/BarChartDemo.java
Mon Apr 20 20:57:37 2020
@@ -41,6 +41,7 @@ import org.apache.poi.xddf.usermodel.cha
/**
* Build a bar chart from a template pptx
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class BarChartDemo {
private BarChartDemo() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/ChartFromScratch.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/ChartFromScratch.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/ChartFromScratch.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/ChartFromScratch.java
Mon Apr 20 20:57:37 2020
@@ -49,6 +49,7 @@ import org.apache.poi.xddf.usermodel.cha
/**
* Build a chart without reading template file
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class ChartFromScratch {
private ChartFromScratch() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/DataExtraction.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/DataExtraction.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/DataExtraction.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/DataExtraction.java
Mon Apr 20 20:57:37 2020
@@ -14,7 +14,7 @@
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
- * ====================================================================
+ * ====================================================================
*/
package org.apache.poi.xslf.usermodel;
@@ -25,16 +25,16 @@ import java.io.IOException;
import java.io.InputStream;
import java.io.PrintStream;
-import org.apache.poi.openxml4j.exceptions.OpenXML4JException;
import org.apache.poi.openxml4j.opc.PackagePart;
/**
* Demonstrates how you can extract data from a .pptx file
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class DataExtraction {
private DataExtraction() {}
- public static void main(String[] args) throws IOException,
OpenXML4JException {
+ public static void main(String[] args) throws IOException {
PrintStream out = System.out;
@@ -42,7 +42,7 @@ public final class DataExtraction {
out.println("Input file is required");
return;
}
-
+
FileInputStream is = new FileInputStream(args[0]);
try (XMLSlideShow ppt = new XMLSlideShow(is)) {
is.close();
Modified:
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/MergePresentations.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/MergePresentations.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/MergePresentations.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/MergePresentations.java
Mon Apr 20 20:57:37 2020
@@ -14,7 +14,7 @@
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
- * ====================================================================
+ * ====================================================================
*/
package org.apache.poi.xslf.usermodel;
@@ -25,6 +25,7 @@ import java.io.FileOutputStream;
/**
* Merge multiple pptx presentations together
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class MergePresentations {
private MergePresentations() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/PieChartDemo.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/PieChartDemo.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/PieChartDemo.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/PieChartDemo.java
Mon Apr 20 20:57:37 2020
@@ -38,6 +38,7 @@ import org.apache.poi.xddf.usermodel.cha
/**
* Build a pie chart from a template pptx
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class PieChartDemo {
private PieChartDemo() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/tutorial/Step1.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/tutorial/Step1.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/tutorial/Step1.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/tutorial/Step1.java
Mon Apr 20 20:57:37 2020
@@ -31,6 +31,7 @@ import org.apache.poi.xslf.usermodel.XSL
/**
* Reading a .pptx presentation and printing basic shape properties
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class Step1 {
private Step1() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
(original)
+++ poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
Mon Apr 20 20:57:37 2020
@@ -61,10 +61,11 @@ import org.xml.sax.XMLReader;
* For a more advanced implementation of SAX event parsing
* of XLSX files, see {@link XSSFEventBasedExcelExtractor}
* and {@link XSSFSheetXMLHandler}. Note that for many cases,
- * it may be possible to simply use those with a custom
+ * it may be possible to simply use those with a custom
* {@link SheetContentsHandler} and no SAX code needed of
* your own!
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public class XLSX2CSV {
/**
* Uses the XSSF Event SAX helpers to do most of the work
@@ -75,7 +76,7 @@ public class XLSX2CSV {
private boolean firstCellOfRow;
private int currentRow = -1;
private int currentCol = -1;
-
+
private void outputMissingRows(int number) {
for (int i=0; i<number; i++) {
for (int j=0; j<minColumns; j++) {
@@ -125,7 +126,7 @@ public class XLSX2CSV {
output.append(',');
}
currentCol = thisCol;
-
+
// Number or string?
try {
//noinspection ResultOfMethodCallIgnored
@@ -183,7 +184,7 @@ public class XLSX2CSV {
public void processSheet(
Styles styles,
SharedStrings strings,
- SheetContentsHandler sheetHandler,
+ SheetContentsHandler sheetHandler,
InputStream sheetInputStream) throws IOException, SAXException {
DataFormatter formatter = new DataFormatter();
InputSource sheetSource = new InputSource(sheetInputStream);
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java
Mon Apr 20 20:57:37 2020
@@ -42,6 +42,7 @@ import org.xml.sax.helpers.DefaultHandle
* See {@link XLSX2CSV} for a fuller example of doing
* XSLX processing with the XSSF Event code.
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public class FromHowTo {
public void processFirstSheet(String filename) throws Exception {
try (OPCPackage pkg = OPCPackage.open(filename, PackageAccess.READ)) {
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/LoadPasswordProtectedXlsxStreaming.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/LoadPasswordProtectedXlsxStreaming.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/LoadPasswordProtectedXlsxStreaming.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/LoadPasswordProtectedXlsxStreaming.java
Mon Apr 20 20:57:37 2020
@@ -35,10 +35,10 @@ import org.apache.poi.xssf.usermodel.exa
* <li><code>AesZipFileZipEntrySource</code> is used to ensure that temp files
are encrypted.
* </ul><p>
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class LoadPasswordProtectedXlsxStreaming {
- private LoadPasswordProtectedXlsxStreaming() {
- }
+ private LoadPasswordProtectedXlsxStreaming() {}
public static void main(String[] args) throws Exception {
LoadPasswordProtectedXlsx.execute(args,
LoadPasswordProtectedXlsxStreaming::printSheetCount);
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/SavePasswordProtectedXlsx.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/SavePasswordProtectedXlsx.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/SavePasswordProtectedXlsx.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/SavePasswordProtectedXlsx.java
Mon Apr 20 20:57:37 2020
@@ -46,7 +46,10 @@ import org.apache.poi.xssf.streaming.SXS
* <li><code>SXSSFWorkbookWithCustomZipEntrySource</code> extends
SXSSFWorkbook to ensure temp files are encrypted.
* </ul><p>
*/
-public class SavePasswordProtectedXlsx {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class SavePasswordProtectedXlsx {
+
+ private SavePasswordProtectedXlsx() {}
public static void main(String[] args) throws Exception {
if(args.length != 2) {
@@ -81,7 +84,7 @@ public class SavePasswordProtectedXlsx {
}
TempFileUtils.checkTempFiles();
}
-
+
public static void save(final InputStream inputStream, final String
filename, final String pwd)
throws InvalidFormatException, IOException,
GeneralSecurityException {
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java
Mon Apr 20 20:57:37 2020
@@ -16,17 +16,20 @@
==================================================================== */
package org.apache.poi.xssf.usermodel.examples;
+import java.io.ByteArrayOutputStream;
+
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.xssf.extractor.XSSFExportToXml;
-import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFMap;
-
-import java.io.ByteArrayOutputStream;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
/**
* Print all custom XML mappings registered in the given workbook
*/
-public class CustomXMLMapping {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class CustomXMLMapping {
+
+ private CustomXMLMapping() {}
public static void main(String[] args) throws Exception {
try (OPCPackage pkg = OPCPackage.open(args[0]);
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java
Mon Apr 20 20:57:37 2020
@@ -29,7 +29,10 @@ import org.apache.poi.xssf.usermodel.XSS
/**
* Iterate over rows and cells
*/
-public class IterateCells {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class IterateCells {
+
+ private IterateCells() {}
public static void main(String[] args) throws IOException {
try (
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LoadPasswordProtectedXlsx.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LoadPasswordProtectedXlsx.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LoadPasswordProtectedXlsx.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LoadPasswordProtectedXlsx.java
Mon Apr 20 20:57:37 2020
@@ -37,8 +37,11 @@ import org.apache.poi.xssf.usermodel.XSS
* <li><code>AesZipFileZipEntrySource</code> is used to ensure that temp files
are encrypted.
* </ul><p>
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class LoadPasswordProtectedXlsx {
+ private LoadPasswordProtectedXlsx() {}
+
public interface EncryptionHandler {
void handle(final InputStream inputStream) throws Exception;
}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java
Mon Apr 20 20:57:37 2020
@@ -35,7 +35,10 @@ import org.apache.poi.xssf.usermodel.XSS
/**
* Demonstrates how to insert pictures in a SpreadsheetML document
*/
-public class WorkingWithPictures {
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
+public final class WorkingWithPictures {
+ private WorkingWithPictures() {}
+
public static void main(String[] args) throws IOException {
//create a new workbook
Modified:
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/BarChartExample.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/BarChartExample.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/BarChartExample.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/BarChartExample.java
Mon Apr 20 20:57:37 2020
@@ -43,6 +43,7 @@ import org.apache.poi.xwpf.usermodel.XWP
/**
* Build a bar chart from a template docx
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class BarChartExample {
private BarChartExample() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/ChartFromScratch.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/ChartFromScratch.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/ChartFromScratch.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/ChartFromScratch.java
Mon Apr 20 20:57:37 2020
@@ -49,6 +49,7 @@ import org.apache.poi.xwpf.usermodel.XWP
/**
* Build a chart without reading template file
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class ChartFromScratch {
private ChartFromScratch() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/SimpleImages.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/SimpleImages.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/SimpleImages.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/SimpleImages.java
Mon Apr 20 20:57:37 2020
@@ -33,6 +33,7 @@ import org.apache.poi.xwpf.usermodel.XWP
/**
* Demonstrates how to add pictures in a .docx document
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public final class SimpleImages {
private SimpleImages() {}
Modified:
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/UpdateEmbeddedDoc.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/UpdateEmbeddedDoc.java?rev=1876766&r1=1876765&r2=1876766&view=diff
==============================================================================
---
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/UpdateEmbeddedDoc.java
(original)
+++
poi/trunk/src/examples/src/org/apache/poi/xwpf/usermodel/examples/UpdateEmbeddedDoc.java
Mon Apr 20 20:57:37 2020
@@ -42,10 +42,11 @@ import org.apache.poi.xwpf.usermodel.XWP
* embedded into a WordprocessingML document. Note that the test has currently
* only been conducted with a binary Excel workbook and NOT yet with a
* SpreadsheetML workbook embedded into the document.<p>
- *
+ *
* This code was successfully tested with the following file from the POI test
collection:
*
http://svn.apache.org/repos/asf/poi/trunk/test-data/document/EmbeddedDocument.docx
*/
+@SuppressWarnings({"java:S106","java:S4823","java:S1192"})
public class UpdateEmbeddedDoc {
private XWPFDocument doc;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
