Re^2: excel file read

Replies are listed 'Best First'.
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
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]
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]