Bugs: Browse | Submit New | Admin

[#26513] Can't parse excel file with spreadsheet

Date:
2009-07-03 21:35
Priority:
3
Submitted By:
Alexander Logvinov (vcub)
Assigned To:
Nobody (None)
Category:
worksheet
State:
Closed
Summary:
Can't parse excel file with spreadsheet

Detailed description
Hello!

 I can't read attached file with spreadsheet.

Here is sample test program:

require 'spreadsheet'

workbook = Spreadsheet.open("schedule.xls")
worksheet = workbook.worksheet(0)
worksheet.each { |row| puts "#{row.idx}: #{row}" }

Here is output:

1:
2:
...
910: 
911: 
912: 
913: 


  Is there any chance to get it work? Thanks!

WBR

Add A Comment: Notepad

Please login


Followup

Message
Date: 2009-09-17 22:40
Sender: Alexander Logvinov

It works! Thanks a lot! 
Date: 2009-09-17 14:46
Sender: Hannes Wyss

Released in 0.6.4.1
Date: 2009-09-16 08:43
Sender: Hannes Wyss

Alexander,

Thanks for reporting this! Your Excel file has no ROW op entries,
which is a bit unexpected.

Fixed in http://scm.ywesee.com/?p=spreadsheet;a=commit;h=68e683a8
6c871ef43068e9c314feee457e18df79
queued for inclusion in 0.6.4.1

cheers
Hannes
Date: 2009-09-15 17:05
Sender: Zeno R.R. Davatz

Can you imagine why any ROW-Opcode would be missing in this file?
Could this have to do with the version with witch the Excel File
was written?
Date: 2009-07-13 10:32
Sender: Alexander Logvinov

Hello!

 Sorry to say I don't know how it created. :( I downloaded
this file from TV channel site. Thanks Björn!

WBR
Date: 2009-07-13 08:34
Sender:  

Hi!

I've had a similar problem with Excel 95 files, namely those
created by the earlier Spreadsheet::Excel-library (<6.0).
Is this maybe the case for this file as well?

/Björn

Attached Files:

Name Description Download
schedule.xls Excel file Download

Changes:

Field Old Value Date By
close_date2009-09-17 22:402009-09-17 22:40vcub
status_idOpen2009-09-17 14:46hwyss
resolution_idNone2009-09-17 14:46hwyss
close_date2009-09-17 14:462009-09-17 14:46hwyss
File Added4594: schedule.xls2009-07-03 21:35vcub