Results 1 to 11 of 11

Thread: EXCEL sheets

  1. #1
    mai1234 is offline Member
    Join Date
    Jan 2011
    Posts
    7
    Rep Power
    0

    Default EXCEL sheets

    hey guys,

    i need to know what is the best way or the best thing to use to read data from a billing system that generates information automatically and creating an excel sheet and writing the data in it with a good format (using tables, borders, maybe pics...etc)

    will appreciate your fast reply
    thank you!

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Apache's POI HSSF/XSSF.

  3. #3
    goldest's Avatar
    goldest is offline Senior Member
    Join Date
    Oct 2009
    Location
    Pune, India
    Posts
    469
    Rep Power
    5

    Wink

    Have a look here: Apache POI

    Goldest
    Java Is A Funny Language... Really!
    Click on * and add to member reputation, if you find their advices/solutions effective.

  4. #4
    mai1234 is offline Member
    Join Date
    Jan 2011
    Posts
    7
    Rep Power
    0

    Default

    does Apache POI allow me to set a password for the file to be created???
    any other suggestions of an API that would allow me to set a password for the file or any type of security and draw graphs inside the file?
    Thanks

  5. #5
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Except maybe for some commercial (see non-free proprietory software) you are not going to find any better Excel API than POI. So, download, read its documentation, and see if it can do what you want. If not, start looking for a commercial library.

  6. #6
    JosAH's Avatar
    JosAH is online now Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,521
    Blog Entries
    7
    Rep Power
    20

    Default

    It always surprises me how many people want to play with Excel files and sheets in Java (without having googled for the available APIs). I personally find Excel's computational model terrible, i.e. it protests against every recurrence relation and it's awfully slow. But then again, I don't think bean counters are interested in recurrence relations or anything else funny ...

    kind regards,

    Jos
    cenosillicaphobia: the fear for an empty beer glass

  7. #7
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    My thoughts exactly.

  8. #8
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    To tell you the truth, I used to find Andy Khan's JExcel better (simply because it was simpler), and if I know that I will never be using Excel 2007 or newer (which I never will know that unless its simply a small one-off thing) I still use that one, but it can't, AFAIK, handle Excel 2007+ which gives POI the edge again (as bloated as that project is).

    Edit: And I never use Excel, personally, but my employer wants to see it again and again, so I'm kinda stuck with it.

  9. #9
    JosAH's Avatar
    JosAH is online now Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,521
    Blog Entries
    7
    Rep Power
    20

    Default

    Quote Originally Posted by masijade View Post
    Edit: And I never use Excel, personally, but my employer wants to see it again and again, so I'm kinda stuck with it.
    Yep, employers are like that: they like to see huge stupid matrixes with a bunch of uncorrelated numbers in them. And they want to print them out too so they can wave them to other people. Possibly with their name printed on them to show how important those numbers are. And they (accidentally) make copies of them all over the place. And they send them to other people by email (lots of recipients, all with their own copy of those sheets). Excel is fun. ;-)

    kind regards,

    Jos
    cenosillicaphobia: the fear for an empty beer glass

  10. #10
    mai1234 is offline Member
    Join Date
    Jan 2011
    Posts
    7
    Rep Power
    0

    Default

    hey guys
    i downloaded the Apache POI but i cant use it!
    i am using Jcreator and each time i initialize a project and add the zip file to the libraries and still i get a blank page with nothing imported, what should i do?

  11. #11
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Have you actually written anything to use the library? Or do you expect it to just "magically" import the thing? The library is just a tool. An API. You still, of course, need to write code to use it. See its documentation.

Similar Threads

  1. Reading from EXCEL sheets
    By javaplus in forum Advanced Java
    Replies: 5
    Last Post: 07-13-2012, 04:46 AM
  2. Adding multiple sheets in Excel (apache POI)
    By javanewbie in forum Advanced Java
    Replies: 0
    Last Post: 06-22-2009, 04:51 AM
  3. Importing excel sheets into java application
    By blizzard in forum New To Java
    Replies: 1
    Last Post: 04-02-2009, 09:59 PM
  4. Cascading Style Sheets
    By smart in forum JavaServer Pages (JSP) and JSTL
    Replies: 1
    Last Post: 12-27-2008, 05:25 PM
  5. ms excel
    By cool_gal in forum New To Java
    Replies: 9
    Last Post: 07-20-2007, 03:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •