can u tell me how to handle with that

i think i also have the same problem..

coz when i try to save as the file type it by default is web page instance

if it is not actual xls file then how can i read the data from it like excel?

plz help me

Have you looked at your file to determine the real file type?

The file command can tell you a good guess of the real file type.

Also with a hex editor, maybe you can find out the real file type yourself.

What are you trying to tell us? That you're trying to save an Excel file as a web page? Read and understand How do I post a question effectively?, collect your thoughts and explain exactly what you are doing.

I have downloaded the file for sec/edgar/filings/ interactive data view in excel

which is in both the format some are in xlsx and some in xls..

the files with .xlsx extention works well with the module spreadsheet::XLSX

but when the file is in .xls format i need to do parsing with Spredsheet::ParseExcel

that i know very well

bothe the file comes from same source then its obvious that both are in excel format and excel files .

then why i cant open the .xls file that is my question

If you can't open them with Spreadsheet::ParseExcel, they are broken. If you want to repair them, open them in Excel and then save them again using Excel.

yes it works

thanks

but sir i have too many files n my script should do all this thing itself

is it possible to do this process of "save as" by script ?

Yes, automate the process using Win32::OLE, as Corion previously mentioned. There are many examples of using this module to automate the Microsoft Office applications. I suggest you take the time to research this optoin rather than rapidly post questions asking for help. You are also replying to yourself and not to the person you think you are.