Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Platform » Using POI in Eclipse
Using POI in Eclipse [message #304657] Tue, 13 June 2006 15:22 Go to next message
Eclipse UserFriend
Originally posted by: nateman5069.hotmail.com

I've been tasked with building a data import tool that will pull data from
an excel document and dump it in our oracle database. Unfortunately, I'm
new to Java and Eclipse.

My question is how do you setup POI in Eclipse. I downloaded the
POI-2.5.1-Final release from
http://apache.cs.utah.edu/jakarta/poi/release/bin/ . Then I tried adding
the 3 jar files (poi, poi-contrib, poi-scratchpad) to my Eclipse classpath
that I *think* is Window->Preferences->Ant->Runtime->Add External Jars. I
get a warning about tools.jar not being available and when I try using an
import statement, I do not have access to the org.apache.* packages.

I don't know if I need to recompile the jars first, if I'm in the wrong
classpath, if I need more than just poi, or what. I've been chugging at
this for days with no real headway. I have scoured google and cannot find
any good guides/tutorials for this. If anyone could point me in the right
direction I would greatly appreciate it!
Re: Using POI in Eclipse [message #304659 is a reply to message #304657] Tue, 13 June 2006 15:33 Go to previous messageGo to next message
Jeremy Dowdall is currently offline Jeremy DowdallFriend
Messages: 22
Registered: July 2009
Junior Member
is this for a stand-alone application, or RCP / Eclipse plugin?

Nate wrote:
> I've been tasked with building a data import tool that will pull data
> from an excel document and dump it in our oracle database.
> Unfortunately, I'm new to Java and Eclipse.
> My question is how do you setup POI in Eclipse. I downloaded the
> POI-2.5.1-Final release from
> http://apache.cs.utah.edu/jakarta/poi/release/bin/ . Then I tried adding
> the 3 jar files (poi, poi-contrib, poi-scratchpad) to my Eclipse
> classpath that I *think* is Window->Preferences->Ant->Runtime->Add
> External Jars. I get a warning about tools.jar not being available and
> when I try using an import statement, I do not have access to the
> org.apache.* packages.
> I don't know if I need to recompile the jars first, if I'm in the wrong
> classpath, if I need more than just poi, or what. I've been chugging at
> this for days with no real headway. I have scoured google and cannot
> find any good guides/tutorials for this. If anyone could point me in
> the right direction I would greatly appreciate it!
>
Re: Using POI in Eclipse [message #304661 is a reply to message #304659] Tue, 13 June 2006 16:12 Go to previous messageGo to next message
Danail Nachev is currently offline Danail NachevFriend
Messages: 36
Registered: July 2009
Member
Hi, Nate

The place you found to add this jars is related to the Ant build
scripts. You'll probably won't meet them soon as it seems.

The steps you need start with are, first, create java project. And then
in the properties of this project, there is an entry titled Java Build
Path where you can add the dependencies of your application (project).

Probably you need to get familiar with some common concepts among Java
(like classpath) and how the Eclipse is used.

Sorry, if you are already familiar with this and have something
different in mind. I may misunderstood you, so accept my apologies.

Regards,
Danail

Jeremy Dowdall wrote:
> is this for a stand-alone application, or RCP / Eclipse plugin?
>
> Nate wrote:
>> I've been tasked with building a data import tool that will pull data
>> from an excel document and dump it in our oracle database.
>> Unfortunately, I'm new to Java and Eclipse.
>> My question is how do you setup POI in Eclipse. I downloaded the
>> POI-2.5.1-Final release from
>> http://apache.cs.utah.edu/jakarta/poi/release/bin/ . Then I tried adding
>> the 3 jar files (poi, poi-contrib, poi-scratchpad) to my Eclipse
>> classpath that I *think* is Window->Preferences->Ant->Runtime->Add
>> External Jars. I get a warning about tools.jar not being available and
>> when I try using an import statement, I do not have access to the
>> org.apache.* packages.
>> I don't know if I need to recompile the jars first, if I'm in the wrong
>> classpath, if I need more than just poi, or what. I've been chugging at
>> this for days with no real headway. I have scoured google and cannot
>> find any good guides/tutorials for this. If anyone could point me in
>> the right direction I would greatly appreciate it!
>>
Re: Using POI in Eclipse [message #304662 is a reply to message #304659] Tue, 13 June 2006 16:25 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: nateman5069.hotmail.com

Stand-alone. I've found that if I add the jar files to the Java Build
path I can at least access the packages and get started.
Re: Using POI in Eclipse [message #304663 is a reply to message #304661] Tue, 13 June 2006 16:28 Go to previous message
Eclipse UserFriend
Originally posted by: nateman5069.hotmail.com

Thank you Danail. Yeah I have a lot to learn to say the least. I was
just starting to get frustrated when I've been stumped on this for a few
days.
Previous Topic:ICellEditorValidator error message
Next Topic:SWT Dialogs in 3.2RC7
Goto Forum:
  


Current Time: Fri Apr 19 00:49:33 GMT 2024

Powered by FUDForum. Page generated in 0.03171 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top