Excel to XML in Java

[anp24]

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

[Tolls]

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...

[anp24]

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

[Tolls]

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.

[anp24]

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

[Tolls]

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?

[anp24]

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

[Tolls]

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.