On Thu, Jan 24, 2013 at 4:56 PM, Andy Davis <
andy....@koanhealth.com> wrote:
> Frustrating thing is that I can do that and more:
>
> wb = Spreadsheet.open('./tmp/analysis.summary.xls')
> puts "Opened Spreadsheet, #{wb.sheet_count} sheets encountered"
>
> (0..wb.sheet_count-1).each do |sheet_number|
> ws = wb.worksheet(sheet_number)
> puts "\tWorksheet #{
ws.name} has #{ws.row_count} rows and
> #{ws.column_count} columns}"
> end
>
> This works fine. I get the right number of sheets, the right titles for the
> sheets, and the right dimensions for all sheets. It only seems to be once I
> get into the sheets that the rows are apparently empty.