I really appreciate your help in advance.
This is what i am trying to achieve.
I have a file say "test.xls" in some location say "X"
I wanted to open this file and read data of it, for which i already have a program that actually does it.
But the problem is, it does not recognize the file type, because even though the file name says test.xls the type of the file is a webpage(*.htm, *.html).
Now the workaround is to manually open the file and change the filetype to Microsoft Office Excel Workbook(.xls)
Once i do this, i am able to do anything with the file using Java.
I wanted to know if it is anyway possible to change the type of the file using Java, without having to include the manual steps. I am Automating this process. Please help, i can provide you with more information if my objective is not clear.
Excel Version: 2003