in reply to excel file read

it shows me error message like

"No Excel data found in file."

Replies are listed 'Best First'.
Re^2: excel file read
by vinoth.ree (Monsignor) on Mar 24, 2015 at 09:46 UTC

    No Excel data found in file

    The "no data found" error indicates some problem with the file format. I saw this error with pseudo-Excel files such as Html or CSV files that have an xls extension.

    All is well. I learn by answering your questions...
[reply]

      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

[reply]

        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.

[reply]

        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.

[reply]

        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

[reply]

        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 ?

[reply]

In Section Seekers of Perl Wisdom