Re: excel file read

What is the message that Excel shows you?

My guess is that the file is corrupt. If it is corrupt, then your only approach is to open it in Excel and save it again so the file gets repaired.

You may want to look at Win32::OLE to automate this if you have to deal with broken Excel files more often.

Comment on Re: excel file read

Replies are listed 'Best First'.
Re^2: excel file read by vasarabharat (Novice) on Mar 24, 2015 at 10:18 UTC
how can i perform save as operation using script. if i want to save my .xls file as .xlsx	[reply]
Re^3: excel file read by Corion (Patriarch) on Mar 24, 2015 at 10:20 UTC
Have you read the module I linked to, Win32::OLE? Also see Using Win32::OLE and Excel - Tips and Tricks. But maybe your file already is in XLSX format but only named wrong? Have you tried opening the file using Spreadsheet::ParseXLSX?	[reply]
Re^4: excel file read by vasarabharat (Novice) on Mar 24, 2015 at 10:26 UTC
yes i already tried it to open it with spreadsheet::xlsx but it not works also i tried to rename directly by extension change form xls to xlsx but then it shows me curupted file i cant understand excel itself shows data then what the problem with perl	[reply]
Re^5: excel file read by marto (Cardinal) on Mar 24, 2015 at 10:31 UTC
Re^5: excel file read by Corion (Patriarch) on Mar 24, 2015 at 10:27 UTC
Re^3: excel file read by Tux (Canon) on Mar 24, 2015 at 12:41 UTC
Websites lie. Period. I know a website that has a `[Download as XLS]` button that saves the data in a file called `data_20150324.csv`, which is actually HTML with a huge table. YMMV Enjoy, Have FUN! H.Merijn	[reply] [d/l] [select]