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

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

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

    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.