Apache POI, ExcelSheet & Jar...

J

julielaurek

Hey guys!

So I have his modified code to create an excel sheet and when I run
it, it does create one, although I have to manually go open the
sheet;


//import java.awt.List;
import java.io.FileOutputStream;
import java.io.IOException;
import java.lang.Double;
import java.lang.String;
import java.util.*;


import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class SimpleSpreadsheetTest{
//SerialDemo serialDemo ;
//public static String[] serialOutput;
public static String[] serialOutput = {"1","M","43423",
"2","B","50608", "3","M","53478", "4","B","55853"};
public static Double myDoubleObject = null;
public static String myStringObject;

public static Double getTheString(Double someDouble, String
someString){
return someDouble.valueOf(someString);
}

public static double getTheDouble(int i){
if (serialOutput.length != 0){
ArrayList tempList = new ArrayList(Arrays.asList(serialOutput));
String myStringObject = (String) tempList.get(i);
myDoubleObject = getTheString(myDoubleObject, myStringObject);
//return myDoubleObject.doubleValue();
}
return myDoubleObject.doubleValue();
}
public static void main(String[] args) throws IOException{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheetAttemptOne...Work!");
HSSFRow row ;


if (serialOutput.length % 3 != 0){
System.out.println("Insufficient Data!");
}
else
{
row = sheet.createRow(0);
HSSFCell hssfCell = row.createCell((short)0);
hssfCell.setCellValue("Event Number");
hssfCell = row.createCell((short)1);
hssfCell.setCellValue("Event Type");
hssfCell = row.createCell((short)2);
hssfCell.setCellValue("Time");

for (int i=0; i<(serialOutput.length) ; i = i + 3){
row = sheet.createRow(1 + (i/3));

hssfCell = row.createCell((short)0);
hssfCell.setCellValue(getTheDouble(i));
hssfCell = row.createCell((short)1);
hssfCell.setCellValue(serialOutput[i+1]);
hssfCell = row.createCell((short)2);
hssfCell.setCellValue(getTheDouble(i+2));
}
FileOutputStream fileOut = new
FileOutputStream("workbookAttempt8.xls");
wb.write(fileOut);
fileOut.close();
}
}
}

/* HSSFCell hssfCell = row.createCell((short)0);
hssfCell.setCellValue("Product");
hssfCell = row.createCell((short)1);
hssfCell.setCellValue("Sales");
hssfCell = row.createCell((short)2);
hssfCell.setCellValue("Price");
hssfCell = row.createCell((short)3);
hssfCell.setCellValue("Total");

row = sheet.createRow(1);

hssfCell = row.createCell((short)0);
hssfCell.setCellValue("Pens");
hssfCell = row.createCell((short)1);
hssfCell.setCellValue(120.00);
hssfCell = row.createCell((short)2);
hssfCell.setCellValue(0.25);
hssfCell = row.createCell((short)3);
hssfCell.setCellFormula("B2*C2");




FileOutputStream fileOut = new
FileOutputStream("workbookAttempt1.xls");
wb.write(fileOut);
fileOut.close();
}

}*/


So I wanted to make this executable and I have successfully exported
it as a jar file. I am still learning so bear with my question if it's
stupid O:) but why doesn't the excel sheet get created anymore when I
launch the jar file?

Thanks

JL
 
M

Manish Pandit

Hey guys!

So I have his modified code to create an excel sheet and when I run
it, it does create one, although I have to manually go open the
sheet;

