Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: excel file read

by vinoth.ree (Monsignor)
on Mar 24, 2015 at 09:46 UTC ( [id://1121111]=note: print w/replies, xml ) Need Help??


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

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

Replies are listed 'Best First'.
Re^3: excel file read
by vasarabharat (Novice) on Mar 24, 2015 at 11:36 UTC

    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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1121111]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2024-03-29 14:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found