Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Possible Classpath Error, Java POI API

807569May 18 2006 — edited May 29 2006
Hiya,

I'm not new to Java, well not that new, but the class path, packages and such have always been a bit of a blind spot for me. Once I finally get that part working the applications write themselves.

I've written an application that writes large grids as csv files, but I'd like to go a step further and add forumlae and formatting, therefore I've been looking at the Java POI HSSF API (http://jakarta.apache.org/).

I've downloaded the files from here: http://apache.mirror.positive-internet.com/jakarta/poi/release/bin/ and added them to my classpath (I think..), which I have pasted below [and have spaced out for ease of reading];

My Classpath

C:.; C:\Dev\JavaServer\bin;
C:\Dev\JavaLive\io\MySQL\mysql-connector-java-3.1.12-bin.jar;
C:\Dev\JavaLive\io\Excel\poi-2.5.1-final-20040804.jar;
C:\Dev\JavaLive\io\Excel\poi-contrib-2.5.1-final-20040804.jar;
C:\Dev\JavaLive\io\Excel\poi-scratchpad-2.5.1-final-20040804.jar;

%CLASSPATH%

My Test Code
import java.io.*;
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 exceltest
{
	public exceltest()
	{
		HSSFWorkbook wb = new HSSFWorkbook();
		FileOutputStream fileOut = new FileOutputStream("workbook.xls");
		wb.write(fileOut);
		fileOut.close();
	}

	public static void main(String args[])
	{
		new exceltest();
	}
}
I've checked the integrity of the the jar files, and the structure seems intact. Shouldn't adding the three jars to the classpath, as above, allow me to import them as above?

The following errors result at compile:
C:\Dev\JavaLive\exceltest.java:2: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFCell;
                                     ^
C:\Dev\JavaLive\exceltest.java:3: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFRow;
                                     ^
C:\Dev\JavaLive\exceltest.java:4: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFSheet;
                                     ^
C:\Dev\JavaLive\exceltest.java:5: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
                                     ^
C:\Dev\JavaLive\exceltest.java:17: cannot resolve symbol
symbol  : class HSSFWorkbook 
location: class exceltest
		HSSFWorkbook wb = new HSSFWorkbook();
                ^
C:\Dev\JavaLive\exceltest.java:17: cannot resolve symbol
symbol  : class HSSFWorkbook 
location: class exceltest
		HSSFWorkbook wb = new HSSFWorkbook();
                                      ^
6 errors

Tool completed with exit code 1
I've googled, searched the forums and such and have yet to turn up an answer. I assume it's something to do with the classpath as it's not seeing the package? Any help would be very appreciated.

Thanks

David

Message was edited by:
davidrhowells
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2006
Added on May 18 2006
5 comments
587 views