Spreadsheet gem errors

[Dominic Sisneros]

[Note: parts of this message were removed to make it a legal post.]

I am using the spreadsheet gem to try to create workbook by copying the
first worksheet

work_book = Spreadsheet.open './test.xls'
sheet = work_book.worksheet 0

sheet2 work_book.add_worksheet(sheet)
sheet.name = "copy"

workbook.write('./test.new.xls')

I get a corrupt file with the following with the following log:

Microsoft Office Excel File Repair Log

Errors were detected in file
'C:\programming\ruby\circuits\lib\circuits\ZLC_BZN.Site.Specific.Requirements.2010-10-21.xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel
attempted to recover your formulas and values, but some data may have been
lost or corrupted.

does the add_worksheet function work and am I using it right?

Thanks,

dominic