Re: Java version required for Apache POI 3.6

Thank you. Cheers, Parag On Thu, Aug 12, 2010 at 11:11 PM, Hingu, Sanjay (MLITS) wrote: > Hi Parag, > You have to user JDK version 1.5 or higher version for using apache POI > 3.6 > > Regards, > Sanjay > > -Original Message- > From: Parag Kalra [mailto:paragka...@gmail.com] > Sent: Fr

RE: Java version required for Apache POI 3.6

Hi Parag, You have to user JDK version 1.5 or higher version for using apache POI 3.6 Regards, Sanjay -Original Message- From: Parag Kalra [mailto:paragka...@gmail.com] Sent: Friday, August 13, 2010 11:39 AM To: POI Users List Subject: Java version required for Apache POI 3.6 Hi All, I

Java version required for Apache POI 3.6

Hi All, Is there any particular JDK/JRE dependency to make use of Apache POI 3.6 I am planning to use it with JDK 1.4.2 so not sure if would be able to use. Cheers, Parag

Re: Installation Problems

I'd think you need to specify a classpath that is accessible from the context of the browser's JVM, i.e. as URLs... Alternatively you could rebundle all the dependent jars into a single jar, Eclipse is capable of doing this kind of thing. On Aug 12, 2010, at 13:06, Thomas P Laford wrote: >

Re: POI appending zeros while adding numbers

On Thu, 12 Aug 2010, Parag Kalra wrote: However for some excel sheets while writting the data to text file, numbers are getting added with .0 All excel numbers are stored as floating point numbers, no matter if they're whole numbers of not. You probably want to look at the DataFormatter class

POI appending zeros while adding numbers

Hi All, I am using Apache POI to extract data from Excel file and print it to text file. However for some excel sheets while writting the data to text file, numbers are getting added with .0 For example - 999 is getting added as - 999.0 Snippet from my code for writting the data- *out.

XSSFCellStyles / CTCellStyles

Dear POI Users, I've been continuing working with CellStyles in XSSFWorkbooks. My goal is to deal with user-defined style names in XSSFWorkbooks. In HSSFWorkbooks the corresponding HSSFCellStyles support methods get/setUserDefinedName. However, for XSSFCellStyles there currently is no such func

Re: Installation Problems

On Thu, 12 Aug 2010, Thomas P Laford wrote: When I put my JApplet class in a JAR file with the five JAR files noted above, and try to run it in the appletview or IE7, it fails just like before Try unpacking all the jars, and including the class files. In many cases nested jars aren't used Ni

Re: Installation Problems

OK. I found dom4j. My class path now has the following JAR files: poi-3.6-20091214.jar poi-ooxml-3.6-20091214.jar poi-ooxml-schemas-3.6-20091214.jar xbean.jar dom4j-1.6.1\dom4j-1.6.1.jar When I write my class as a JFrame, and run it as an application it wo

Re: Installation Problems

Ok, I understand the dependencies, but where do I get org/dom4j/DocumentException? Thomas From: Nick Burch To: POI Users List Date: 08/12/2010 09:37 AM Subject: Re: Installation Problems On Thu, 12 Aug 2010, Thomas P Laford wrote: > Ok, I changed the code so it creates an application inst

Re: Installation Problems

On Thu, 12 Aug 2010, Thomas P Laford wrote: Ok, I changed the code so it creates an application instead of an applet. When I run it, I receive the same error for a DIFFERENT class: java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException http://poi.apache.org/overview.html#compon

Re: Installation Problems

Ok, I changed the code so it creates an application instead of an applet. When I run it, I receive the same error for a DIFFERENT class: java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException When I added "xbeans.jar" to my class path, the error changed to: java.lang.NoC

Re: Installation Problems

On Thu, 12 Aug 2010, Thomas P Laford wrote: It really shouldn't be this much trouble to use POI should it? Well, you are using an applet... I'd suggest you try with a normal, non applet program first, and ensure everything works properly there. When you're happy with your code, then and only

Re: Installation Problems

Still no success. As Ashish suggested, I updated the MANIFEST.MF file to include a class-path entry that included all the POI jar files. My MF file looked like this: Manifest-Version: 1.0 Class-Path: poi-3.6-20091214.jar; poi-contrib-3.6-20091214.jar; poi-examples-3.6-20091214

HSSF Fromatting Issues with Date

Hi, I am writing some data (Strings, Numeric as well as Dates) into an excel. The structure of the sheet is similar to what's shown below: STR_COL, DATE1_COL, NUM1_COL, DATE2_COL, DATE3_COL, DATE4_COL, NUM2_COL, DATE5_COL The dates are formatted with a custom formatter allowing for Timestamp. On

RE: Installation Problems

Still no luck. I upgraded to IE7 (that's the approved version for my company) and that didn't fix the problem. I copied the six poi-*.jar files into the directory with my java/class files and that didn't fix the problem. I created a JAR file by typing "jar cf MyApp.jar *.class poi*.jar" and I

Re: Installation Problems

here is a thread that talks about Applet classpath and recommended way of setting classpath for 3rd party library referred by Applet (read the last reply on that thread) http://www.velocityreviews.com/forums/t152635-java-applet-classpath.html hope that helps.

RE: Installation Problems

On Thu, 12 Aug 2010, Thomas P Laford wrote: Here's what I am using: IE6, JDK 6 update 21, POI 3.6. Is there something about JDK 6 update 21 that is incompatible with POI? I don't think so, however it's well known that java applets aren't ideal, and that old versions of IE are generally proble

RE: Installation Problems

Alas neither solution worked. When I looked at the registry (as David suggested) there was no CLASSPATH entry for the Java VM (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Java VM). In fact I searched and didn't find anything related to IE or Java that included a classpath. I tried Adrian's suggesti

[Announce] POI 3.7 beta 2

Hi All It's been about 6 months now since 3.6 FINAL, and a month since the last 3.7 beta. The changelog [1] shows we've fixed a fairly hefty number of bugs, even if there haven't been that many new features. So, we've decided to do a new beta release, of POI 3.7 Beta 2. Since POI 3.7 beta 1,

RE: Installation Problems

In my experience "Program Files" causes a problem (because I think due to the space) in the classpath try "progra~1" instead -Original Message- From: David Fisher [mailto:dfis...@jmlafferty.com] Sent: 11 August 2010 19:17 To: POI Users List Subject: Re: Installation Problems I am not sur