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

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

Replies are listed 'Best First'.
Re^5: excel file read
by marto (Cardinal) on Mar 24, 2015 at 10:31 UTC

    Changing the file extension does not change the format of the file, think of it as just a name. Renaming a .xls file to a .mp3 file will not result in it playing in iTunes. In excel click 'save as', under 'save as type' select 'Excel 97-2003 workbook(*.xls)' and save this somewhere. Alter the example code to read your new file.

[reply]
Re^5: excel file read
by Corion (Patriarch) on Mar 24, 2015 at 10:27 UTC

    You still have not told us what the error message is that Excel pops up and you click on.

    Excel is Excel and knows how to repair broken files. Perl does not know how to repair broken files.

    I recommend you get a valid version of the file instead of a broken file.

[reply]

In Section Seekers of Perl Wisdom