//import java.awt.List;
import java.io.FileOutputStream;
import java.io.IOException;
import java.lang.Double;
import java.lang.String;
import java.util.*;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class SimpleSpreadsheetTest{
//SerialDemo serialDemo ;
//public static String[] serialOutput;
public static String[] serialOutput = {"1","M","43423",
"2","B","50608", "3","M","53478", "4","B","55853"};
public static Double myDoubleObject = null;
public static String myStringObject;

public static Double getTheString(Double someDouble, String
someString){
return someDouble.valueOf(someString);
}

public static double getTheDouble(int i){
if (serialOutput.length != 0){
ArrayList tempList = new ArrayList(Arrays.asList(serialOutput));
String myStringObject = (String) tempList.get(i);
myDoubleObject = getTheString(myDoubleObject, myStringObject);
//return myDoubleObject.doubleValue();
}
return myDoubleObject.doubleValue();
}
public static void main(String[] args) throws IOException{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheetAttemptOne...Work!");
HSSFRow row ;

if (serialOutput.length % 3 != 0){
System.out.println("Insufficient Data!");
}
else
{
row = sheet.createRow(0);
HSSFCell hssfCell = row.createCell((short)0);
hssfCell.setCellValue("Event Number");
hssfCell = row.createCell((short)1);
hssfCell.setCellValue("Event Type");
hssfCell = row.createCell((short)2);
hssfCell.setCellValue("Time");

for (int i=0; i<(serialOutput.length) ; i = i + 3){
row = sheet.createRow(1 + (i/3));

hssfCell = row.createCell((short)0);
hssfCell.setCellValue(getTheDouble(i));
hssfCell = row.createCell((short)1);
hssfCell.setCellValue(serialOutput[i+1]);
hssfCell = row.createCell((short)2);
hssfCell.setCellValue(getTheDouble(i+2));
}
FileOutputStream fileOut = new
FileOutputStream("workbookAttempt8.xls");
wb.write(fileOut);
fileOut.close();
}
}

}

/* HSSFCell hssfCell = row.createCell((short)0);
hssfCell.setCellValue("Product");
hssfCell = row.createCell((short)1);
hssfCell.setCellValue("Sales");
hssfCell = row.createCell((short)2);
hssfCell.setCellValue("Price");
hssfCell = row.createCell((short)3);
hssfCell.setCellValue("Total");

row = sheet.createRow(1);

hssfCell = row.createCell((short)0);
hssfCell.setCellValue("Pens");
hssfCell = row.createCell((short)1);
hssfCell.setCellValue(120.00);
hssfCell = row.createCell((short)2);
hssfCell.setCellValue(0.25);
hssfCell = row.createCell((short)3);
hssfCell.setCellFormula("B2*C2");

FileOutputStream fileOut = new
FileOutputStream("workbookAttempt1.xls");
wb.write(fileOut);
fileOut.close();
}

}*/

So I wanted to make this executable and I have successfully exported
it as a jar file. I am still learning so bear with my question if it's
stupid O:) but why doesn't the excel sheet get created anymore when I
launch the jar file?

Thanks

JL
Click to expand...

How are you launching the jar file? You should be using java -jar <jar
file name>

Also, when you create the jar file, the manifest needs to call out the
main class (whose main() will be executed).

Here is a link for more details : http://csdl.ics.hawaii.edu/~johnson/613f99/modules/04/jar-files.html

-cheers,
Manish
 
J

Jeff Higgins

julielaurek said:
So I wanted to make this executable and I have successfully exported
it as a jar file. I am still learning so bear with my question if it's
stupid O:) but why doesn't the excel sheet get created anymore when I
launch the jar file?
Click to expand...

In addition to what Manish said:
add a classpath entry in the
manifest file for your POI library jar.

Class-Path: poi-3.0.1.jar //or whatever your jar is called.
 
J

Jacky

On 7 13 , 6 30 , "(e-mail address removed)"
to make this executable
Click to expand...
1. You can use jbuild guide(New->Archive) to make an executebale file.
2. since you've exported it as a jar file, make sure your jar file
have a correct manifest file, and the classpath is reachable in your
system envionment sets, otherwise, you can include all
dependencies(third-party lib) in your jar file.

Good lucky!
 
J

Jacky

to make this executable
Click to expand...


1. You can use jbuild guide(New->Archive) to make an executebale
file.
2. since you've exported it as a jar file, make sure your jar file
have a correct manifest file, and the classpath is reachable in your
system envionment sets, otherwise, you can include all
dependencies(third-party lib) in your jar file.

Good luck!
 
J

julielaurek

1. You can use jbuild guide(New->Archive) to make an executebale
file.
2. since you've exported it as a jar file, make sure your jar file
have a correct manifest file, and the classpath is reachable in your
system envionment sets, otherwise, you can include all
dependencies(third-party lib) in your jar file.

Good luck!
Click to expand...

Hey guys!

Thanks so much for replying. So I've been trying to follow everyone's
advice, in order:

Manish, I'm using Eclipse; that's where I created the jar file. Other
jar files I created had worked. I think I usually see two options when
trying to create the jar, one of which is to create one's own manifest
and the other, to let eclipse do it. I always did the latter =)

