Results 1 to 8 of 8
  1. #1
    anp24 is offline Member
    Join Date
    Nov 2010
    Posts
    4
    Rep Power
    0

    Default Excel to XML in Java

    Hello,
    I want to know how do I convert Excel files with VBA macros to XML in Java. The Excel Files are uploaded to the website which is developed using java.class files and uploaded as it is in a web server upload folder,

    Website URL is like
    http://192.168.1.176:8080/EFile/Uplo...riod=JUL+-+SEP

    but the excel files pose a security risk , because of macros. what sort of application infrastructure changes should be done so that Instead of Excel Files, XML files are accepted by the Website.

    Thank you
    Regards
    Anoop

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

    Default

    Pardon?
    I don't quite understand the requirement.
    Currently you upload Excel files, and now you only want to allow XML files?
    Then don't upload Excel files...

  3. #3
    anp24 is offline Member
    Join Date
    Nov 2010
    Posts
    4
    Rep Power
    0

    Default

    Hello,
    I want to know

    1. if Excel files with macros can be converted to XML files
    2. What application changes in java are to be done now so that it now accepts XML files instead of Excel Files. Does XML Serialization work?

    Thanks
    Regards
    Anoop

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

    Default

    1. What do you mean by "converted to XML files"?
    2. What do you do with the current Excel files? If all you do is save them in a database, then a file is a file as far as Blobs are concerned.

  5. #5
    anp24 is offline Member
    Join Date
    Nov 2010
    Posts
    4
    Rep Power
    0

    Default

    Hello,
    Excel Files with macros are uploaded as it is. But as macros pose security Threat, I want them to be converted into XML files first and then these XML files are uploaded onto the Web Server through the Website File Upload module. So what changes are to be done in java application so that they can accept XML Files for upload.

    Thanks
    Regards
    Anoop

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

    Default

    I don't think you really understand.
    The conversion of an Excel file into XML is entirely up to you. It doesn't make sense, especially if it's newer Excel in which case it's already XML...
    As I said, a file is a file, so simply upload an XML file.

    Let's try this again.
    I am a user of your system.
    I want to upload a file.
    My file is an Excel file.
    What do you want to happen?

  7. #7
    anp24 is offline Member
    Join Date
    Nov 2010
    Posts
    4
    Rep Power
    0

    Default

    Hello,
    Will Serialization concept work in this case
    Thanks
    Regards
    Anoop

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

    Default

    Do you have a reason for not actually answering my questions?

    Why do you want to serilaise this?
    It's a file!
    Just stream it to wherever you need to.

Similar Threads

  1. Java Connectivity with Excel
    By atul_kumar2038 in forum New To Java
    Replies: 1
    Last Post: 08-31-2010, 05:37 PM
  2. Java and Excel Application
    By java.reign in forum Java Servlet
    Replies: 1
    Last Post: 03-28-2010, 06:55 PM
  3. Java and Excel
    By Maro in forum New To Java
    Replies: 2
    Last Post: 08-03-2009, 05:32 PM
  4. Java results in Excel
    By puk284 in forum New To Java
    Replies: 1
    Last Post: 04-21-2009, 04:13 AM
  5. Excel to database using java
    By Priyadharshini.s in forum Advanced Java
    Replies: 1
    Last Post: 03-08-2008, 06:12 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
  •