Apache POI Method Returning Wrong Value

May 20, 2014

I'm using apache POI to input data from a excel database. I have a method that is supposed to count the number of rows containing data so I can use that number to initialize an object array. It's returning one more than the actual number of rows and I can't figure out why.

public int getDataRange() throws IOException{
int rowCount = 0;
Iterator<Row> rows = sheet.rowIterator();
while(rows.hasNext()){
HSSFRow row = (HSSFRow) rows.next();
rowCount++;

[Code] .....

I get an array index out of bounds exception at the highlighted line.

View Replies


ADVERTISEMENT

Which Method Is Used While Passing Or Returning A Object From The Native Method

Mar 5, 2014

Which method is used while passing or returning a java object from the native method?

View Replies View Related

Polymorphism / Dynamic Binding - Invoking Wrong Method

Jan 9, 2014

Why is the equals-method in the super-class invoked? Shouldn't the equals-method in the sub-class be invoked(at least in the first if-statement since b2 is a B(i know B is also an A))?Is the equals-method overridden? Or does B have its own equals-method?

class SomeClass{
public static void main(String[] args) {

B b1 = new B(123,1);
B b2 = new B(123,2);

[code]...

View Replies View Related

Java Class Date Method Showing Wrong Year

Dec 31, 2013

We use a Java program to read an XML file and put its content into a database. We also use Date() to get the current date and insert it into a field in database with content from XML file. Everything worked flawlessly until today, the last day of 2013. We are getting 2014 for the year instead of 2013!!! System date shows correct year, so this must not be an issue.

View Replies View Related

JSF :: ValueChangeEvent NewValue Method Giving Wrong Value When Component Values Change Indirectly

Aug 1, 2014

My form looks like this:

<h:form>
<h:panelGrid columns="2" style="margin-bottom:10px" cellpadding="5">
<p:outputLabel for="filetype" value="FileType: " />
<p:selectOneRadio valueChangeListener="#{selectView.changeServerAndSignmethod}" onchange="submit()" id="filetype" value="#{selectView.filetype}">
<f:selectItems value="#{selectView.filetypes}" itemLabel="#{filetype}" itemValue="#{filetype}" />
</p:selectOneRadio>
<p:outputLabel for="signmethod" value="Sign Method: " />
<p:selectOneMenu valueChangeListener="#{selectView.changeServers}" onchange="submit()" id="signmethod" value="#{selectView.signmethod}">
<f:selectItems value="#{selectView.signmethods}" itemLabel="#{signmethod}" itemValue="#{signmethod}" />

[code]....

As you can see there are two listener in my xhtml file one for filetype and other for signmethod. When filtype changes signmethod has to change which in turn changes servers. And if user changes signmethod using dropdown then also server should change. But my problem is when filetype changes, both the listeners are called, as signmethod also changea but the value in event object (e.getNewValue()) is not the new one but old one. Here is the SelectView Bean.This is the static initialisation part just for checking the output at the end of question.

static {
initFiletypes.add("Windows");
initFiletypes.add("Mobile");
initFiletypes.add("Mac");
initFiletypes.add("Solaris");
initFiletypes.add("Jar");

windowsSignmethods.add("Microsoft");
windowsSignmethods.add("Driver");
windowsSignmethods.add("Driver_Pagehash");
windowsSignmethods.add("HDR");
windowsSignmethods.add("Java2");
windowsSignmethods.add("Javame");
windowsSignmethods.add("MicrosftApps");

[code]....

I am changing servers in changeServerAndSignmethod by selecting first signmethod from signmethod arraylist which is giving correct result. But changeServers is also getting fired taking wrong event object's newValue method and changing servers to wrong values. When changeServers is fired bydirectly changing signmethod, by dropdown, it gives correct result. Is there a way I can stop changeServers to fire when the change came from changing filetypes rather than direct change by user on signmethod selectOneMenu.

View Replies View Related

Why Method Is Not Returning A Value

Apr 29, 2014

I'm new to Java and I have a problem with a method, I can't see the code of the method, I just have a jar, but it should return a boolean, something like this:

boolean band = false;
band = TestClass.testMethod("blabla");
// band = false

The problem is that the method seems that is returning nothing (band remain false), and if I initialize band to true:

boolean band = false;
band = TestClass.testMethod("blabla");
// band = true

band remain true, in other words, the value of band is never modified, the question is, how is this possible? because it should return the same value on both calls, true or false, no matter the initial value of the variable that is receiving the returning value of the method.

View Replies View Related

Why Is Method Returning Null

Sep 25, 2014

I am working on a project which manages an airport's airplanes and flights based on user input. The method printFlights() - lines 133-134 - is returning null and I can't figure out why. The method is supposed to print information about each flight. The logic is identical to the printPlanes() method which is working successfully.

View Replies View Related

Returning Multiple Variables From A Method

Nov 18, 2014

Now that I have figured out how to return a single variable from a method I am on to the next step, I need to return 2 or 3 variables from a method. I have searched the internet on how to do this to no avail (am I doing the wrong search? I do not know) but what I need to do is return a second (and eventually a third variable)

Here is what I have

private static String Engine() {
String engine = "";
int enginePrice = 0;
System.out.println("Choose a engine size:");
System.out.println("[4] cylinder");

[Code] .....

Which does not work.

View Replies View Related

Method Is Not Returning Array - Null Error

May 18, 2015

I am trying to return an array and I keep getting a null error. The below class sets the material numbers into an array and should return that array if called :

public class Jobs {
private int[] materialsNumber;
//change to parts and create another class that gets the materials for the parts
 public int[] job1() {
materialsNumber[0] = 11960120;

[Code] ....

I later try to call the method. The program executes but stops after I println "test in loop"

public class PurchaseOrdersToParts {
 private Jobs job = new Jobs();
 int[] getPartsForPurchaseOrder(BigDecimal purchaseOrder) {
 System.out.println("inside getparts");
 BigDecimal testNum = new BigDecimal(123.0);
 
[Code] ....

This is the method that is calling the method in the GenerateOrdersToParts class

private PurchaseOrdersToParts purchaseOrdersToParts = new PurchaseOrdersToParts();
 @Inject
PoRepository poRepository;
public GenerateShopJobTickets() {
 
[Code] .....

View Replies View Related

Returning Object That Has Been Removed Using Remove Method

Nov 18, 2014

So i have used the "remove()" method in conjunction with an iterator to remove an object from a HashSet in my program, and part of my exercise requires me to return said object. What I can do to return an object that has been removed using "remove()" method?

View Replies View Related

Passing Unknown Type To A Method And Returning It

Feb 20, 2014

So I want to know how in Java you can pass a unkown type into a method (type can be an int, double, or a user defined object) and return that unkown type.

example of what I want:
Java Code:
public (unknowntype)[] method2 ((unknowntype)[])
//Process Data
//unknowntype.process();
return (unknowntype);
} mh_sh_highlight_all('java');

I know in C you can use void pointers and in c++ we have templates but I do not know how java handles this. Also I want to know if it is possible to call a method in the unknowntype.

View Replies View Related

How To Install Apache POI

Jan 19, 2015

I'm trying to learn how to read from, and write to, Excel files. I'm looking at this link : [URL] ....

It seems like there are some Apache dependencies. So, I go here : [URL] .....

I downloaded the zipped file from the first link. Now what? I don't see any .exe file, or any way of installing it. How do I install it, or run it, or whatever? What is the next step here?

View Replies View Related

Cannot Find File Apache POI

Sep 2, 2014

I'm trying to read a .xlsx file using Apache Poi on Eclipse and store the data into an ArrayList.

My code :

import org.apache.poi.ss.usermodel.*;
import java.io.*;
import java.util.*; 
public class parseReadFiles
{
public static void main(String[] args) {

[Code] ....

I keep getting a FileNotFoundException: Users/Divjot/Desktop/first.xlsx (No such file or directory). I've tried different combinations of file names and paths but can't get the program to find it. Should the file be stored in a special place or should the class path be different?

View Replies View Related

Importing Apache Commons?

Feb 18, 2014

I've got this annoying error message when trying to import:

import org.apache.commons.codec.binary.Hex.encodeHex;

"Import org.apache.commons.codec cannot be resolved", which after searching seems to be a somewhat common problem. The solution being to go to: FileUpload - Home and download some jar file and add it to the /web-inf/lib folder. yet the error persists even after adding the jar file in "add external jar files" and restarting eclipse.

The jar file I added is called "commons-fileupload-1.3.1.jar" which is the only one I could find in the zip file. I've searched around looking at numerous threads about the issue, several of them sadly several years old, with no success.Surely installing a library to eclipse shouldn't be this complicated?

View Replies View Related

JSP :: Apache Tomcat 6 - Data Not Retrieved

Feb 19, 2014

I am developing an dashboard application in Java, JSTL, MySql, Apache Tomcat 6.I have the below files

1. Dashboard.java (model)
2. DashboardDAO.java (dao)
3. DashboardController.java (Controller)
//Source
protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String forward = "";
forward = LIST_DASHBOARD;
HttpSession session = req.getSession(true);
session.setAttribute("dboard", dao.getAlldashboard(req));
setMasterInfo(req);
RequestDispatcher view = req.getRequestDispatcher(forward);
view.forward(req, res);

[code]....

It works in the first time. But, after sometime the data is not retrieved and display empty screen. Once, i stop and start the server again, the data is getting retrieved again. But, later when we refresh the empty page is getting displayed again.

View Replies View Related

Importing External Libraries Such As Apache Commons?

Dec 10, 2014

I'm currently using TextPad or command prompt to compile and run my programs, and as usual I am not having any luck importing external libraries, in particular apache commons.

I couldn't see any particularly obvious settings in TextPad to set a library or class path (which is annoying as I really like the program), so I jumped back to cmd prompt to run it from there. Aaaaaand i don't understand .

This is my file structure at present:

/mainProject //includes .java and .class files, and where I've successfully placed .jar files before.

The apache commons zip file was extracted here, making:

/mainProject/commons-lang3/apidocs/orgs/apache/commons/<folders> //the commons-lang3 folder contains the jars I'm navigating to the /mainProject folder in cmd prompt and typing (amongst many other things) javac -cp /mainProject/commons-lang3 MonsterGame.java //with the -cp being pointed at the folder the .jar is in i've tried pointing it at the root folder where the import statement begins in the code (ie mainProject/commons-lang3/apidocs), tried moving the .jar files to the mainProject folder (pointing -cp at it) and more. No luck.

it seems everytime i try to import a new library something goes wrong..... its become a bit of a stumbling block to be honest. I seem to spend most of my time dealing with the 'administrative' side of coding (that was the politest way i could put it ), am I not doing it right?

I've read I'm supposed to include the .jar in the classpath, not just the directory. is this correct? (it still doesn't work...!)

View Replies View Related

Excel To Html Conversion Using Apache Poi Library

Mar 17, 2012

i am getting the following errors.

Exception in thread "main" java.lang.NullPointerException

at java.io.Reader.<init>(Unknown Source)
at java.io.InputStreamReader.<init>(Unknown Source)
at ToHtml.printStyles(ToHtml.java:215)
at ToHtml.printInlineStyle(ToHtml.java:199)

[code]...

View Replies View Related

Java Program Using Apache POI Giving Exceptions

May 13, 2015

I am having some serious difficulty getting my project off the ground. I have the following code:

FileInputStream file = new FileInputStream(new File("src/retestchecker/test_sheet.xlsx"));
//Get the workbook instance for XLS file
XSSFWorkbook workbook = new XSSFWorkbook(file);
//Get first sheet from the workbook
XSSFSheet sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(0);
Cell x = row.getCell(3);
System.out.println(x);

Everything is properly imported, etc etc.. But I am getting this error and I am not sure what it means:

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException
at retestchecker.RetestChecker.main(RetestChecker.java:23)
Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException
at java.net.URLClassLoader$1.run(URLClassLoader.java:372)

[Code] .....

Java Result: 1

I am using Netbeans and the latest version of Apache POI that was released May 11, 2015.

The line 23 that the error refers to is this line:

XSSFWorkbook workbook = new XSSFWorkbook(file);

View Replies View Related

Apache Poi To Create Excel File From JTable

Sep 17, 2014

I'm using Apache Poi to create an Excel file from a JTable.

I want to open the file directly in Excel, rather than first write it to disk and then open it from the disk.

FileOutputStream output = new FileOutputStream( StolleExcel.xls" );
workBook.write( output );
Desktop dt = Desktop.getDesktop();
dt.open( new File( "StolleExcel.xls" ) );

output.close();

Is there a temporary way of saving the Excel object then just opening it with Excel, so the user can save or edit whatever they want?

View Replies View Related

Java EE SDK :: Weblogic Not Displaying Apache Logs

Apr 16, 2013

I keep getting an error in my browser:

    java.lang.IllegalArgumentException: argument type mismatch
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:324)

[Code] .....

I see the file "myApache.log" got created but there's no info in it when i re-test the error, I have other existing appenders and categories in this same file which do give output so I know it has nothing to do with the file or the path itself.

View Replies View Related

BinarySearch Gone Wrong

Jan 25, 2015

Searching methods and sorting methods, I tried some (SelectionSort, InsertionSort, BubbleSort, SequentialSearch) and they all work, but I am having problems right now with my BinarySearch method. The problem(s) I have right now is that the method is only finding some numbers in my array, such as 1 and 8, but when I search for the other ones it only buffers and the program has to be stopped manually, since it doesn't print anything. I tried rearranging the while-loop's circumstances but that didn't work.

how to optimize my coding for future tasks so I dont get the same problem(s).

public class BinarySearch {
public static void main(String[] args) {
int[]A = {1, 2, 3, 4, 5, 6, 7, 8, 9};
int searchedNumber = 3;

[code]....

View Replies View Related

JRE Uses Wrong Timezone

Jun 26, 2015

I have a problem with timezone in my java application. My current/correct timezone is "Europe/Berlin" or CEST. When I type the following command as my user I get the correct output back:
 
$ date "+%Z %z"
CEST +0200
 
But when I run my java application it is using the timezone GMT+0100. I have executed the following Java code to verify:
 
import java.util.Date;
import java.util.TimeZone;
public class TimeTest {
    public static void main(String args[]) {
        long time = System.currentTimeMillis();

[Code] ....
 
When I run it the following output is generated:

Current time in milliseconds = 1435319087443 => Fri Jun 26 12:44:47 GMT+01:00 2015
Current time zone: GMT+01:00
Fri Jun 26 12:44:47 GMT+01:00 2015
 
So where does java get its timezone from? It's different from the default system timezone.
 
I am running on Redhat 6.6 with Java 1.7.0_79
 
java version "1.7.0_79"
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

View Replies View Related

Keep Getting Wrong Variable Values?

Oct 24, 2014

Whenever I run this I get:

There are not enough funds to do that

Balance: $0.0
Monthly Interest Rate: 0.375%
Account Start Date: Fri Oct 24 08:03:40 EDT 2014

I assumed that this is because the constructor Account(); is setting the variables to 0 every time the program runs even though I'm passing other variables through to methods and constructors. I've looked up similar programs and this is how it's done though. The steps to my homework say to create a no-arg constructor Account() that creates a default(0) account Id and balance. What did I do wrong?

import java.util.Date;
public class Account {
 private int Id;
private double balance;
private double annualInterestRate;
private Date dateCreated = new Date();
 public static void main (String [] args){
//Objects of Account to get non-static methods

[code]....

View Replies View Related

Wrong Version Appearing For Java Command

Sep 8, 2011

I am a novice to coding and very new to Java. It appears that I am having a similar problem as the user above "Scott Allen". With a few exceptions. My issue is that when I run the command "javac" from the command prompt I am receiving the same error:- "javac is not recognized as an internal or external command, operable program or batch file"

After reading the comments from above I have configured my System Variables "Path" and "JAVA_HOME" to match the following:
JAVA_HOME: C:Program FilesJavajdk1.6.0_21in
Path: %JAVA_HOME%in; [First Variable]

There is no "Path" User variable on my computer, although there is a "TEMP" and "TMP" in the User Environment variables.

Currently I have the following Java related software installed:
- C:Program FilesJavajre6
- C:Program FilesJavajdk1.6.0_21
- C:Program FilesSunJavaDB
- C:Program FilesEclipse-jee-galileo-3.5.2

I have confirmed the "javac.exe" is located within the in directory of Javajdk.1.6.0_21..When I send "Java -version" to the command prompt the following is returned: java version "1.6.0_26"..Immediately I noticed that the version is wrong, but don't know why or what to do. Below is the output from the command "Java" using the command prompt.

Usage: java [-options] class [args...]
(to execute a class)
or java [-options] -jar jarfile [args...]
(to execute a jar file)

where options include:

-client to select the "client" VM
-server to select the "server" VM
-hotspot is a synonym for the "client" VM [deprecated]
The default VM is client.

[code]....

View Replies View Related

Getting Wrong Values When Calculating Perimeter And Area?

Mar 22, 2015

I've been given a school assignment that reads, "Rewrite the main class Geometry so it takes in the dimensions for the triangle and ellipse as user inputs and create a Triangle and an Ellipse class. Use the appropriate variable types, constants, variable names and computational formulas.

Triangle class will have a computePerimeter and a computeArea methods Ellipse class will have a computeArea method Create Report class

• Create a method createReport that takes the values returned from Triangle and Ellipse and combines them in the following message and displays it. Format the values so that they have 2 decimals.

“The triangle has a perimeter of [perimeter] with an area of [area] while the ellipse has an area of [area]”

• Create a method switchReport that takes the original string from createReport and changes the message to display using the available methods in the String class

“The ellipse has an area of [area] while the triangle has an area of [area] with a perimeter of [perimeter]”"

I've run into a problem when creating the createReport method. Everytime i run it i get incorrect values for the perimeter and area (namely i get zero every time).

my code is as follows:

public class Triangle
{
public double base;
public double height;
public double hypotenuse;
private double tArea;
private double perimeter;
  public Triangle()
{
base = 0;
height = 0;
hypotenuse = 0;

[code]....

For the triangle class and

public class Report {
  Triangle tri2 = new Triangle();
Ellipse eli2 = new Ellipse();
  public Report() { 

public void createReport() {
System.out.println("The triangle has a perimeter of "+tri2.computePerimeter() +" with an area of " +tri2.computeTArea() +" while the ellipse has an area of " +eli2.computeEArea() );
}

for the report class.the Geometry class allows you to input values and if i skip the report and simply print the perimeter and area they are correct. However with the report class it simply gives me zeros.

View Replies View Related

Adding Message That A Wrong Character Has Been Entered?

Nov 6, 2014

So the idea of this program is that you enter a number, it will give out a radius ... After the radius is given then, it will ask if you want to continue yes or no, if yes then it will repeat the process. If you select no then you will be greeted with a message saying "programme complete, See you later" ...

This all works fine and the code is below... however I want to add a pop up message if someone enters an invalid Character (anything that is not a number) ...

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved