Results 1 to 4 of 4
  1. #1
    tomflaherty is offline Member
    Join Date
    Jul 2014
    Posts
    2
    Rep Power
    0

    Default Write a java program to fill an excel spreadsheet

    Hi there guys,

    I would say I'm a JAVA beginner - I studied it for a year at university, but that was a few years ago now, and have pretty much forgotten everything I've learned. However, I'm not asking for help with code, I'm asking you guys for help starting a little project I have in mind.

    Basically, my project is this:

    I have an excel spreadsheet, with a specific filename and location which doesn't change (e.g. C:/workbook.xls)
    What I would like to do is have a window open when I open an .exe file, and in this window is a bunch of check boxes, text areas and drop down boxes (I can implement these, that's about my level of JAVA)
    Then, when I click on a button in this window (for example, a button which says "Save"), the data from all these boxes and menus etc. goes into specific cells in the excel spreadsheet. Or if certain values are selected from a drop down menu, then a bunch of cells are empty. I'm sure you can get the gist of what I'm trying to achieve.

    Now, my question to you lot would be this: how would I even go about doing this? I've been trying to read up about this, and I've found some stuff pointing me to Apache POI, but I was wondering if any of you know of a better way of doing this?

    Many thanks :)

    Tom.

  2. #2
    makpandian's Avatar
    makpandian is offline Senior Member
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    450
    Rep Power
    6

    Default Re: Write a java program to fill an excel spreadsheet

    You are on right track.

    Please go through apache poi API documentation. Maybe you will know where to start and how to start.
    Mak
    (Living @ Virtual World)

  3. #3
    RamyaSivakanth's Avatar
    RamyaSivakanth is offline Senior Member
    Join Date
    Apr 2009
    Location
    Chennai
    Posts
    837
    Rep Power
    6

    Default Re: Write a java program to fill an excel spreadsheet

    Ramya:cool:

  4. #4
    tomflaherty is offline Member
    Join Date
    Jul 2014
    Posts
    2
    Rep Power
    0

    Default Re: Write a java program to fill an excel spreadsheet

    This is great, thanks guys!

Similar Threads

  1. Write two csv files to one excel with multiple sheets using java
    By sach.bms@gmail.com in forum New To Java
    Replies: 1
    Last Post: 12-10-2013, 10:10 AM
  2. Replies: 1
    Last Post: 04-26-2011, 02:25 AM
  3. generate excel spreadsheet
    By BigBear in forum Advanced Java
    Replies: 5
    Last Post: 04-27-2010, 02:44 PM
  4. Recovering data from Excel spreadsheet
    By Anubis in forum SWT / JFace
    Replies: 0
    Last Post: 12-17-2008, 08:28 PM

Posting Permissions

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