in reply to Re^2: excel file read
in thread excel file read

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

Replies are listed 'Best First'.
Re^4: excel file read
by Corion (Patriarch) on Mar 24, 2015 at 11:39 UTC

    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.

Re^4: excel file read
by marto (Cardinal) on Mar 24, 2015 at 11:39 UTC

    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.

Re^4: excel file read
by vasarabharat (Novice) on Mar 24, 2015 at 11:50 UTC

    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.

Re^4: excel file read
by vasarabharat (Novice) on Mar 24, 2015 at 12:04 UTC

    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.