Results 1 to 3 of 3
  1. #1
    jazzermonty is offline Member
    Join Date
    Jan 2011
    Posts
    71
    Rep Power
    0

    Default Java, excel and xml. A pet project

    Ok, so I have this issue in work that I'm starting to think I will turn into a pet project just for the heck of it. The deal is I have a large number of customers that store information about courses in excel format. My company needs these customers to upload these courses in xml format. Since a large proportion of our customers don't have any IT support, I was thinking of creating a little project that would do this for them. Here's the idea:-

    Create a GUI that contains mandatory fields that the user can select from their excel spreadsheet (they have additional data in there that isn't compatible with our database, so a limited selection of columns is required).

    Take said data and create from it a hashmap.

    From the content of the hashmap output the xml files.

    My question to the forum is in two parts:

    First, would you do it this way? Or is there a better way to do this?

    Second, if you have done something like this before can you point me in the direction of some resources that will help with the development?

    I'm not sure yet if I will carry the project through, it all depends on the complexity of the solution as I will be doing this on my own time for no extra pay.

    Thanks folks

  2. #2
    joeyvitoro is offline Member
    Join Date
    Oct 2011
    Posts
    90
    Rep Power
    0

    Default Re: Java, excel and xml. A pet project

    If your goal is to make life easier on the customers, don't have them input data that already exists. If you don't want your program to interact with excel directly (which I totally understand), have them export their excel docs as tab delimeted text files or XML files. You can pick and choose which fields you want to save.

  3. #3
    jazzermonty is offline Member
    Join Date
    Jan 2011
    Posts
    71
    Rep Power
    0

    Default Re: Java, excel and xml. A pet project

    Hi Joeyvitoro

    Good advice, but unfortunately the level of proficiency ain't that great and the objective is for my staff to not have to manipulate the data second hand. To do what you want we would need to inform the customers of how to output the data in the desired format, then my team would need to receive this in some manner (probably email) then run it through some code to output the xml. Not idea which is why I was thinking of a project that would allow them to select the appropriate columns which would then create the xml output on the fly. You need to see the solution that's been designed already. Pretty much as you described only (slightly) worse. I'd rather my team didn't have to touch the data at all.

Similar Threads

  1. Convert PDF to Excel in Java?
    By Aschee in forum Advanced Java
    Replies: 2
    Last Post: 05-03-2011, 11:12 PM
  2. Java - Excel (Netbeans 6.9.1)
    By chyrl in forum Advanced Java
    Replies: 1
    Last Post: 12-30-2010, 06:55 PM
  3. Excel to XML in Java
    By anp24 in forum XML
    Replies: 7
    Last Post: 11-16-2010, 11:29 AM
  4. Java and Excel
    By Maro in forum New To Java
    Replies: 2
    Last Post: 08-03-2009, 05:32 PM
  5. Java results in Excel
    By puk284 in forum New To Java
    Replies: 1
    Last Post: 04-21-2009, 04:13 AM

Tags for this Thread

Posting Permissions

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