Results 1 to 6 of 6
  1. #1
    neodjandre is offline Member
    Join Date
    May 2014
    Posts
    2
    Rep Power
    0

    Default Java Recommendation for task

    Hello all

    I am looking to develop a program that does the following:

    User selects Microsoft Excel xlsx, xlsm files
    Program copies worksheets, userforms and modules from a template excel file into the user files
    Program changes the XML schema of the files

    I am looking for MAC compatibility too. Is Java suitable for this exact requirements I am asking?

    many thanks
    Andy

  2. #2
    SurfMan's Avatar
    SurfMan is offline Godlike
    Join Date
    Nov 2012
    Location
    The Netherlands
    Posts
    1,083
    Rep Power
    4

    Default Re: Java Recommendation for task

    What if someone says yes? What will you do next? What if someone says no? Will you try .Net? Your question is a bit vague at least.

    An xlsx file is basically a zip file containing the files that make up the Excel sheets. If you have the knowledge how to reverse engineer those, you can use any programming language you want. Hell, you can even do it in Perl. Whatever floats your boat...
    "It's not fixed until you stop calling the problem weird and you understand what was wrong." - gimbal2 2013

  3. #3
    neodjandre is offline Member
    Join Date
    May 2014
    Posts
    2
    Rep Power
    0

    Default Re: Java Recommendation for task

    thank you Surfman... Specific points are MAC compatibility and changing XML schema of the files. If this can be done with Java - I will learn Java and do it!

  4. #4
    SurfMan's Avatar
    SurfMan is offline Godlike
    Join Date
    Nov 2012
    Location
    The Netherlands
    Posts
    1,083
    Rep Power
    4

    Default Re: Java Recommendation for task

    Compatibility with a Mac is not an issue: you either can read or can't read xlsx files on a Mac. Changing the schema is changing a text file. Both these subjects have nothing to do with Java.

    Have you tried this by hand?
    - Unzip the xlsx
    - Modify the required xml file
    - Zip it back to xlsx
    - Read it with a Mac?

    If you can do this, then Java, C#, C++, Perl, <insert favourite language here> can do it too.
    "It's not fixed until you stop calling the problem weird and you understand what was wrong." - gimbal2 2013

  5. #5
    gimbal2 is offline Just a guy
    Join Date
    Jun 2013
    Location
    Netherlands
    Posts
    4,354
    Rep Power
    6

    Default Re: Java Recommendation for task

    Its the programmer who is suitable or not; the tool does not matter. You can pick the programming language that can be used to design the Matrix; if someone with no experience uses it, things won't go well. But a professional developer can probably eventually get something done with only access to an assembler.

    So yeah, look in the mirror. Can you do it? Do you have the skills required?
    "Syntactic sugar causes cancer of the semicolon." -- Alan Perlis

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Java Recommendation for task

    Quote Originally Posted by neodjandre View Post
    thank you Surfman... Specific points are MAC compatibility and changing XML schema of the files. If this can be done with Java - I will learn Java and do it!
    If you don't already know how Java works then this is not exactly a simple learning task.
    How long have you got?
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Replies: 1
    Last Post: 05-09-2012, 12:06 AM
  2. wrapper recommendation
    By newbie123 in forum New To Java
    Replies: 0
    Last Post: 12-16-2011, 09:04 PM
  3. Replies: 5
    Last Post: 02-03-2011, 07:20 AM
  4. File Uploader Recommendation?
    By rsquaredpgh in forum Java Applets
    Replies: 1
    Last Post: 10-13-2010, 04:46 AM
  5. Recommendation about databases
    By tommy in forum JDBC
    Replies: 2
    Last Post: 07-28-2007, 06:04 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
  •