I'm following the link Manish gave me, and Jeff's advice, but I'm
slightly stuck: is there a way to view your class' current classpath?
I somehow learnt java without encountering that word till this
summer :-? Also, I keep on getting this error:
"jar is not recognized as an internal or external command operable
program or batch file".
and I'm googling solutions to that :) But if anyone has any, any
solutions, please do tell; my jar is located on my desktop, and I
think my java.exe is located here: C:\jdk1.5.0_12\jre\bin (among other
places)

I'll be trying jbuild next. I think the problems I have now are:
fixing the jar problem from the command prompt and
figuring out the proper way of finding and writing a classpath.

s.o.s

thanks for helping!

jl
 
J

julielaurek

julielaurek wrote:

Here's a pretty good article.
<http://www.ibm.com/developerworks/library/j-jar/>
Click to expand...


Thanks!!!!
I'm reading that and I got much further. Still trying to debug
something that has to do with my manifest file, but I think I'll get
there. The site says I can put my manifest somewhere not in the
application's directory. I had assumed that would mean it could track
down my manifest file wherever which is probably wrong since it sends
me a java.io.Filenotfoundexception file not found: MyManifest (not in
those exact words, but...)
I am also curious as to something in the line of the Excel sheet I
will be creating in th elong run. I know it's possible to make a
component visible via "setVisible", I think. Is there a way to do this
to an excel sheet? maybe casting it in some way to make it become a
component? I tried that but it didn't turn out too well...

Thanks

jl
 
J

Jeff Higgins

julielaurek said:
I'm reading that and I got much further. Still trying to debug
something that has to do with my manifest file, but I think I'll get
there. The site says I can put my manifest somewhere not in the
application's directory. I had assumed that would mean it could track
down my manifest file wherever which is probably wrong since it sends
me a java.io.Filenotfoundexception file not found: MyManifest (not in
those exact words, but...)
Click to expand...

I think I remember reading somewhere upthread that you are using Eclipse.
In that case here might be a better reference.
<http://help.eclipse.org/help32/index.jsp?topic=/org.eclipse.jdt.doc.user/tasks/tasks-33.htm>
also:
I am also curious as to something in the line of the Excel sheet I
will be creating in th elong run. I know it's possible to make a
component visible via "setVisible", I think. Is there a way to do this
to an excel sheet? maybe casting it in some way to make it become a
component? I tried that but it didn't turn out too well...
Click to expand...

I think, also from a earlier comment you made, that what you are asking is:
How can I open, in Excel, the worksheet that I just created, from my Java
program?
If that's the case, see:
<http://java.sun.com/j2se/1.5.0/docs/api/java/lang/ProcessBuilder.html>
If not, then I'm not sure.

PS - I was very easily able to run your SimpleSpreadsheetTest class from an
executable jar exported from Eclipse. Just be sure that you put a copy of
your POI.jar in the same directory as your executable SST.jar \or specify
where to find it in your manifest files' Class-Path: property.
 
J

julielaurek

I think I remember reading somewhere upthread that you are using Eclipse.
In that case here might be a better reference.
<http://help.eclipse.org/help32/index.jsp?topic=/org.eclipse.jdt.doc.u...>
also:


I think, also from a earlier comment you made, that what you are asking is:
How can I open, in Excel, the worksheet that I just created, from my Java
program?
If that's the case, see:
<http://java.sun.com/j2se/1.5.0/docs/api/java/lang/ProcessBuilder.html>
If not, then I'm not sure.

PS - I was very easily able to run your SimpleSpreadsheetTest class from an
executable jar exported from Eclipse. Just be sure that you put a copy of
your POI.jar in the same directory as your executable SST.jar \or specify
where to find it in your manifest files' Class-Path: property.
Click to expand...


it worked! i fixed my classpaths according to the websites (thanks for
those links, guys!) and i also think java couldn't find my poi jars
since they were in a folder in the jre library instead of just being
in the library.

Thanks a million!!!!!!!!!!!!!!!!

JL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Java: Using Piping or any other methods to use the output from one program as input in another. 12
poi and formating celds with colors (backgound) 0
Saving HSSFCellStyle in Excel file 3
HSSF workbook 0
problem with poi and row height 0
Java matrix problem 3
Java and apach poi = read Excel cell 3
Java OpenJDK Floating Point Dare 3

Members online

No members online now.
Total: 25 (members: 0, guests: 25)
Robots: 243

Forum statistics

Threads
473,755
Messages
2,569,537
Members
45,022
Latest member
MaybelleMa

Latest Threads

Top