Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 6 of 6

Thread: Exporting Data to Excel Spreadsheet

  1. #1
    Junior Member
    Join Date
    May 2011
    Location
    Boulder, Colorado
    Posts
    18
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Exporting Data to Excel Spreadsheet

    Hi all,

    I am an undergraduate research aid for a biochemistry lab and am currently working to optimize the manner in which we analyze a lot of our data from our experiments. The program we currently use is an open source program called ImageJ which we utilized to track cancer cells and analyze their trajectories in our time lapse videos. The program is written in Java and the source code is free to download ( I posted a link below) and is beautiful and extensive code. However, for my project I simply need to optimize this program for our personal use and the main task at hand is exporting the trajectory data to an Excel spreadsheet. I am using Eclipse to edit my code and have read about JExcel API but wasn't sure how to really integrate this or if this would be compatible with Eclipse. Any help would be extremely helpful as I really am a true novice when it comes to coding in Java.

    ImageJ: Download
    Last edited by PineAppleKing; May 19th, 2011 at 01:34 PM.


  2. #2
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,262
    Thanks
    176
    Thanked 821 Times in 764 Posts
    Blog Entries
    5

    Default Re: Exporting Data to Excel Spreadsheet

    2 open source libraries I know of for excel: JExcel and Apache POI. Can't comment on JExcel but I've used POI with great success, just load it up as a 3rd party library in Eclipse (right click project -> Properties -> Java Build Path -> Libraries) and add it as a library. (PS. would be interested in hearing more about the research...)

  3. The Following User Says Thank You to copeg For This Useful Post:

    PineAppleKing (May 19th, 2011)

  4. #3
    Junior Member
    Join Date
    May 2011
    Location
    Boulder, Colorado
    Posts
    18
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Exporting Data to Excel Spreadsheet

    I'm trying to add the Apache POI to Eclipse as a Library, I assumed I would be using a User Library but the POI file I downloaded from the Apache website doesn't seem to contain a .Jar file to import. I also read on the website that I would need Apache Ant and Apache Forrest to run the POI. Do I actually need all of these and if so is there a general tip for locating the .Jar files in these rather extensive zip files?

  5. #4
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,262
    Thanks
    176
    Thanked 821 Times in 764 Posts
    Blog Entries
    5

    Default Re: Exporting Data to Excel Spreadsheet

    The latest stable binary download should contain a jar (in fact should contain a few jar's). I think it may require some of the accompanying jar's to run (such as log4j), but the website should outline the required libraries (as well as provide some examples for working with worksheets). If you downloaded something that requires ant you may have downloaded the source file rather than the binary

  6. #5
    Junior Member
    Join Date
    May 2011
    Location
    Boulder, Colorado
    Posts
    18
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Exporting Data to Excel Spreadsheet

    Alright I did indeed originally download the source file but after rectifying this problem I downloaded the binary and imported all the jar's I could find and then Eclipse separated them in the package explorer into Referenced Libraries and then one library I had to create on my own and named lib which contains the poi jar. Does this sound like a valid set up or have I muddled something up?

  7. #6
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,262
    Thanks
    176
    Thanked 821 Times in 764 Posts
    Blog Entries
    5

    Default Re: Exporting Data to Excel Spreadsheet

    You shouldn't really need to create a library named lib and add jars in there. Just place the required libraries where you see fit, and add them to the classpath (as described in my post above). This should be all that is needed...but if you can access the libraries and run/export the project the set up should be fine.

Similar Threads

  1. How to Connect to an Excel Spreadsheet using JDBC in Java
    By JavaPF in forum JDBC and Database Tutorials
    Replies: 14
    Last Post: August 27th, 2013, 11:57 AM
  2. Importing excel data
    By supriya ramjee in forum File I/O & Other I/O Streams
    Replies: 11
    Last Post: October 20th, 2012, 09:39 AM
  3. how to read chinese data from excel to java
    By swapna in forum File I/O & Other I/O Streams
    Replies: 5
    Last Post: November 17th, 2011, 06:02 AM
  4. Spreadsheet data - linked list or hashmap
    By j919 in forum Collections and Generics
    Replies: 2
    Last Post: February 19th, 2011, 05:04 PM
  5. How to fetch integer data from excel
    By nehakuls in forum JDBC & Databases
    Replies: 5
    Last Post: May 14th, 2010, 01:44 AM