From: Dominic Sisneros <dsisnero@...>
Date: 2010-10-22T07:25:56+09:00
Subject: Spreadsheet gem errors

--0016361e82fc8702bd0493280186
Content-Type: text/plain; charset=ISO-8859-1

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

--0016361e82fc8702bd0493280186--