You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by hkwathome <hk...@yahoo.co.in> on 2011/06/09 09:57:03 UTC
HSSFSheet createRow
Hello ,
i am trying to copy the template excel sheet to a new sheet and populate the
data
my code works normal in Eclipse , but when i create the runnable jar from
eclipse , i am geeting following message for createRow ?
Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError:
org.apache.p
oi.hssf.usermodel.HSSFSheet.createRow(I)Lorg/apache/poi/hssf/usermodel/HSSFRow;
I am following reference as in :
http://www.coderanch.com/t/420958/open-source/Copying-sheet-excel-file-another
by Ph. Loep , Greenhorn
it works in Eclipse environment , but how do i put in Jar environment , i
have created runnable with required library jars.
Pl. help
regards
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/HSSFSheet-createRow-tp4471920p4471920.html
Sent from the POI - User mailing list archive at Nabble.com.
Re: HSSFSheet createRow
Posted by hkwathome <hk...@yahoo.co.in>.
Thanks for your reply , Your observation worked .. Thanks for the solution
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/HSSFSheet-createRow-tp4471920p4475245.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFSheet createRow
Posted by Dave Fisher <da...@comcast.net>.
Wow, POI 1.5.1 is nine years old. Do you have more than one version of POI in your Eclipse setup?
On Jun 9, 2011, at 5:31 AM, hkwathome wrote:
> Menifest file
> Name: common
> Implementation-Vendor: Apache Software Foundation
> Specification-Title: jakarta-poi
> Implementation-Title: jakarta-poi
> Implementation-Version: 1.5.1-final
> Specification-Version: 1.5.1
> Specification-Vendor: Apache Software Foundation
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFSheet createRow
Posted by Jon Svede <js...@yahoo.com>.
How are you building your runnable jar? Are you using an Ant build script? Or
using the Eclipse export wizard?
As Nick said earlier, this is really a procedural question that is better suited
to the Eclipse Forums. However, this is something that I am currently able to
do without issue and I am doing it with POI. I use plug-ins and the export
wizard.
I recently sent a post to this distro about how to create a plug-in from the POI
jars. You need to do that and then re-create your project as a plug-in.
To do this, create new project using the New Project Wizard, right click > New >
Other.
Then go down to the Plug-in Development node, expand it and select "Plug-in
Project".
On the first page of the subsequent wizard give your project a name (something
like com.mycompany.project) and a version number. Click next.
On the next page you can specify the provider and a name. In the "Options"
section below the naming stuff, there is a check box for "This plug-in will make
contributions to the UI" - uncheck that if it is checked. Next, select "no"
under the "would like to create a rich client application?". Click "Finish".
Expand your new project and go the META-INF/MANIFEST.MF. Click on the
Dependency tab in the Manifest Editor. On the left you can add plug-in
dependencies, so click 'Add' and start typing the name of your POI plug-in.
Select your project and click 'Ok'. Save the manifest. Now you can import your
dependencies.
Finally, you should now be able to right click on your project and run the
Export wizard to create a runnable jar file.
This is a medium level overview, there is more to understand about plug-in
development but I think this gets you most of the way there.
HTH,
Jon
________________________________
From: hkwathome <hk...@yahoo.co.in>
To: user@poi.apache.org
Sent: Thu, June 9, 2011 6:31:57 AM
Subject: Re: HSSFSheet createRow
I have put the following libraries in build path , i even tried fatjar (
sourceforge) , using extract runnable jar .. i am getting duplicate entries
for poi classes while creating extract runnable jar . but not able to
decipher the reason , it works in Eclipse , but not when i create runnable
jar . Yes Eclipse forum , yes .. meanwhile any poi developer came across
similar problem ?
HSSFSheet . HSSFRow class are there in the created runnable jar file , is
there any way to see the methos inside the jar ?
error log :
Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError:
org.apache.p
oi.hssf.usermodel.HSSFSheet.createRow(I)Lorg/apache/poi/hssf/usermodel/HSSFRow;
Menifest file
Name: common
Implementation-Vendor: Apache Software Foundation
Specification-Title: jakarta-poi
Implementation-Title: jakarta-poi
Implementation-Version: 1.5.1-final
Specification-Version: 1.5.1
Specification-Vendor: Apache Software Foundation
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/HSSFSheet-createRow-tp4471920p4472542.html
Sent from the POI - User mailing list archive at Nabble.com.
Re: HSSFSheet createRow
Posted by hkwathome <hk...@yahoo.co.in>.
Thanks for your reply , i now know more about the plug-in
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/HSSFSheet-createRow-tp4471920p4475248.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFSheet createRow
Posted by hkwathome <hk...@yahoo.co.in>.
I have put the following libraries in build path , i even tried fatjar (
sourceforge) , using extract runnable jar .. i am getting duplicate entries
for poi classes while creating extract runnable jar . but not able to
decipher the reason , it works in Eclipse , but not when i create runnable
jar . Yes Eclipse forum , yes .. meanwhile any poi developer came across
similar problem ?
HSSFSheet . HSSFRow class are there in the created runnable jar file , is
there any way to see the methos inside the jar ?
error log :
Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError:
org.apache.p
oi.hssf.usermodel.HSSFSheet.createRow(I)Lorg/apache/poi/hssf/usermodel/HSSFRow;
Menifest file
Name: common
Implementation-Vendor: Apache Software Foundation
Specification-Title: jakarta-poi
Implementation-Title: jakarta-poi
Implementation-Version: 1.5.1-final
Specification-Version: 1.5.1
Specification-Vendor: Apache Software Foundation
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/HSSFSheet-createRow-tp4471920p4472542.html
Sent from the POI - User mailing list archive at Nabble.com.
Re: HSSFSheet createRow
Posted by Nick Burch <ni...@alfresco.com>.
On Thu, 9 Jun 2011, hkwathome wrote:
> i am trying to copy the template excel sheet to a new sheet and populate
> the data my code works normal in Eclipse , but when i create the
> runnable jar from eclipse , i am geeting following message for createRow
>
> Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError:
> org.apache.poi.hssf.usermodel.HSSFSheet.createRow(I)Lorg/apache/poi/hssf/usermodel/HSSFRow;
Sounds like you're not packaging poi correctly in your app. You'll want to
ask on an eclipse user group/forum for information on correctly embedding
other jars
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org